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
Last updated on JUNE 07, 2018
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms