R12: Posting Error PERF0005: Oracle Error in glpsqs, ORA-20001: An Active Sequence Assignment is Required[@more@]

Subject:	R12: Posting Error PERF0005: Oracle Error in glpsqs, ORA-20001: An Active Sequence Assignment is Required
	Doc ID:	602643.1	Type:	PROBLEM
	Modified Date :	03-AUG-2008	Status:	PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle General Ledger - Version: 12.0
This problem can occur on any platform.
Posting

Symptoms

When attempting to post a journal, the following error occurs

PERF0005: Oracle error detected in glpsqs() - ORA-20001: An active sequence assignment is required.
ORA-06512: at "A

Changes

None

Cause

Accounting sequence has been wrongly defined in the Accounting Set Up.

Accounting sequences are not required or used for the ledger, but this is enabled by checking the "Require Assignment" box in the processing options in the accounting set up.

However, assignments have not been defined or enabled. When posting is submitted, it will search for an active sequence assignment. Since it has not been defined for the ledger, posting will error out with the above error.

Solution

Disable the accounting sequence required check box.

Go to GL > Accounting Set Up Manager > Sequencing (Update) > Uncheck the option for "Require Assignment.

This will disable the requirement for assignment.

Resubmit posting.

Keywords

SEQUENCE~ASSIGNMENTS;

ITPub博客

R12过账错误