My Oracle Support Banner

E1: 34: R3483 MRP Generates Incorrect Planned Transfer Order (OT) Messages for Items Setup with Periods of Supply (OPC4) Order Policy, Minimum and Maxiumum Order Quantities (Doc ID 2759227.1)

Last updated on OCTOBER 25, 2022

Applies to:

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

Symptoms

As a result of running R3483 for an purchased item controlled by Order Policy Code 4 (Periods of Supply), demand exceeds supply in the future. Quantity of Planned Orders (Order Type OT) are less than demand quantity.

Branch relationship (P3403T) is set for the item.
Minimum Order Quantity and Multiple Order Quantity is set for the item in ItemBranch Information (F4102).

Steps:

  1. Create new Manufactured Item and Purchased Item in Br/Pl 20 (P4101, P41026).
  2. Add a BOM using above 2 items (P3002). The Manufacture Item is Parent item. The Purchased item is Component.
  3. Add another Br/Pl 10 for the purchased item in ItemBranch Information (P41026).
  4. For the purchased item of Br/Pl 20, Order Policy Code is 4 (Periods of Supply) and order Policy Value is 2 (days) in ItemBranch Information (P41026). And also set 100 to Minimum Reorder Quantity and 50 to Multiple Order Quantity in Quantities row exit.
  5. Branch Relationship (P3403T). For the purchased item, set Br/Pl10 as Supply Branch and Br/Pl20 as Demand Branch.
  6. Add forecast for the Manufactured item (P3460).

Request date 3/29-160EA

Request date 3/30- 80EA

Request date 4/21-160EA

  1. Add 5 work orders for the Manufactured Item (P48013)

Request date 3/29-80EA

Request date 3/29-80EA

Request date 3/30-80EA

Request date 4/21-80EA

Request date 4/21-80EA

  1. Attach parts list for all work orders.
  2. Demand (forecast) and Supply (work order) of the Manufactured item is balanced.

For the Purchased item, there is 18EA on-hand quantity. But Demand (component quantity in parts list) is 400EA as below. So demand exceeds supply quantity.

Request date 3/29-80EA

Request date 3/29-80EA

Request date 3/30-80EA

Request date 4/21-80EA

Request date 4/21-80EA

10.Run R3483


Changes

 

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!


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