Close Period Process Ends With Error (Doc ID 2706870.1)

Last updated on OCTOBER 12, 2023

Applies to:

Symptoms

On : 11.13.20.07.0 version, Period Close Setup & Processing

Close period process ends with error for Subledger Applications

ERROR
-----------------------
The close period process for two ledgers for JUN-20, ends with error in Prod instance:

alling XLA_REPORTING_SEQUENCE_PKG.period_close for Period - JUN-20 , Ledger - XXXXXXXXXXXXXXXX
Reporting sequence generation failed for period: JUN-20
Please verify the reporting sequence error at bottom of the log file.

p_calling_program = REPORTING

xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>p_retcode = 2

xla.plsql.xla_reporting_sequence_pkg.process_sequence_main=>p_errbuf = No active sequencing assignment was found. Verify your assignment for ledger {LED_NAME}, sequencing event {SEQ_EVENT} and journal entry type {JRNL_ENTRY_TYPE}.

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Period Close for Subledgers
2.Check it ends in Error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Close period for two ledgers for Subledger applications

Cause

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