SCO Only Planned Orders For Non Transient (Hard) Safety Stock Not Created When There's No Demand Other Than On Hand Being Below Safety Stock (Doc ID 1323113.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Constrained Planning (SCO Specific) in UAT - Go live 10-APR-2011

Important: Users are using Legacy Collections and Run a Constrained ECC Plan Without Detailed Scheduling

Users are upgrading from 11.5.10 to 12.1.3 and have applied 12.1.3.3 patch 10389190. Through Legacy collections they bring in safety stocks which are non-transient (ie hard requirements). In 11.5.10 they do not have this issue. Users have found that planned orders for safety stock are not generated in an unconstrained ASCP. We created the following profile options in their system and set them to No but it still doesn't work:

Name: MSC_IGNORE_SS_IN_LEAD_TIME
User Name: "MSC: Ignore Safety Stock calculation inside Time Fence"
Application: Advanced Supply Chain Planning
Purpose: Do not create planned orders for SS inside item lead time when Yes. 
IMPORTANT NOTE 25-NOV-2013:  This has been changed as per bug 17576933 - it used to say make safety stock qty 0 inside Planning Time Fence but it's never worked that way .  What this profile does is not create planned orders for Safety Stcok inside the lead time for the item.  The lead times used are Pre Processing, Processing, Post Processing and Fixed Lead Time.  We Do Not Use Variable Lead Time.  Also the SQL validations were incorrect and they have been fixed below

Default Behavior: If the value is not set then it will be treated as Yes.
Values: This is YES/NO profile and should be defined at site level.
In the Application field, choose "Advanced Supply Chain Planning".

SQL validation
SQL= "select meaning \"MSC_IGNORE_SS_IN_LEAD_TIME \",
lookup_code
into :visible_option_value,:profile_option_value
from fnd_lookups where lookup_type = 'YES_NO'"
COLUMN="\"MSC_IGNORE_SS_IN_LEAD_TIME \"(4)"

Name: MSC_MAKE_SS_TRANSIENT
User Name: "MSC: Make Safety Stock Transient"
Application: Advanced Supply Chain Planning
Purpose: Profile is set to yes then safety stock is treated as transient.
Default Behavior: If the value is not set then it will be treated as Yes.
Values: This is YES/NO profile and should be defined at site level
In the Application field, choose "Advanced Supply Chain Planning".
SQL validation
SQL= "select meaning \"MSC_MAKE_SS_TRANSIENT \",
lookup_code
into :visible_option_value,:profile_option_value
from fnd_lookups where lookup_type = 'YES_NO'"
COLUMN="\"MSC_MAKE_SS_TRANSIENT \"(4)"



We find that in many cases where the safety stock is not generated, there is no actual demand, but the safety stock is higher than the available on hand and would expect a planned order to be created. Also they noted that for the plan_id in question, in 11.5.10 there's only one row for the item in table msc_safety_stocks. But in R12 there are two rows, one with the anchor date of the plan and one more a day later which we can't figure out. We thought the profiles would fix the problem but they did not. also the safety stock is not shown in the Safety Stock section of the horizontal plan.

MSO: Use Safety Lead Time = No
MSC: Ignore Safety Stock in Lead Time = No
MSC: Make Safety Stock Transient = No

EXPECTED BEHAVIOR
-----------------------
Expect safety stock planned orders to be generated since on hand is lower than safety stock

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Collect Data via Legacy Collections
2. Run ASCP unconstrained plan
3. Review items and check for safety stock generation

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