High Projected Available Balance (PAB) With Transient Safety Stock In EDD Plan (Doc ID 1264886.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-May-2013***

Symptoms

Two hidden profiles introduced under <bug 6036164> have been forward ported to 12.0.6 CU 9 (see bug 9109733) but not to R12.1.3.

1.Profile: MSC_MAKE_SS_TRANSIENT
Purpose: To make safety stock transient.


2.Profile: MSC_IGNORE_SS_IN_LEAD_TIME
Purpose: Do not create planned orders for SS inside the item's lead time when Yes

Development then updated the bug stating that MSC_IGNORE_SS_IN_TIME_FENCE is renamed to MSC_IGNORE_SS_IN_LEAD_TIME in 12.1.3. The implementation is the same in 12.0 and 12.1;i.e. to zero out the safety stock within lead time. Both profiles are hidden so the customer needs to set them up manually.

IMPORTANT NOTE 25-NOV-2013:  This profile above 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

However, even after this, the customer's position is that there is still a bug that is causing the high PAB in the sense that MBP seems to be pulling in all the lower priority future planned orders to peg to the current transient SS, even when there is supply (onhand or PO's) available.
The functionality offered by the profile options is not going to work for the customer as the visibility of Safety Stock inside of leadtime is a key requirement

Details on setting up the 2 profiles

1. Using Application Developer responsibility.
2. Navigate to Profile
3. In the Profiles screen

Name: MSC_IGNORE_SS_IN_LEAD_TIME
User Name: "MSC: Ignore Safety Stock calculation inside Time Fence"
Purpose: Profile is set to yes then do not create planned orders for SS inside the item lead time.
Default Behaviour: 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"
Purpose: Profile is set to yes then safety stock is treated as transient.
Default Behaviour: 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)"

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