Oracle Product Hub / Product Lifecycle Management / Product Information Management / Advanced Produc

In this Document

Goal

Solution

1. Master List showing sample code for APIs in Product Data Hub

2. FAQ

a. Need API to load Item Catalog Category people, Associating ICC with Templates & Match Rules, is there an API for this purpose?

References

---

APPLIES TO:

Oracle Product Hub - Version 12.0.4 and later
Information in this document applies to any platform.
This document applies to all version of Oracle E-Business Suite release 12 and higher

GOAL

This document lists references to notes showing how to use public APIs provided and examples of sample code that show the use of PLM / PIM APIs

SOLUTION

Note 729513.1 How to use APIs: This demonstration walks the user through the API specifics, creating the PL/SQL procedure for using an API and also debugging guidelines.

1. Master List showing sample code for APIs in Product Data Hub

Note	Title
Note 605487.1	How To Load User Defined Item Attributes using EGO_USER_ATTRS_DATA_PUB.PROCESS_USER_ATTRS_DATA API ? [Video]
Note 728364.1	How to Assign Multiple Items to Inventory Organizations using EGO_ITEM_PUB.PROCESS_ITEM_ORG_ASSIGNMENTS API ? [Video]
Note 729241.1	How to Load User Defined Attributes for Item using EGO_ITEM_PUB.PROCESS_USER_ATTRS_FOR_ITEM API ? [Video]
Note 728350.1	How to load Inventory Items using EGO_ITEM_PUB.PROCESS_ITEMS API? [Video]
Note 728358.1	How to Retrieve User Defined Attributes for Item using EGO_USER_ATTRS_DATA_PUB.GET_USER_ATTRS_DATA API ? [Video]
Note 728361.1	How to Assign Items to Inventory Organizations using EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG API ? [Video]
Note 728917.1	How To Assign Inventory Items To Categories Using EGO_ITEM_PUB.PROCESS_ITEM_CAT_ASSIGNMENT API ? [Video]
Note 729246.1	How To Create Or Update Role Grants On Item Using EGO_ITEM_PUB.PROCESS_ITEM_ROLE API ? [Video]
Note 1340478.1	API For BOM Structure User Defined Attributes (UDA)? [Video]
Note 1340855.1	API For BOM Component User Defined Attributes (UDA)? [Video]
Note 1366502.1	How to Create / Update User Defined Attributes on an ECO using an API [Video] ?
Note 1526870.1	How to Create, Update or Delete Multi Row User Defined Attributes Using EGO_USER_ATTRS_PUB.Process_User_Attrs_Data API ? [Video]
Note 1600662.1	How to Create Category Codes Using INV_ITEM_CATEGORY_PUB.Create_Category API ?
Note 1666349.1	How to Associate "Images" or "Detailed Description" User-Defined Seeded Attributes to an Item using EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data API ?

For a list of all the APIs , Please refer to Integration Repository available from Integrated SOA Gateway responsibility in the Application.

2. FAQ

a. Need API to load Item Catalog Category people, Associating ICC with Templates & Match Rules, is there an API for this purpose?

The API EGO_SECURITY_PUB.create_instance_set and EGO_SECURITY_PUB.grant_role suggested will not work for ICC people role. You want to add the Item catalog category user role in the ICC. So you are looking for ICC people and not Item people.  EGO_SECURITY_PUB.grant_role_guid is the private api which is called for this. Since this is Private API , this is not supported by development or support. You may have to use it at your own risk. There are no Public APIs.

REFERENCES

NOTE:728361.1 - How To Assign Items To Inventory Organizations Using EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG API [Video]
NOTE:728364.1 - How To Assign Items To Inventory Organizations Using EGO_ITEM_PUB.Process_Item_Org_Assignments API [Video] ?
NOTE:728917.1 - How To Assign Inventory Items To Categories Using EGO_ITEM_PUB.PROCESS_ITEM_CAT_ASSIGNMENT API [Video]
NOTE:729241.1 - How To Load User Defined Attributes For Item Using EGO_ITEM_PUB.Process_User_Attrs_For_Item API [Video] ?
NOTE:729246.1 - How To Create Or Update Role Grants On Item Using EGO_ITEM_PUB.PROCESS_ITEM_ROLE API [Video]
NOTE:729513.1 - How to use APIs for Inventory / Product Information Management [Video] ?
NOTE:1340855.1 - API For Component User Defined Attributes (UDA)?
NOTE:1340478.1 - API For BOM Structure User Defined Attributes (UDA)? [Video]
NOTE:1366502.1 - How to Create / Update User Defined Attributes on an ECO using an API [Video] ?
NOTE:605487.1 - How To Load User Defined Item Attributes Using EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data API ? [Video]
NOTE:728350.1 - How To Load Inventory Items Using EGO_ITEM_PUB.PROCESS_ITEMS API ? [Video]
NOTE:728358.1 - How To Retrieve User Defined Attributes For Item Using EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data API ? [Video]