Project Pegging Not Working Correctly When Reservation Level = Planning Group and Hard Pegging Level = Project (Doc ID 1543772.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.8 and later
Information in this document applies to any platform.
***Reviewed for Currency 09-Sep-2014***

Symptoms

On : 12.1.3 version, Memory Based Planner in Test:

This is a Project environment. Users have applied VCP 12.1.3.8 Patch 14247039. Users are using Solaris 64 bit MBP MSCNWS64.ppc/MSONWS64.ppc 120.12.12010000.79 which came with 12.1.3.8 so no one offs. Users are testing the same exact data from and 11.5.10.2 plan vs the 12.1.3 plan

Reservation Level =Planning Group
Hard Pegging Level = Project
Unconstrained Plan 30 days/77 weeks/0 periods

This is example of pegging with project and common supply demand for 11.5.10 vs 12.1.3.8. Both examples are with profile MSC: Use attribute based netting = Null (11.5.10) or No (12.1.3)

A. 11.5.10 example working as expected:

Item = R12PEG
Org = R12:JAX

Supply
======
On hand qty = 75 Planning Group = PLANGRP Project = DO
On hand qty = 100 Planning Group = Null Project = NULL
Firm PR qty = 15 due 12-JUL-2013 Planning Group is Null Project = NULL
Planned Order Qty = 40 due 03-JAN-2014 Planning Group = PLANGRP Project = DO

Demand
======
Sale Order Qty = -15 due 05-APR-2013 Planning Group = PLANGRP Project = DO
- This pegs to onhand for the same Planning group - on hand down to qty = 60 for Planning Group = PLANGRP Project = DO

Sales Order Qty = -60 due 03-MAY-2013 Planning Group = Null Project = Null
- This pegs to common on hand - on hand down to 40 for Planning Group = Null Project = NULL

Sales Order Qty = -35 due 05-JUL-2013 Planning Group = ENDNPD Project = 11080
-This pegs to common on hand - on hand down to qty = 5 for Planning Group = Null Project = NULL

Sales Order Qty = -120 due 03-JAN-2014 Planning Group = PLANGRP Project = DO
- This pegs to the balance qty = 60 from the same planning group and takes this portion of on hand to qty = 0 for same. This also pegs to qty = 5 common on hand and takes this on hand to qty = 0. This also pegs to the common firm PR qty = 40. So no all existing supplies are exhausted and this satisfied qty = -80 of the demand so far. This leaves balance = -40 which pegs to the planned order for qty = 40. Supply and demand net to 0 and all is well here

B. R12.1.3 output Same exact example item/org above with the same exact data for supply and demand. Everything is fine except for two things:

1. No planned order for qty = 40 was generated at all. Total demand = -230. But total supply is only 190 - why didn't the planned order get generated???

2. The last sales order qty = -120 due 03-JAN-2014 is pegging to existing supplies but there's only qty = 80 available. It's double counting/pegging on hand and the PR twice to satisfy this sales order

Important: If in 12.1.3 instance they set profile MSC: Use attribute based netting = Yes then pegging only uses common on hand for demand that has no planning group/project only. On hand that is allocated to planning group/on hand only is used for demand that has the same corresponding planning group/project

Key profiles:

MSC: Use attribute based netting = No
MSC: Default Project for Supplies Pegged to Excess is null
MSC: Enhanced Project Netting is NULL
MSC: Minimize Project Cross Peg within Window = Yes
MSC: Peg Firm Work Orders Within Assigned Projects and Tasks is NULL
MSC: Project Task Collection Window Days is NULL
MSC: Safety Stock Project is NULL
MSC: Use FIFO Pegging = No

EXPECTED BEHAVIOR
-----------------------
Expect Pegging and Planning for 12.1.3 to be the same as they see in 11.5.10. In this case there's a planned order missing and demand is being pegged to supply and double dipping the supply

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run 11.5.10 plan
2. Run 12.1.3 plan with same data
3. Review workbench results - see double use of supply with lack of planned order. Demand is higher than supply

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