My Oracle Support Banner

Master Child Conflict On Attributes -- Validations Happening In Inactive Organizations ? (Doc ID 2366062.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Oracle Product Hub - Version 12.2.5 and later
Oracle Item Master - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Master Child Conflict errors on few attributes when updating items from Product Hub Item Catalog , or EGO_ITEM_PUB API or WebADI or Open interface (Item Import, Item Catalog Import). See that all the organizations where the items are found are Inactive, but still these are being validated and items cannot be updated in Active organizations as well.
 
ERROR
Changing Master Controlled attributes of this Master Item has caused validation errors in the Child Item

STEPS
1. Development Manager > Item Catalog > Advanced Search > Search for an item in Master org > Try to update item description (master controlled on this instance) 
2. See error appears. 
3. Run a query to check errors in MTL_INTERFACE_ERRORS - See errors like "Invalid Buyer", "Invalid planner"  logged for the item for Inactive organizations.

Changes

Upgraded to 12.2.x from 11i

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
 Current Behavior (Through 12.2.13)
 Approach to resolve the inconsistent attributes
 Community Idea - Implemented in 12.2.14
 Changes in 12.2.14
References


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