My Oracle Support Banner

How To Load User Defined Item Attributes Using EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data API ? (Doc ID 605487.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Product Hub - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


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

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:



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
 1. Sample Code
 2. FAQ

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