My Oracle Support Banner

Close Period Process Ends With Error (Doc ID 2706870.1)

Last updated on OCTOBER 12, 2023

Applies to:

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


On : version, Period Close Setup & Processing

Close period process ends with error for Subledger Applications

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

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

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


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.