Cannot Delete Routing Step, Get Error "APP-GMD-81208: This routing step has recipe-specific data in one or more recipes" (Doc ID 2007243.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, Product Development Routings/Recipes

On Process Routing Details form, when trying to delete a routing step, get error:

APP-GMD-81208: This routing step has recipe-specific data in one or more recipes

even though the two recipes that use the routing have no data for this routing step in gmd_recipe_routing_steps.

ERROR
-----------------------
APP-GMD-81208: This routing step has recipe-specific data in one or more recipes


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to delete a step from a routing

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot delete the routing step.

Cause

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 hundreds of Community platforms