Recipe Details Not Collected When Plant Resource Not In The Same Org (Doc ID 452567.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.0.0 and later
Information in this document applies to any platform.
FORM:MSCFNSCW.FMB - Planner Workbench


Symptoms

Under certain circumstances the recipe validity rule is not collected.

STEPS
1. Set up a recipe with a validity rule that includes a route and take the validity rule through to Approved for general use.

Process Engineer / Recipes (GMDRCPED)
Process Engineer / Recipes : Validity Rules button (GMDRVRED)
Process Engineer / Process Routings (GMDROTED)

2. Run a Standard Collection, complete refresh:

Advanced Supply Chain Planner / Advanced Supply Chain Planning / Collections / Oracle Systems / Standard Collection

3. Check the ASCP Collection Workbench for the Process Effectivity:

Advanced Supply Chain Planning/ Advanced Supply Chain Planning/ Collections/ View Collected Data
(select the OPM organization), View By Items, Drill down Plans / Collections/ Category, click on the item, right click/ Bom/Routing/ Process Effectivity

The following errors are also seen in the MSCPDPW module: Planning Data Pull Worker for all resource types, primary, auxiliary and secondary:

validate_routing returned Invalid for Organization_id <organization_id from mtl_parameters> routing_id <routing_id from gmd_recipes_b>  rtg_hdr_location <id> fmeff_id <recipe_validity_rule_id from gmd_recipe_validity_rules>

and this is supplemented further (line appears above the error above) when the missing resource is the primary resource with:

Missing Plant Resource <Resource Code>

 Further the following error is also encountered:

find_routing_header returned Invalid for Organization_id 107 routing_id <routing_id from gmd_recipes_b>

 These errors should not be viewed in isolation.  There are occurrences  of where some, a couple or all of these errors are seen.  Regardless it is necessary to check for the missing data as set out below.

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