Identify Opportunities to Optimize Item Class Setup Using Diagnostic Test

Oracle Product Hub offers an integrated collection of item class setup objects to model your product information in a hierarchical structure, where you can inherit the extensible flexfield (EFF) attributes from the parent node to the child node. Most of the setup objects are shared by other setup objects. For example, a value set may be shared by multiple EFF attributes. In some cases, the configuration choices may cause sub-optimal performance and cause potential problems. You can do the following:

Diagnose issues primarily caused by product configuration related to item classes, its component’s EFFs, value sets, and values.
Maintain an optimized item class setup and track disabled attributes and inactive value sets.

To identify opportunities to optimize item class setup, in the Run Diagnostics Tests work area, search and run the Product Hub Diagnostics – Item Classes diagnostic test.

Note: To include the Attribute Group Profile – Details and Value Set Profile – Details sections, run the diagnostic test with the Include Attribute Group Details option set to true.

To view all the details pertaining to the test:

When the Execution Status is displayed as Completed, click the View Test Results icon in the Report column. The test details are displayed.
Click the link in the Execution ID column. The Product Hub Diagnostics - Item Classes page is displayed that provides all the diagnostic test reports.

The diagnostic report has eight sections:

Count Of Item Classes and Their Components: Provides a count of item classes, attribute groups, and EFF attributes defined in Product Hub.
Count Of Attribute Groups by Key Characteristics: Provides a count of attribute groups based on their key characteristics. The count includes only the attribute groups that are currently in enabled state.
Item Classes Profile – Summary: Provides a list of all the item classes defined in Product Hub. This list is ordered based on the item class hierarchy. It includes the count of single-row attribute groups (SR AG), multi-row attribute groups (MR AG), disabled attribute groups (Disabled AG), and the total count of attribute groups (Total AG) associated to the item class.
Attribute Group Profile – Summary: Provides a list of all the attribute groups defined in Product Hub. In addition to the key characteristics of the attribute groups, the profile includes the view and edit privileges associated with them.
Attribute Group Profile – Details: Provides a list of all the attributes groups and all their attributes along with the value set name associated with the attributes defined in Product Hub. This list is ordered based on the attribute group name.
Value Set Profile – Details: Provides the list of all the value sets defined in Product Hub. This list is ordered based on the value set name.
List of Non-Active Values: Provides a list of attribute values that have passed the end date or disabled. This list is ordered by the value set name ascending and the Last Updated By descending order. The Last Updated Date and Last Updated By values may not directly correspond to the occurrence of end-dating or inactivating the value.
List of Disabled Attributes: This list is ordered based on the attribute group name ascending and attribute name ascending order. The Last Updated Date and Last Updated By values may not directly correspond to the occurrence of disabling the attribute.

The data is presented as a table In each section. You can copy the table and paste it into a compatible tool such as word processors or spreadsheets to leverage their native functionalities such as sorting, filtering, and formatting as applicable.