E1: 34: Master Planning Schedule - Multiple Plant - R3483 Does not Generate Messages for All Items in a Single Run Even Though the Number of Items is Less Than 999 (Doc ID 3054806.1)

Last updated on OCTOBER 21, 2024

Applies to:

Symptoms

When running DRP - Master Planning Schedule - Multiple Plant - R3483, the system does not plan for all items in a single run, therefore the DRP messages are not generated even if data selecting less than 999 items for the DRP run.
This occurs when the DRP is run with Forecast Consumption by Customer logic activated and some insert errors can be observed for F3411 table due to unique key constraint violated on F3411.UKID field.

The issue can be reproduced at will with the following steps:

1. Create an item in multiple branches and setup branch/plant relationships.
2. Add some demand in the demand branch and run R3483.
3. Process the messages suggested by MRP, including ST/OT orders.
4. Modify the demand in the demand branch so that some action (defer/expedite/increase/decrease) should be triggered on the ST/OT order.
5. Run R3483 again, observe the F3411 insert error in the logs. You may also see incorrect planning results due to these insert errors.

Cause

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