E1: 34: MRP (R3482 or R3483) Does not Consider the Supply from a Frozen Purchase Order (P4310) for Periods of Supply Item (Order Policy Code = 4) (Doc ID 2950383.1)

Last updated on MAY 25, 2023

Applies to:

Symptoms

When a purchased item set up with Order Policy Code = 4 (Periods of Supply) is on a a Purchase Order with a Freeze Code = Y, MRP (R3483) will not consider the quantity on that order as supply. This will create an oversupply situation as it generates messages.

Steps
1. Create a purchased item (P4101/P41026) with Order Policy Code = 4, Value Order Policy = 20, Safety Stock = 1000, Leadtime Level = 18, and Multiple Order Quantity = 100.
2. Create demand for the item as a component on multiple parent Work Orders (P48013/P3111) in the future.
3. Create a Purchase Order (P4310) detail line for the item for a quantity that will not satisfy the full demand and safety stock.
4. Run MRP (R3482).
5. Review Supply & Demand (P4021) and Detail Messages (P3411); notice that the quantity on the Purchase Order is considered as supply for the requested orders.
6. Freeze the Purchase Order detail line by entering Y in the Freeze Code field (row exit, Additional Info 2).
7. Re-run MRP and re-inquire on Supply & Demand and Detail Messages. Notice that the order messages do not consider the frozen Purchase Order quantity as supply.
8. Re-test the issue where the Order Quantity on the frozen Purchase Order is increased to a value that would satisfy demand on all future orders.
9. Re-run MRP again.
10. Inquire on Supply & Demand; notice that MRP still suggests new orders and the ending available quantity will be the same as the frozen Purchase Order. The situation creates an oversupply.

Changes

Cause

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