R12:An Active Sequence Assignment is Required

 

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

 

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.