GST: Data Fix to Validate PO Matched AP Invoices which are failing with error ORA-00001: unique constraint (AP AP_INVOICE_DISTRIBUTIONS_U1) (Doc ID 2442876.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

Reported Issue
-------------------------------------------
Unable to validate few PO Matched invoices.
When trying to validate , it throws an error message.

Error message Observed during invoice validation ( from front end)
---------------------------------------------------------------------------
Unexpected error occurred during Tax Calculation.
Exception: Encountered the error in 
JAI_TAX_PROCESSING_PKG.CALCULATE_TAXORA-20001: --1:
ORA-00001: unique constraint
(AP AP_INVOICE_DISTRIBUTIONS_U1) violated
Please correct the problem or contact your System 
Administrator.

Error message generated via Fnd debug log 
------------------------------------------------
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAXORA-20001: --1: ORA-00001: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
AP.PLSQL.AP_ACCOUNTING_EVENT_PKG.update_invoice_events_status Begin of procedure update_invoice_events_status
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "Unexpected error occurred during Tax Calculation.
Exception: Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAXORA-20001: --1: ORA-00001: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
Please correct the problem or contact your System Administrator."

Steps for replicating
--------------------------
Issue is NOT reproducible but observed for existing PO Matched invoices.

Expectation 
--------------
Looking for an approach to validate all these problematic PO Matched invoices. 

Cause

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