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 27, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Oracle Product Hub - Version 12.2.3 to 12.2.3 [Release 12.2]
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:

TRANSACTION ID : 1003
ORGANIZATION ID : 121
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).

TRANSACTION ID : 1001
ORGANIZATION ID : 121
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms