Unable to complete an OPM batch in OSP warehouse

Applies to:

Oracle Process Manufacturing Process Execution – 11i

While trying to complete an OPM batch in an OSP warehouse occasionally one can get the following error message,

ORA-20009: Purchase Order Not Associated

ORA-06512: at “APPS.JA_IN_GEM_BTCH_HDR_T1”, line xxx

ORA-04088: error during execution of trigger

‘APPS.JA_IN_GEM_BTCH_HDR_T1’ in Package GME_BATCH_HEADER_DBL Procedure

UPDATE_ROW

Cause:

APPS.JA_IN_GEM_BTCH_HDR_T1 trigger is restricting not to complete the batch.

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

select status from all_triggers where trigger_name = 'JA_IN_GEM_PM_BTCH_HDR_T1'

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

alter trigger JA_IN_GEM_PM_BTCH_HDR_T1 disable;

This is a standard bug in oracle 11i version. I have faced this issue many a times and have raised 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.

Once you complete the problematic batch don't forget to enable the trigger with the following query.

alter trigger JA_IN_GEM_PM_BTCH_HDR_T1 enable;

---X---