DRP Plan Calculating Planned Orders In Excess Of Demand (Doc ID 2105330.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.1.3.8 version, Distribution Planning NEW

DRP calculating Planned Orders in excess of Demand and this is creating a large positive Projected Available Balance. The Planned Orders are even in excess of Demand when taking Safety Stock into consideration.

 

The below are generic examples:
Item XXXXXXXX
Safety Stock Qty = 1044
PAB = 23,903.60
Planned Order Qty = 23,000.00 (single planned order due on 13-DEC-2015)
Bucket: 07-DEC-2015:W:7 - In this bucket, the Planned Order is being done to meet safety stock. Also, the previous buckets the PAB was below safety stock.


For Item XXXXXXXX (Order A) on 15-NOV-2015 for Qty of 140
  Pegging:
  XXXXXXXX/ORG 1: Qty .87 Pegged Qty .87 on 31-JAN-2016
  XXXXXXXX/ORG 1: Qty .87 Pegged Qty .87 on 07-FEB-2016
  XXXXXXXX/ORG 1: Qty .87 Pegged Qty .87 on 14-FEB-2016
  XXXXXXXX/ORG 1: Qty .87 Pegged Qty .87 on 21-FEB-2016
  ---Continues on from here till a 30-OCT-2016 at different Quantities.

Item &&&&&&&&
Safety Stock Qty = 13
PAB = 152
Planned Order Qty = 140 (single planned order due on 15-NOV-2015)
09-NOV-2015:W:3 - In this bucket, the Planned Order is being done to meet safety stock. Also, the previous buckets the PAB was below safety stock.

For Item &&&&&&&& (Order B) on 15-NOV-2015 for Qty of 23,000
  Pegging:
  &&&&&&&&/ORG 2: Qty 14.17582 Pegged Qty 14.17582 on 13-DEC-2015
  &&&&&&&&/ORG 2: Qty 14.19262 Pegged Qty 14.19262 on 20-DEC-2015
  &&&&&&&&/ORG 2: Qty 14.20253 Pegged Qty 14.20253 on 27-DEC-2015
  &&&&&&&&/ORG 2: Qty 14.20933 Pegged Qty 14.20933 on 03-JAN-2016
  ---Continues on from here till a 30-OCT-2016 at different Quantities.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run DRP Plan

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