System Does Not Warn When Deleting The Attribute Group Association In An ICC

(Doc ID 1371886.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Product Hub - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Product Hub, users can associate user defined attribute groups to an Item Catalog Category (ICC), and assign values to these attributes for items belonging to that ICC or its children.
When users delete the association between the attribute group and the ICC, the attribute values are not deleted for the items.

There is no warning from the system when users do this.

This results in junk data (orphan records) in EGO_MTL_SY_ITEMS_EXT_B/TL tables which are not related to any ICC - Attribute Group association.

Changes

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