24A Period Close is failing on Reporting Sequence call
(Doc ID 3006212.1)
Last updated on FEBRUARY 22, 2024
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.13.24.01.0 and laterInformation in this document applies to any platform.
Symptoms
General Ledger period closure goes into error with below statement:
-----------------------------------
Calling XLA_REPORTING_SEQUENCE_PKG.period_close for Period - <Period> , Ledger - <LedgerID>
Reporting sequence generation failed for period: <Period>
Please verify the reporting sequence error at bottom of the log file.
........
xla.plsql.xla_reporting_sequence_pkg.reporting_sequence=>BEGIN of procedure reporting_sequence:<Date>
xla.plsql.xla_reporting_sequence_pkg.reporting_sequence=>p_ledger_id:<LedgerID>p_period_name: <Period>p_mode:ASSIGN
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>Enter: xla.plsql.xla_reporting_sequence_pkg.process_sequence_main:<Date>
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>parameter: ledger_id:<LedgerID> period_name:<Period> p_mode:ASSIGN
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>request_id:9xxxxxxx
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>calling fun_seq_batch.batch_init
Verifying Sequence Definition for XLA:<Date>
Skipping delete on fun_seq_requests table
for terminal requests
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>xla_seq_status:SUCCESS l_context_le_tbl_xla.count:XXX
Verifying Sequence Definition for GL:<Date>
Skipping delete on fun_seq_requests table
for terminal requests
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>p_retcode = 2
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>p_errbuf =
xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>END of procedure assign_sequence
xla.plsql.xla_reporting_sequence_pkg.reporting_sequence=>end of procedure reporting_sequence
-----------------------------------------
Cause
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
Symptoms |
Cause |
Solution |
References |