My Oracle Support Banner

ASCP Considers Non Effective Routing Operation And Creates Duplicate Planned Orders (Doc ID 1577762.1)

Last updated on JANUARY 27, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms - Unconstrained

The customer disabled the effectivity on a routing step and then enabled it again minutes later.

org A
Assembly Item AS100
Component CP222

Routing Operations for AS100 shows the effective date from 13-JUN-2013 10:42:54 with disable date 14-JUN-2013 09:05:02
Routing Operations for AS100 shows the effective date from 14-JUN-2013 09:05:22 with disable date 11-MAR-2016 00:00:00
Plan run date was 13-JUN-13.
Please find the planned order 9708533 in msld_supplies.dat.

ASCP planned resources for both dates (the disabled date and the enabled date).
Expected results: receive resource requirements for only the effective period.

A similar issue was reported in bug 14486158 was logged (status 32).
As a result of this bug, Enhancement Request 15827813 was raised - PLANNING ENGINE SHOULD RESPECT THE ROUTING EFFECTIVE DATES.
We are now several months later and the customer logged a new SR with the same problem definition. The reason for a new bug is that the
customer "can't accept/agree to the solution provided and does not suit their business".

Answer from bug 14486158.
When we push down the demand from the assembly to the component, ASCP will check the effectivity control of the assembly to determine the effective component.
If the effectivity control of assembly set to 'Date', the effective component will depend on effective and disable date.
If the effectivity control of assembly set to 'Model/Unit Number', the effective component will depend on from_unit_num and to_unit_num.

Effectivity Control of Model/Unit Number should only be used if you have Oracle Project Management installed/implemented. If you have Oracle Project Management and set Effectivity Control to Model/Unit Number you need to define the Unit Numbers are well. For more information, please refer to the Oracle Inventory User's Guide.

The valid values are 1 or 2.
 1 = Date
 2 = Model/Unit Number

The customer's expectation is that a planned order should have been created based on the operation whichever is effective on the demand date.
The customer uses Project Management and cannot use Date effectivity control that is defined in the Bills of Material tab of the item setup.
In summary, the customer is looking for an alternative solution than described in bug 14486158.


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.