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.

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

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
Symptoms
Cause
Solution


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.