Unconstrained Plan Supply Pegging To Excess Along Plan Horizon For Project/Task Environment With Soft Pegging Item Attribute (Doc ID 1465409.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

Users are on 12.1.3 and have applied 12.1.3.4 patch 11782731 and have applied one off patch 12648099 to get mslnw3.ppc 120.110.12010000.100.1201030.3. They are using 32 bit MBP and run unconstrained ASCP plans. Please note this is a project/task environment but in this example the item is soft pegged but not hard pegged. What they're seeing is several planned orders with decimal qty pegging to excess and this excess is never used even in future demand. Now there is decimal demand so potentially we would expect to see a little excess as they have round order quantities enabled on the item. But that should happen at the end of the plan and not occur throughout the plan. Example:

Initial Profile settings:

MSC: Enable Group Based Netting = Yes
MSC: Use FIFO Pegging = No
MSC: Use attribute based netting = Yes
MSC: Peg Firm Work Orders Within Assigned Projects and Tasks is NULL
MSC: Minimize Project Cross Peg within Window is NULL
MSC: Default Project for Supplies Pegged to Excess is NULL

Plan options show Reservation Level and Hard Pegging Level both = Project - task

Item = JM113-3
org code = TST:529
There are NO order modifiers on this item nor safety stock
0 on hand

Here's what supply demand looks like for this item and hopefully this won't wrap:

Order Type Sugg Due Date Qty/Rate Cum Total Pegged Qty Pegging Details
Planned order 5/23/2012 0:00 1 1 1 Pegged to Sales Order 136282
Pln order demand 5/23/2012 0:00 -1 0 1 Pegged to Planned Order
Planned order 5/24/2012 0:00 1 1 0.4 Pegged to Pln Order Demand Qty 4 (0.6 Pegged to Excess)
Planned order 5/24/2012 0:00 4 5 3.6 Pegged to Pln Order Demand 3.6 (0.4 Pegged to Excess)
Pln order demand 5/24/2012 0:00 -3.6 1.4 3.6 Pegged to Planned Order
Planned order 6/22/2012 0:00 1 2.4 0.4 Pegged to Pln Order Demand Qty 4 (0.6 Pegged to Excess)
Planned order 6/22/2012 0:00 4 6.4 3.6 Pegged to Pln Order Demand 3.6 (0.4 Pegged to Excess)
Pln order demand 6/22/2012 0:00 -4 2.4 0.4 pegged to Planned Order 3.6 Pegged to Planned Order
Planned order 7/25/2012 0:00 4 6.4 3.6 Pegged to Pln Order Demand (0.4 Pegged to Excess)
Planned order 7/25/2012 0:00 1 7.4 0.4 Pegged to Pln Order Demand (0.6 Pegged to Excess)
Pln order demand 7/25/2012 0:00 -4 3.4 0.4 Pegged to Planned Order 3.6 Pegged to Planned Order
Planned order 8/24/2012 0:00 4 7.4 3.6 Pegged to Pln Order Demand (0.4 Pegged to Excess)
Planned order 8/24/2012 0:00 1 8.4 0.4 Pegged to Pln Order Demand (0.6 Pegged to Excess)
Pln order demand 8/24/2012 0:00 -4 4.4 0.4 Pegged to Planned Order 3.6 Pegged to Planned Order
Planned order 9/24/2012 0:00 4 8.4 3.6 Pegged to Pln Order Demand (0.4 Pegged to Excess)
Pln order demand 9/24/2012 0:00 -4 4.4 0.4 Pegged to Planned Order 3.6 Pegged to Planned Order

Sum of Quantity Pegged to Excess: 4.4

We also note since the item is soft pegged, there is no project/task assigned to the planned orders (expected with this setup)

Things we tried:
=============
Had them set profile MSC: Use FIFO Pegging = Yes (didn't help)
Had them set Reservation Level and Hard Pegging Level in plan options to None (didn't help)
Everything I find on research has to do with issues in regards to excess when the item is hard pegged. Can't find anything when it's soft pegged but still project/task environment



STEPS:

  1. 1. Setup items for soft pegging in item attributes but for Project/Task environment and call out item with decimal qty in the BOM
  2. 2. Run collections and unconstrained plan
  3. 3. See excess supply accumulate throughout the plan horizon in decimal qty which is never used

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