My Oracle Support Banner

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 FEBRUARY 20, 2019

Applies to:

Oracle Item Master - Version 12.1.3 and later
Oracle 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).

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


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