JAI_OPM_GMD_ARIUD_T1

If you get this error message while doing material correction in a batch in OSP (Outside Processing) Organization, don’t worry this is a standard bug in Oracle R12.

nexpected ORA-20001: APP—20110: You can not reduce the

Actual Quantity

ORA-06512: at “APPS.APP_EXCEPTION”, LINE 72

ORA-06512: at “APPS.JAI_OPM_GMD_ARIUD_T1”, line 206

ORA-04088: error during execut

Cause:

APPS.JAI_OPM_GMD_ARIUD_T1 trigger is restricting from doing corrections in the batch.

With the help of following query, we can check the status of the trigger.

select status from all_triggers where trigger_name = ‘APPS.JAI_OPM_GMD_ARIUD_T1’

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

alter trigger APPS.JAI_OPM_GMD_ARIUD_T1 disable;

After doing the corrections in the batch enable the trigger.

alter trigger APPS.JAI_OPM_GMD_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---