How To Load User Defined Item Attributes Using EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data API ? [Video]
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