Create Accounting : xla_je_validation_pkg.balance_by_intercompany. ORA-01555: snapshot too old

 

Subledger Accounting: Version : 12.2

 

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

 

XLAACCUP: Accounting Program

Current system time is 22-DEC-2022 13:44:37

An internal error occurred.  Please inform your system administrator or support representative that:

 

An internal error has occurred in the program xla_je_validation_pkg.balance_by_intercompany.  ORA-01555: snapshot too old: rollback segment number 3 with name "$TEMPUNDOSEG" too small.

An internal error occurred.  Please inform your system administrator or support representative that:

 

An internal error has occurred in the program xla_je_validation_pkg.balance_by_intercompany.  ORA-01555: snapshot too old: rollback segment number 3 with

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

22-DEC-2022 13:44:37 - Executing Unit Processor ...

22-DEC-2022 13:44:37 - Initializing variables

22-DEC-2022 13:44:37 - Security Context Set

22-DEC-2022 13:44:37 - Ready to cache the Application and Ledger Level Sources ...

22-DEC-2022 13:44:37 - Cached the Application and Ledger Level Sources

22-DEC-2022 13:44:37 - AAD Package XLA_00200_AAD_C_011116_PKG is valid. Ledger Category is PRIMARY.

22-DEC-2022 13:44:37 - Entering the loop to read document units from the queue ...

22-DEC-2022 13:44:37 - Checking status of the parent Accounting Program

22-DEC-2022 13:44:37 - Dequeuing the unit from the queue

22-DEC-2022 13:44:37 - Fetching event information for the documents in the unit

22-DEC-2022 13:44:37 - executing extract hook

event key = 63721-34119153-F070E62F466F19F7E0533301660A48CB

22-DEC-2022 13:44:38 - extract hook executed successfully

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

Fix:

we need to set following dynamic parameter values at PDB level

SQL> alter session set container=PDB;

Session altered.

 

SQL> alter system set temp_undo_enabled=false;

 System altered.

 

SQL> alter system set undo_retention=10000;

 System altered.