Import Price Catalog Errors with "Master - Child Conflict in one of these Attributes" when Importing Item (Doc ID 360542.1)

Last updated on JUNE 03, 2016

Applies to:

Oracle Purchasing - Version 11.5.10 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on june 2016***
Executable:POXPDOI - Import Price Catalogs


Symptoms

Import Price Catalog is erroring when importing documents with new items to be assigned to
child inventory organizations.

TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE

COLUMN NAME : MASTER_CHILD_4G

MESSAGE NAME : INV_IOI_MASTER_CHILD_4G

ERROR MESSAGE : Master - Child Conflict in one of these Attributes:

Type(WIP_SUPPLY_TYPE), Subinventory(WIP_SUPPLY_SUBINVENTORY), Primary UOM
Code(PRIMARY_UOM_CODE), Primary Unit Of Measure(PRIMARY_UNIT_OF_MEASURE),
Conversions(ALLOWED_UNITS_LOOKUP_CODE)

************************************

TRANSACTION ID : XXXX
ORGANIZATION ID : XX
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

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