Create Accounting Oracle Error ORA-20001: "No active sequencing assignment was found" (Doc ID 2656146.1)

Last updated on JULY 25, 2024

Applies to:

Symptoms

Create Accounting Process is completing in error:

ERROR
-----------------------

Create Accounting Error: The Create Accounting process ended with a status of Error because one of its child processes failed.
Create Accounting subprocess error:

 xla_evt_update_events() 11-JAN-2020 09:27:33
XLA_AP_FATAL_SQL_ERROR! Module: xla_evt_update_events, Statement: Call XLA_FSN_ACCT_CHILD_PKG.postprocess_entries, Oracle error: ORA-20001: No active sequencing assignment was found. Verify your assignment for ledger {LED_NAME}, sequencing event {SEQ_EVENT} and journal entry type {JRNL_ENTRY_TYPE}.
ORA-06512: at "FUSION.XLA_FSN_ACCT_CHILD_PKG", line 2283
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Go to schedule processes and run Create Accounting process.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot close the period.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.