24A Period Close is failing on Reporting Sequence call (Doc ID 3006212.1)

Last updated on FEBRUARY 22, 2024

Applies to:

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

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