My Oracle Support Banner

R12: AP: Create Accounting Concurrent Program is Failing with ORA-01555: Snapshot Too Old (Doc ID 2742619.1)

Last updated on JANUARY 11, 2021

Applies to:

Oracle Payables - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Accounting Issues in AP

When attempting to run create accounting program ,
the following error occurs.

ERROR

-----------------------
XLAACCUP: Accounting Program
+---------------------------------------------------------------------------+

Current system time is 01-JAN-2021 21:00:18

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

[01-JAN-2021 21:00:18]: **Starts**
[01-JAN-2021 21:00:45]: **Ends**
An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-01555: snapshot too old: rollback segment number 9 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_ae_lines_pkg.AccountingReversal. ORA-01555: snapshot too old: rollback segment number 9 with name "$TE








Changes

 System is upgraded and low memory has been set while initializing database parameters 

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
Changes
Cause
Solution


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