E1: 34: MRP Messages do not Fulfill Demand When Item has Maximum Reorder Quantity and Branch Relationship (R3483, P3403T) (Doc ID 2879237.1)

Last updated on AUGUST 19, 2022

Applies to:

Symptoms

When a purchased Bill of Material Component is set up with a Maximum Reorder Quantity in the Item Branch (P41026) and when a Branch Relationship (P3403T) is set to create Transfer Orders (ST/OT), MRP will create Purchase Order (OP) and Transfer (OT) messages that do not fulfill the quantities from Work Orders.
If firm Purchase Orders exist to fulfill Work Order component demand and subsequently components become available in another branch set up in Branch Relationships (P3403), Muti-plant MRP (R3483) will create cancel and defer messages along with new OT messages. However, the suggested orders will not have sufficient quantity to fulfill the Work Order demand.

Steps to Duplicate
1. Create a Manufactured parent.
2. Create a Purchased Child with Order Policy Code = 1 and a Maximum Reorder Quantity in two branches: supply and demand branch.
3. Associate the parent and child in a Bill of Material (P3002).
4. Create multiple Work Orders (P48013) in the future and then set the Freeze Code to Y.
5. Create a Branch Relationship (P3403T) for the purchased component to supply from a different branch. Make sure Availability Checking is set to 1.

First Test:
a. Adjust inventory (P4114) in the supply branch for a quantity that will not fulfil the total quantity from the Work Orders.
b. Run Multi-plant MRP (R3483) with Generation Mode = 2, Generation Type = 5 over the Manufactured Item and Purchased Component.
c. Review the Detail Messages (P3411); notice that the Required Quantities on the OT and OP orders will not fulfill the demand from the Work Orders.
d. Review the Purchased Component in Supply/Demand Inquiry (P4021); notice that the Quantity Available will go negative.

Second Test:
a. Adjust inventory (P4114) in the supply branch to make on-hand zero.
b. Run MRP (R3483) over the Manufactured Item and Purchased Component.
c. Inquire on the Detail Messages (P3411) and notice the Order (OP) messages; select all and process them.
d. Adjust inventory (P4114) in the supply branch for a quantity that will not fulfil the total quantity from the Work Orders.
e. Run MRP (R3483) over the Manufactured Item and Purchased Component.
f. Inquire on Detail Messages (P3411); notice there are cancel and defer messages along with new OT messages. However, the quantity will not be sufficient to meet Work Order demand.
g. Review Supply/Demand Inquiry (P4021); notice that the Quantity Available will go negative.
h. Return to Detail Messages (P3411) and Process all of them.
i. Inquire on the Purchased item in Supply/Demand (P4021); notice that the Quantity Available will go negative.

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.