E1: 34: Incorrect Messages If Past Due Supply and Past Due Demand (Doc ID 2260645.1)

Last updated on JULY 11, 2017

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

E1 9.1 / Multi-facility MRP - R3482

If there is past due demand (i.e. Sales order) and past due supply (i.e. Purchase order(s)), R3483 is generating incorrect Defer messages on the supply order(s).
The R3483 results vary depending on the item's Order Policy Code setup.

Periods of Supply item setup:
Item Branch/Plant P41026: Setup an item in two branch plants (i.e. M10 and M30) with the following Item Branch/Plant information:
Demand Branch, Stocking Type = P, Supply Branch, Stocking Type = M
Both Branches: Addl System Info: Order Policy Code = 4, Value Order Policy = 28, Planning Code = 1, Planning Fence Rule = G
Quantities: Multiple Order Quantity = 102, Safety Stock = 55
Demand Branch existing demand and supply:
Forecast for quantity 17 on the first day of month starting with May 1, 2017 through June 1, 2018.
Sales order for a quantity of 68 due (PDDJ) October 7, 2016 (past due).
Inventoy (availability) = 119
Two past due OT orders in the Demand Branch (ST order in Supply Branch: First order for quantity 204 request date 12/1/2016.
Second order for quantity 102 request date 11/1/206.

Demand Branch Time Series, P3413:
Appears that past due demand is being ignored.
The BA and EA values are negative until the 8/4/2017 bucket.
The quantity 64 BAU is short a quantity of 4 to cover the past due sales order.
The 64 BAU covers the first 3 forecast requirements fully and then falls short on the August forecast.
Replenishment does not occur until the BA and EA hits -55 (Safety Stock quantity).

Demand Branch (M10) Messages, P3411:
Defer the first OT from 12/1/2016 to 8/1/2017. This is incorrect as the past due sales order or some forecast is now not fully covered prior to 8/1/2017.
Defer the second OT from 11/1/2016 to 2/1/2018.

R3482:
Incorrect Defer and Decrease message:
Defer the first OT from 12/1/2016 to 4/10/2017 (current date). Defer message does not make sense. Should be no action message or, an expedite message might make more sense (although this still results in a negative BA in the first non-past due bucket).
Decrease the first OT from 204 to 102. Decrease messages should not occur on periods of supply item orders.

R3483 with Lot for Lot item setup (all other setup the same):
Change the item setup on the item in the preceding scenarios:
Both Branches: Addl System Info: Order Policy Code = 1, Value Order Policy = blank, Planning Code = 2, Planning Fence Rule = blank
Incorrect Defer message: It does not make sense to defer a past due order to cover a past due demand.  There should be no action type message or, an expedite message (to the current date) would make more sense.

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