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!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|