My Oracle Support Banner

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

Last updated on JULY 05, 2023

Applies to:

Oracle Fusion Payables Cloud Service - Version and later
Information in this document applies to any platform.


Create Accounting Process is completing in 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

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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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