My Oracle Support Banner

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 AUGUST 19, 2019

Applies to:

Oracle Financials for India - Version 12.1.1 and later
Information in this document applies to any platform.

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

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
Cause
Solution


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