GST: OPM Batch Error APP--20110: Encountered the error in trigger JAI_OPM_GBH_ARIUD_T1 (Doc ID 2430129.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Symptoms

On : 12.1.1 and above
-----------------------

Reported Issue
-----------------
Batch completion error.
At the time of Batch completion shows the error. This is observed quite frequently.

ERROR
-----------------------
Un-expected User-Defined Exception occurred

Entering api GME_COMMON_PVT.setup
Exiting api GME_COMMON_PVT.setup
Entering api GME_COMPLETE_BATCH_PVT.COMPLETE_BATCH
GME_COMPLETE_BATCH_PVT.COMPLETE_BATCH
GME_COMPLETE_BATCH_PVT.COMPLETE_BATCH actual_cmplt_date=
Entering api GME_BATCH_HEADER_DBL.UPDATE_ROW
Inside update_row for batch_id:
When others exception in GME_BATCH_HEADER_DBL.UPDATE_ROW Error is ORA-20001:
APP--20110: Encountered the error in trigger JAI_OPM_GBH_ARIUD_T1ORA-00001:
unique constraint (JA.JAI_OPM_TXN_EXTN_HDRS_U1) violated
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.JAI_OPM_GBH_ARIUD_T1", line 256
ORA-04088: error during execution of trigger 'APPS.JAI_OPM_GBH_ARIUD_T1'
Entering api GME_COMMON_PVT.log_message
FROM LOG_MESSAGE GME_UNEXPECTED_ERROR/ERROR/User-Defined Exception//////////
Exiting api GME_COMMON_PVT.log_message
Entering api GME_BATCH_HEADER_DBL.fetch_row
Retrieving batch id: 
Exiting api GME_BATCH_HEADER_DBL.fetch_row

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete batches

Changes

Cause

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