INCOIN - INV_IOI_ORPHAN_CHILD - This Child Item has no Master Item record in MTL_SYSTEM_ITEMS (Doc ID 858457.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Item Master - Version 12.1.1 and later
Information in this document applies to any platform.
INCOIN , INV_IOI_ORPHAN_CHILD


Goal

When trying to import items for Child organization the following error appears in Log File and MTL_INTERFACE_ERRORS.

ERROR
------------
INV_IOI_ORPHAN_CHILD - This Child Item has no Master Item record in MTL_SYSTEM_ITEMS.

STEPS
-----------
The issue can be reproduced at will with the following steps:
1. Populate data in MTL_SYSTEM_ITEMS_INTERFACE : for child organization and item segment1
2. Run Item Import for the child organization and CREATE mode
3. The Item Import process fails

Solution

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