Error 'ORA-00001: UNIQUE CONSTRAINT (AP.AP_INVOICE_DISTRIBUTIONS_U1) VIOLATED' During Invoice Validation
(Doc ID 2443983.1)
Last updated on DECEMBER 04, 2023
Applies to:
Oracle Financials for India - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.X/12.2.X version, GST Payables
When User is validating invoice, he is getting following error:-
ERROR
-----------------------
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.
In FND Debug log message, following error message has been captured.
JAI.PLSQL.JAI_TAX_DETERMINATION_PKG.jai_insert_ap_inv_dist() ORA-00001:
unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log --1: ORA-00001: unique
constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX ORA-20001: --1: ORA-00001:
unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Invoice.
2. Validate the invoice
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot make vendor payment on time.
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 |
| References |