My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.