My Oracle Support Banner

There are Duplicate Steps Displaying on the Step Quantities section of Recipe Details (Doc ID 2479477.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Product Development Recipes

Because of a previous bug involving copying a recipe and changing the routing version, customer has many recipes in which steps show up twice on Step Quantities section of Recipe Details. This is because gmd_recipe_routing_steps contains routing steps that are not in the current routing (routingstep_id in gmd_recipe_routing_steps does not match the routingstep_id in the routing used on the recipe).

If the problem exists in just one recipe, the routing steps that are not part of the current routing on the recipe can be easily deleted from gmd_recipe_routing_steps with a simple script. If, however, there are many recipes with this issue, a more complicated script is needed to identify and delete these.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.