My Oracle Support Banner

Error :Unepected error pi_trx_id ->XXXXORA-00001 unique constraint JA.JAI_IRN_DETAILS_N1 violated (Doc ID 2858385.1)

Last updated on MARCH 05, 2023

Applies to:

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

Symptoms

Reported Issue
--------------
On clicking "complete" button on AR invoice with GST taxes, an error is observed. This is preventing to complete the AR invoice and equally generation of tax invoice number.

Error Message (from screen shots)
-------------
Unexpected Error pi_trx_id-->XXXXORA-00001: unique constraint (JA.JAI_IRN_DETAILS_N1) violated

Error message (from fnd debug log)
-------------
JAI.PLSQL.JAI_AR_TAX_DET_PKG.determine_manual_ar_tax Encountered an error in JAI_AR_TAX_DET_PKG.determine_manual_ar_tax. ,Unexpected Error pi_trx_id-->XXXXORA-00001: unique constraint (JA.JAI_IRN_DETAILS_N1) violated
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX Encountered an error in JAI_AR_TAX_DET_PKG.determine_manual_ar_tax. ,Unexpected Error pi_trx_id-->XXXXORA-00001: unique constraint (JA.JAI_IRN_DETAILS_N1) violated
ZX.PLSQL.ZX_API_PUB.VALIDATE_DOCUMENT_FOR_TAX JAI_TAX_PROCESSING_PKG.CALCULATE_TAX RETURN_STATUS = E
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.END ZX_API_PUB: DUMP_MSG()-

Steps For Replication
---------------------
1. (N): Oracle Receivables - Transactions -Transactions.
2. Enter invoice information and (N) to tools- India Tax details menu to apply GST related taxes.
3. Save.
4. Complete the invoice.
5. An error is observed.

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


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