My Oracle Support Banner

WS: 31/34: Lot Effective Dates - Manufacturing and Purchasing Days (Doc ID 804166.1)

Last updated on AUGUST 25, 2023

Applies to:

JD Edwards World Inventory Management - Version A9.3 and later
JD Edwards World Material Requirements Planning - Version A9.3 and later
JD Edwards World Shop Floor Management - Version A9.3 and later
JD Edwards World Procurement - Version A9.3 and later
Information in this document applies to any platform.


JD Edwards has the ability to earmark certain lots as becoming available for use on some future date.  Lot Effective Date was first included in A9.3.  This is the date on which a lot becomes available for use in production, or shipping.  The system uses this date for availability and commitment processing to indicate that the lot is available on or after the date that you specify.

• Inventory would be held with a 'future availability date', in anticipation of QA test results being acceptable.  This date could be stored in the new user defined list of dates described in the requirement Multiple Expiration Dates.

• MRP must consider the held inventory available based on the new date.

• Work Order completions must assign this new date for items coded appropriately.

• Purchasing stores this date in the Purchase Order Header (V4301A).

In A9.3.1 onward, World Software calculates the availability of the quantity of an item contained in a lot through the use of a Lot Effective Date.  The Effective Date will describe the date after which the quantity of item contained in a lot will become available for use in other processes.  This Effective Date has implications in planning, manufacturing, procurement and inventory.

The Effective Date field was added to the Lot Master table to store this information. The availability and commitment calculations for MRP, Manufacturing, Warehousing, Sales Order Processing, and Sales Order Entry were also modified to read the Effective Date field to appropriately act on the lot based on the Effective Date information.


For users on World Software A9.3.1 onward, using Distribution and Manufacturing modules


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
 Work Order specific
 Purchase Order specific
 Lot Effective Dates
 Defining Effective Days
 Calculation and Assignment of the Effective Date
 Work Order Entry (P48013)
 Discrete and Process Work Order Completions (P31114)
 Lot Dates Revisions (P41081)
 Lot Adjustments (P4114)
 Lot Reclassifications (P4116)
 Lot Splitting
 Purchase Order Entry (P4310)
 Purchase Order Receipts (P4312)
 Effective Date Validation
 Availability & Commitment Calculations
 Manufacturing Commitments
 MRP Processing (P3482/P3483)
 On-Hand Inventory
 P4311 Purchase Orders
 P48013 Work Orders
 P3413 Time Series
 P3411 MRP Messages
 P4021 Supply/Demand Inquiry

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