My Oracle Support Banner

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


To view full details, 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 a vibrant support community of peers and Oracle experts.