E1: 34: MRP Multi-Plant-R3483 with Availability Checking turned ON Over-Plans when OT's Promised Delivery Date is Less than Forecast Demand Requested Date (Doc ID 2639201.1)

Last updated on JULY 25, 2022

Applies to:

Symptoms

When using Availability checking ON (=1), R3483 triggers excess inventory when the Promised Delivery Date of an existing OT order is less than the forecast demand date.

The issue can be reproduced at will with the following steps:

1. P4101 / P41026 - Create a purchased item; in both supplying and demand branch plants, the item has the same setup: OPC = 1 - Lot for Lot; Planning Code = 2 - Planned by MRP; Planning Fence Rule = C; P41026 - Quantities tab: Maximum / Minimum Reorder Qty / Multiple Order Quantity / Safety Stock = blank
2. P3403T - Set the branch relationship by item; Availability Checking flag is ON (= 1)
3. P3460 - Create forecast on Demand B/P for 10 EA on e.g. Wednesday, 2-3 weeks in the future
4. P41202 - Quantity On Hand = 0 on both supplying and demand B/Ps.
5. P4210 / P4310 - Create ST/OT order for the Quantity Ordered of 10 EA, with Promised Delivery Date that is 2 days before the forecast demand date (on Monday of the same week)
6. BV: R3483 - Create and run an MRP version; data select the purchased item and both supplying and demand branch plants; both Expedite / Defer Damper Days processing options are blank
7. P3411 – Notice the correct defer message against the existing OT order in the demand B/P and the correct order message for a new OP order in the supply B/P. However, an incorrect / extra order message is triggered for a new OP order in the demand B/P. This leads to overstock in the demand B/P.
   
   

Cause

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