My Oracle Support Banner

Accrual Reconciliation Load Run Performance (Doc ID 2409999.1)

Last updated on JUNE 12, 2018

Applies to:

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

Symptoms

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

ERROR
-----------------------

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
l_stmt_num:10
Upgrade_old_data API fails with
x_msg_count = 1

STEPS
-----------------------
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:

 

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!


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