My Oracle Support Banner

Planned Orders With An Alternate Routing and/or Alternate Recipe Not Saved And Released Properly - WIP Mass Load May Error (Doc ID 1509724.1)

Last updated on JUNE 21, 2021

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

 Organization: M2

                                                                                                            Process      Process

  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:      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


                     Possible causes:

                     - Routing was changed between collections to planning server and the release.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.