My Oracle Support Banner

E1: 34: Time Series Generated By DRP Not Using The Lot Effective Date On Orders Uses Calculated Value (Doc ID 1923498.1)

Last updated on FEBRUARY 06, 2019

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.


When Comparing P4021 Supply and Demand Inquiry to P3413 Time Series there may be a difference in the dates an order shows as available if the Planned Effective Date on an Order has been manually updated with a value that is earlier or later than the system would calculate based on the Item Branch Record Manufacturing or Purchasing Effective Days.

The Time Series generated by Requirments Planning (R3482/R3483) is not using the Lot Effective Date from the firm order (Work Order or Purchase Order. Instead, for Work Orders it uses the Request Date + Manufacturing Effective Days and for Purchase Orders it uses Promised Delivery + Purchased Effective Days. The P4021 always uses the Planned Effective date from the Order which is the date material will actually be available.

Steps to Duplicate:
1. Set up an Item and in the Item Branch Record Lot Information tab leave the
Manufacturing and Purchasing Effective Days blank.
2. Enter a WO and manually populate the Planned Effective Date such that it
will fall in a different time period than the Requested Date.
3. Enter a PO and manually populate the Planned Effective Date such that it
will fall in a different time period than the Promised Delivery Date.
4. Rum MRP with the processing option set to consider Lot Dates.
5. Review P4021 note that orders are displayed with the correct Planned
Effective Date based on what was entered on the Order.
6. Review P4021 and note that the orders are in the time period that relates
to the Requested Date (WO) and Promised Delivery (OP).

Desired Outcome:
The item branch record Effective Days are only a recommendation (default) value for calculating Planned Effective dates on orders. P3413 Time Series
should display orders (+WOU & +POU) based on the actual Planned Effective Date on the Order and not calculate this value. This would then be consistent
with P4021 and with user expectations of seeing when material is actually available.


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

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