Accrual Reconciliation Load Has Performance Issues and Errors with EXCEPTION OTHERS in Load_ap_po_data
Last updated on JUNE 28, 2016
Applies to:Oracle Purchasing - Version: 12.1.3
Information in this document applies to any platform.
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
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
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.
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