Accrual Reconciliation Load Has Performance Issues and Errors with EXCEPTION OTHERS in Load_ap_po_data (Doc ID 1337282.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Purchasing - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

The Accrual Reconciliation Load Run program runs for more than 30 hours when it is run for the first time. The program completes in error .
The same issue is not faced in other operating units.
The program gets completed in an optimum time in other OU's even for first run of load run program.
The error in the log file is

ERROR
-----------------------
EXCEPTION OTHERS in Load_ap_po_data 40 ORA-01422: exact fetch returns more than requested number of rows
EXCEPTION OTHERS in accrual_load ORA-01001: invalid cursor
ORA-06512: at "APPS.CST_ACCRUAL_LOAD", line 4186
ORA-01422: exact fetch returns more than requested number of rows
l_stmt_num:70


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Accrual Reconciliation Load Run program for the Operating Unit
2. Wait for the program to complete.


Changes

Happens following an upgrade from an earlier release.

Cause

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 hundreds of Community platforms