My Oracle Support Banner

RECIPE NOT COLLECTED WHEN THE ROUTING STEP QUANTITY IS ZERO (Doc ID 1076987.1)

Last updated on AUGUST 20, 2018

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

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


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.