My Oracle Support Banner

How To Create or Update Inventory Items Using EGO_ITEM_PUB.PROCESS_ITEMS API ? (Doc ID 728350.1)

Last updated on JULY 17, 2023

Applies to:

Oracle Product Hub - Version 12.0.4 and later
Oracle Item Master - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***  ***





Goal

This document provides sample code and demonstration showing how items can be created or updated using APIs.
There are three different versions of the API available for creating items  -

EGO_ITEM_PUB.Process_Items : This API uses table data type to create or update multiple items from a single API call.
EGO_ITEM_PUB.Process_Item : A convenience wrapper that could be used to create or update a single item by passing only the most important item attributes.
EGO_ITEM_PUB.Process_Item : A full parameter list version of Process_Item that could be used to create or update a single item if you want to specify item attribute values that aren't exposed in the version of Process_Item. (Ex: To create Style Items / SKUs with variants, you can use this version)

The example on this note uses the most simple version of API EGO_ITEM_PUB.PROCESS_ITEMS to create a single item. 

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
 1. API code snippet
 2. Sample Code
 3. FAQ
 4. Test your knowledge
References

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