My Oracle Support Banner

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

Last updated on OCTOBER 01, 2020

Applies to:

Oracle Purchasing - Version 12.1.3 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

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
References


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