JAI_OPM_GBH_ARIUD_T1

If you get this error message while trying to revert the status of a batch in OSP (Outside processing) organization, disable the trigger and change the status of the batch.

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 256

In Package GME_BATCH_HEADER_DBL Procedure UPDATE_ROW

Solution:

Check the status of the trigger.

select status from user_triggers where trigger_name = 'JAI_OPM_GBH_ARIUD_T1'

If the status of the trigger is enabled, disable it with the following query.

alter trigger JAI_OPM_GBH_ARIUD_T1 disable;

After changing the status of the batch, enable the trigger.

alter trigger JAI_OPM_GBH_ARIUD_T1 enable;

Note:

This bug was there in 11i also. Oracle hasn’t provided the full functionality of OSP concept in Process manufacturing as they did for discrete manufacturing.

I have faced this issue many a times and have risen SR’s regarding this issue to oracle, for which the oracle suggests to disable the trigger and complete the batch. Since for process manufacturing (OPM) module, oracle is not supporting OSP concept (no 57F4 challan) there is no harm in disabling the trigger.

---X---