Getting Error ORA-01403: No Data Found In Package Gme_create_step_pvt Procedure CREATE_BATCH_STEP Trying to Create a Batch with Multiple Steps (Doc ID 1915694.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Getting error ORA-01403: no data found in Package gme_create_step_pvt Procedure CREATE_BATCH_STEP while creating a batch if the recipe is having multiple operations

Based on investigation of one recipe, it looks like this may be caused by corrupt data in gmd_recipe_routing_steps. This has been known before to cause this error, and the recipe looked at does indeed have a row in gmd_recipe_routing_steps that has a routingstep_id that is not in the actual routing; in fact, the routingstep_id is 0, which is not valid.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms