My Oracle Support Banner

Draft accounted Journal entries did not get transfer to GL(when attempting to final account and transfer to GL) Verify your assignment for ledger {LED_NAME}, sequencing event {SEQ_EVENT} (Doc ID 2556861.1)

Last updated on OCTOBER 23, 2019

Applies to:

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


On : version, Cost Management

Transaction Type

Transaction Type>Account Issue, Type>Account source
related transactions (dated back to 2017) not getting transferred to GL(stayed as draft accounted)

Transaction getting transferred to GL(accounted in final mode)

The issue can be reproduced at will with the following steps:
1. Run period end validation realized that 62 old transactions stayed as a draft accounted
When Create accounting is run in final mode(with transfer to GL as yes) these 62 transaction not getting transferred to GL"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",



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.