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---

GMF_SQL_ERROR (ERRCODE=1) (ERRM=User-Defined Exception)

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later

When we try to do a transaction in a batch on batch material transaction screen occasionally one can get the following error message.

GMF_SQL_ERROR (ERRCODE=1) (ERRM=User-Defined Exception)

Solution:

Run “GMF Recreate Batch / Period Layers” concurrent request under OPM financials for the particular batch and try again to transact. The problem will be resolved.

Let’s understand what is “GMF Recreate Batch / Period Layers” & how the issue is resolved???

“GMF Recreate Batch / Period Layers” concurrent request removes potential data problems (Ex: the details of a batch have been updated but these changes are not reflected in the layer cost tables)

In case if the data is stuck in the interface, GMF Recreate Batch / Period Layers will push the data into the appropriate material transaction table.

---X---

The Period cannot be retrieved from the OPM Inventory Calendar

Applies to Version 11.5.10

In some cases when we try to create or complete an OPM batch we will encounter an error like this,

“The Period cannot be retrieved from the OPM Inventory calendar, for Batch 1545, Line 2 and Item 520025”



Let’s first try to understand why an error like this is coming,

The recipes and products where batches are created might have relatively short routings associated with them and hence the batches that are created have a planned completion date within the existing OPM Inventory calendar.

For the recipes and products that are failing one of the operations, is longer and hence the planned completion date falls to the next period. In this case when the next period is not opened we will encounter this error.

The most feasible solutions are opening the next period in OPM Inventory Calendar and try once to create or complete the batch.

Still if you face the same issue check the Production Rule quantity for the particular Item and adjust the quantity.

---X---