Master Child Organization Item Errors MTL_INTERFACE_ERRORS INV_IOI_MASTER_CHILD_4D And INV_IOI_REV_NO_ITEM
(Doc ID 1951727.1)
Last updated on APRIL 18, 2023
Applies to:
Oracle Item Master - Version 12.1.3 and laterOracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
INVIDITM.fmb
Symptoms
When attempting to assign Inventory Items to child organizations, the following errors can be seen in the log file:
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : MASTER_CHILD_4D
MESSAGE NAME : INV_IOI_MASTER_CHILD_4D
ERROR MESSAGE : Master - Child Conflict in one of these Attributes: Demand Time Fence(DEMAND_TIME_FENCE_CODE), Lead Time Lot Size(LEAD_TIME_LOT_SIZE), Standard Lot Size(STD_LOT_SIZE), Cumulative Manufacturing(CUM_MANUFACTURING_LEAD_TIME), Overrun Percentage(OVERRUN_PERCENTAGE), Calculation ATP(MRP_CALCULATE_ATP_FLAG), Positive Acceptable Rate(ACCEPTABLE_RATE_INCREASE), Negative Acceptable Rate(ACCEPTABLE_RATE_DECREASE).
COLUMN NAME : MASTER_CHILD_4D
MESSAGE NAME : INV_IOI_MASTER_CHILD_4D
ERROR MESSAGE : Master - Child Conflict in one of these Attributes: Demand Time Fence(DEMAND_TIME_FENCE_CODE), Lead Time Lot Size(LEAD_TIME_LOT_SIZE), Standard Lot Size(STD_LOT_SIZE), Cumulative Manufacturing(CUM_MANUFACTURING_LEAD_TIME), Overrun Percentage(OVERRUN_PERCENTAGE), Calculation ATP(MRP_CALCULATE_ATP_FLAG), Positive Acceptable Rate(ACCEPTABLE_RATE_INCREASE), Negative Acceptable Rate(ACCEPTABLE_RATE_DECREASE).
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : ITEM_ID
MESSAGE NAME : INV_IOI_REV_NO_ITEM
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.
Steps
1. Create Organization Hierarchies
2. Create item on Master org.
3. Run Item Organization Assignment with Hierarchy
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |