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