My Oracle Support Banner

How to Populate or Retrieve User Defined Attributes On Change Order Header Using API ? (Doc ID 2058919.1)

Last updated on JUNE 08, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

 This note discusses how to create or update user-defined attributes associated to a Change Order Header using API EGO_USER_ATTRS_DATA_PUB.PROCESS_USER_ATTRS_DATA. It also provides an example how these user-defined attributes can be retrieved using  EGO_USER_ATTRS_DATA_PUB.GET_USER_ATTRS_DATA.

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:

 

Solution

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
Goal
Solution
 A. EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
 B. EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data
References


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