My Oracle Support Banner

Accrual Reconciliation Load Run Returns Error ORA-01555: snapshot too old (Doc ID 2409999.1)

Last updated on APRIL 23, 2019

Applies to:

Oracle Purchasing - Version 12.2.1 and later
Information in this document applies to any platform.


"Accrual Reconciliation Load Run" is having performance issues. After running long time, the request ends with the following error on the log file:


Upgrading WO and WO details Receiving data
EXCEPTION OTHERS in Upgrade_old_data :10 - ORA-01555: snapshot too old: rollback segment number 395 with name "_SYSSMU395_2408821444$" too small
Upgrade_old_data API fails with
x_msg_count = 1

The issue can be reproduced at will with the following steps:
1. Run Accrual Reconciliation Load Run
2. Wait until it completes and see error on log file

The tkprof trace file show performance issue with the following query:



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.