PERF0005: Oracle error detected in glpsqs() - ORA-20001:An active swquence assignment is required. ORA-06512

Issue:
PERF0005: Oracle error detected in glpsqs()  - ORA-20001:An active swquence assignment is required. ORA-06512

Fix:

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 fail with the above error.

To check if the sequence is assigned and active for categories, run the following sql

SELECT led.name,

      app.application_name,

      jct.user_je_category_name,

      dsa.category_code,

      dsa.doc_sequence_id,

      ds.db_sequence_name,

      dsa.method_code,

      dsa.start_date Assgn_St_date,

      dsa.end_date Assgn_End_date,

      ds.start_date Seq_st_Date,

      ds.end_date Seq_End_Date,

      ds.type

 FROM fnd_doc_sequence_assignments dsa,

      fnd_document_sequences ds,

      gl_je_categories_tl jct,

      gl_ledgers led,

  fnd_application_tl app

WHERE dsa.doc_sequence_id = ds.doc_sequence_id

  AND jct.je_category_name = dsa.category_code

  AND app.application_id = ds.application_id

  AND led.ledger_id = dsa.set_of_books_id

  AND dsa.end_date < (sysdate - 30) -- Shows seq assignments which ended less than 30 days before the current date

  AND led.ledger_id = &LedgerId;

To disable the accounting sequence required check box as follows :-

1. Go to GL > Accounting Set Up Manager > Sequencing (Update)

2. Uncheck the option for "Require Assignment.

3. This will disable the requirement for assignment.

4. Re-submit posting.