My Oracle Support Banner

GST: ASN / ASBN created ap invoice error during validation 'ora-00001: unique constraint (ap.ap_invoice_distributions_U1) violated ' (Doc ID 2487349.1)

Last updated on JANUARY 19, 2021

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 AP invoice (which is created from source :ASN , ASBN ) as it is failing with a validation error.

Error message (from shard fnd debug log )
-------------------------------------------------------
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.jai_insert_ap_inv_dist() 2 ORA-00001: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 4 --1: ORA-00001: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX 6 ORA-20001: --1: ORA-00001: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
ZX.PLSQL.ZX_API_PUB.VALIDATE_DOCUMENT_FOR_TAX 1 JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = E

Error message via screen shots
-------------------------------------------
unexpected error occurred during tax calculation
Exception : Encountered the error in jai_tax_processing_pkg.calculate_tax
ora-20001: -1:
ora-00001: unique constraint
(ap.ap_invoice_distributions_U1) violated
please correct the problem or contact your system administrator .

Steps for replication
---------------------------
1.During first time validation tax lines gets inserted in Jai_Tax_lines table but the invoice status is in needs re validation due to system holds(i.e.Quality).
2.When we try to re validate the invoice subsequently we are getting the unique constraint error.


Business criticality
--------------------------
Due to this issue vendor payments were stalled and impacting their goods / services which are to be rendered.

Changes

 

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


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