Planned Orders With An Alternate Routing and/or Alternate Recipe Not Saved And Released Properly - WIP Mass Load May Error
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
IMPORTANT NOTE: Several issue have been discovered for this functionality in different phases of the update and release steps. The Solution below will guide to other notes and patches that are required to resolve all known issues.
We have many make items that have a primary routing and an alternate routing.
In order to level load our master schedule, we attempt to Release some of these planned orders attached to the alternate routing.
We do this by Selecting the planned order in the supply window, clicking the For Release checkbox, and selecting the alternate routing in the Implement Alternate Routing field in the Release Properties tab.
We save the record. We now have a planned order marked For Release identified to implement with the Alternate Routing.
After we release, the work order is created with the primary routing, not the alternate routing.
WIP Mass Load may error and output file shows error as follows
-- This happens in a constrained plan when the ALT BOM component and routing details are sent to WIP_JOB_DTLS_INTERFACE table
Group ID: 4067754 Report Date: 16-APR-2013 15:46
Job and Schedule Interface Report Page: 1 of 1
Create Discrete Jobs
Source Code: MSC
Job Job Type Assembly Quantity Start Date Completion Date Kanban Card Phase Status
------------- ------------ ------------- ---------- --------------- --------------- ----------- --------- --------
251014 Standard SA-2 100.00 19-APR-13 19:54 22-APR-13 08:54 Validation Error
Error: VALIDATION ERROR HAPPENED!
Error: 4067662 : System cannot change/delete the following material requirement because the requested
job/operation/inventory_item_id_old combo does not exist:
job (job_name): 251014
job id (wip_entity_id): 754082
operation (operation_seq_num): 10
material requirement item: RM-15
item id (inventory_item_id_old): 219959
- Routing was changed between collections to planning server and the release.
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