My Oracle Support Banner

Firm Supply Allocation Window Functionality Is Not Working (Doc ID 2729108.1)

Last updated on NOVEMBER 17, 2020

Applies to:

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

Symptoms

12.2.9

PROBLEM
-------------
Our requirement - On hand should be allocated and pegged to Sales Order demand first and followed by forecast demand within item Lead time window.

Solution: We wanted to use Item specific Firm Supply Allocation Window functionality by setting up below steps to meet this.

1. We are using Order priority rule to generate Order priories for Sales Orders and Forecast. Screen shot attached.
2. Setup Profile MSO: Multiplier to Derive Supply Allocation Window = 1.2
  Items are Buy Items, so Processing lead time should be considered while calculating the Supply allocation window.

Therefore, expectation is for Buy item, Calculated Supply allocation window = Processing lead-time * MSO: Multiplier to derive supply allocation window = 70*1.2 = 84 days

3. MSO: Demand Window Size = 900 days
4. We are using priority pegging. see the screen shot of plan options.

Scenario here: Order Priorities have been calculated during Plan run. Onhand of 7029 Qty exists.
This is sufficient to meet all Sales Order demands in window of 84 days from anchor date.
But Forecast demand on 14-Aug-2020 with less priority pegs to onhand and Sales Order demand with more priority on 17-Aug-2020 pegs to Purchase Orders.


EXPECTED BEHAVIOR
----------------------------
Expectation is High Priority Demands in firm supply allocation window of 84 days (Sales Order demands) should peg to Onhand.


12.2.9 Cum Patch #1 - 31408442

Plan options
EDD classic with only supplier capacity constraints
-- enforce purch LT NOT checked
900 days
PTF checked
Demand priority pegging at Project level for reservation and pegging
Decision rules greyed out
MSO: Lead Time Control - VIOLATE_MIN_PROC_TIMES

TEST RESULTS AFTER PATCH
---------------------------------------------
Onhand = 9,030
Past Due SO Demand = 5,085
Past Due FCST = 3091
SO demands from anchor date to 01-OCT-2020 = 854

Item Processing LT=100
MSO: Multiplier to Derive Supply Allocation Window = 1.2

Therefore Supply Allocation Window = 120 days.
Plan run date = 6-JUL-2020.
SO demands till 01-OCT-2020 falls in Supply Allocation Window and Onhand is enough to cover SO demands till 01-OCT-2020.

SO demands should peg to Onhand. But FCST demand on 20-JUL-2020 is pegged to Onhand. FCST demand priority is less than SO demand priority. But still this did not work.

- Use common supplies is NOT checked

Reviewing XLS export of the supply/demand
Project records
------------------
Project AA1 - balance = 0 for SO demand and Purchase Req - 5 lines <<< these lines are fine even though they peg to Req instead of on hand
Project DD4 - balances = 0 for SO demand and on hand (4 lines) - no issue here.

-- these two lines cannot peg to any demand
Project BB2- qty - 2 on hand is excess
Project CC3- qty - 10 on hand is excess

Only 11 of 427 lines have a project number

Cause

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
Symptoms
Cause
Solution
References


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