My Oracle Support Banner

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

Last updated on AUGUST 20, 2023

Applies to:

Oracle Purchasing - Version 11.5.10 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform. 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

Changes

 

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
Changes
Cause
Solution

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