Open interfaces and API’s have always been a sought after option for importing data into Oracle’s Product Hub (OPH). API’s provide an excellent solution to manage bulk loads and enable bringing data in from multiple, disparate, external systems, into a single master repository. And we all know a single master is good!

Oracle Product Hub provides an excellent range of API’s to cater to a variety of tasks from creating items, updating items, assigning items to inventory organizations, creating and assigning item categories, assigning single and multi-row user defined attributes to Items, Change Orders, Structures, and Components. OPH also includes API’s specifically for Change Orders and Structures. Some API’s that have recently been added include ones for Packaging Hierarchy, Related items, Item Cross References, and Publishing Objects.

If you are interested in exploring further, check out document, Oracle Product Hub / Product Lifecycle Management / Product Information Management / Advanced Product Catalog APIs (Doc ID 730164.1).

Doc ID 730164.1 is an excellent reference to Product Hub API’s that provides not only a list of frequently used public API’s available for use, but also sample code, limitations, workarounds and more.

Automate And integrate Your Product Hub Using API's

With the recent advancements in REST webservices, you may also be interested in reviewing additional functionality provided by Integrated SOA Gateway to transform the PL/SQL APIs into REST web services easily. Once deployed as a web service, users could access the service from any end-point like a browser, mobile device etc.

References: