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 NOVEMBER 12, 2018
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:
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|