Accrual Reconciliation Load Run Error 'EXCEPTION OTHERS in Load_ap_po_data 75 ORA-00001: unique constraint (BOM.CST_RECONCILIATION_SUMMARY_U1) violated'

(Doc ID 2366947.1)

Last updated on MARCH 04, 2018

Applies to:

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


On : 12.0.6 version, Accounting
When attempting to run the 'Accrual Reconciliation Load run program', it completes with
the following error occurs.

EXCEPTION FND_API.g_exc_error IN accrual_load
l_stmt_num :5
x_msg_data :
accrual_load - l_err_status:E
accrual_load - l_err_count :0
accrual_load - l_err_data :
EXCEPTION OTHERS in Load_ap_po_data 75 ORA-00001: unique constraint (BOM.CST_RECONCILIATION_SUMMARY_U1) violated
Load_ap_po_data API fails with x_msg_count : 1

The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing Responsibility
2. Run the concurrent program ''Accrual Reconciliation Load run'
3. It completes with the above error.


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