RECIPE NOT COLLECTED WHEN THE ROUTING STEP QUANTITY IS ZERO

(Doc ID 1076987.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Process Planning - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2011***


Symptoms


When attempting to collect recipe details for a production recipe within OPM, the following error occurs.

ERROR
-----------------------

MSCPDPW module: Planning Data Pull Worker


Recipe <id> has ZERO step qty
validate_routing returned Invalid for Organization_id <id> routing_id <id> rtg_hdr_location 1fmeff_id <id>
find_routing_header returned Invalid for Organization_id <id> routing_id <id>

For 11.5.10.2 these errors can also present as:


validate_routing returned Invalid for plant code routing_id rtg_hdr_location

find_routing_header returned Invalid for plant code routing_id


and the recipe details are not seen as collected in the ASCP Collections Workbench (process effectivity)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the ASCP Standard Collection, complete refresh
2. view the error in the log file
3. See the recipe details are not collected.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot collect and therefore cannot plan for these products and ingredients.

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