What Table Is Used to Query For User Defined Attributes? (Doc ID 372415.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Product Hub - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Goal

In Product Lifecycle Management (PLM), Users need to create a custom report that looks at all items and reports on a specific User Defined Attribute (UDA). The attribute appears in all attribute groups but may have a NULL value in some of them. The table EGO_MTL_SY_ITEMS_EXT_B does not appear to contain all items.

Solution

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