Accrual Reconciliation Load Run Fails With Exceptions ORA-01422, ORA-01001 (Doc ID 1364787.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 18-03-2013***

Symptoms

On : 12.1.3 version, Accrual Accounting

When attempting to run the 'Accrual Reconciliation Load Run' for the first time (after upgrading from Release 11.5.10.2 to Release 12.1.3), it takes 14 hours, and DBA has to bounce the system, then
the following error occurs after user tried to resubmit the job again.

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 4107
ORA-01422: exact fetch returns more than requested number of rows

DBA applied <patch.12984761>:R12.BOM.C ACCRUAL RECONCILIATION LOAD RUN REPORT TAKING MORE TIME and validated the file versions
bom patch/115/sql CSTACCLB.pls 120.27.12010000.32
bom patch/115/sql CSTACCLS.pls 120.0.12010000.2

now they are getting the following error

EXCEPTION FND_API.g_exc_error IN accrual_load
EXCEPTION FND_API.g_exc_error IN accrual_load
l_stmt_num :10
l_stmt_num :10
x_msg_count:0
x_msg_count:0
x_msg_data :
x_msg_data :
accrual_load - l_err_status:E
accrual_load - l_err_status:E
accrual_load - l_err_count :0
accrual_load - l_err_count :0
accrual_load - l_err_data :
accrual_load - l_err_data :
start_accrual_load-
start_accrual_load-


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.AP Corporate Manager (Payables application) > Run "Accrual Reconciliation Load Run"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with regular operations.

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