How To Load User Defined Item Attributes Using EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data API ? [Video]

(Doc ID 605487.1)

Last updated on JUNE 11, 2017

Applies to:

Oracle Product Hub - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 20-MAR-2014***


The purpose of this document is to provide a demonstration showing how user defined attributes for an Item can be loaded from a user defined table. The demonstration uses the API EGO_USER_ATTRS_DATA_PUB.PROCESS_USER_ATTRS_DATA to load the user defined attributes. This demonstration assumes that the items have already been created.

For additional information on creating items in Product Lifecycle Management, please refer to

<Note 416829.1> Training Material for Product Lifecycle Management (PLM)
Formerly Known as Advanced Product Catalog

The attached viewlet will walk the user through creating the PL/SQL Procedure for loading these user defined attributes for the item. There is also a document which has sample code for test purposes.

Please be aware that Product EGO/PDH must be installed and licensed in order for the API to work.

You might run SQL like the following or a more complete script from Note 414470.1 where "Installed" means the product is already licensed while "Not Installed" means that the product is installed but not yet licensed:



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