R12:An Active Sequence Assignment is Required

Applies to:

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

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.