EGO_ITEM_PUB Package Configuration

You can use the EGO_ITEM_PUB package to create inventory items and assembly items.

The following figure shows a sample configuration of the EGO_ITEM_PUB package:

Note: As defined in Oracle Integration Repository, EGO_ITEM_PUB.PROCESS_ITEM is a convenient wrapper to Process_Item. You can use this API to create or update an item by passing only the most important and commonly used item attributes.

The following table lists the EGO_ITEM_PUB package inputs of the TIB_CPU activity in the OracleAPI project:

Parameter Type Input
P_API_VERSION NUMBER 1.0
P_INIT_MSG_LIST VARCHAR2 T
P_COMMIT VARCHAR2 T
P_TRANSACTION_TYPE VARCHAR2 CREATE
P_LANGUAGE_CODE VARCHAR2 US
P_TEMPLATE_ID NUMBER 259
P_TEMPLATE_NAME VARCHAR2 Purchased Item
P_SEGMENT1 VARCHAR2 TIB_CPU
P_ORGANIZATION_ID NUMBER 204
P_ORGANIZATION_CODE VARCHAR2 V1
P_CATALOG_STATUS_FLAG VARCHAR2 N
P_DESCRIPTION VARCHAR2 TIBCO EBS Plug-in Create CPU item
P_PRIMARY_UOM_CODE VARCHAR2 Ea
P_INVENTORY_ITEM_STATUS_CODE VARCHAR2 Active
P_BOM_ENABLED_FLAG VARCHAR2 Y
P_ENG_ITEM_FLAG VARCHAR2 N
Note: You can define these parameters manually or automatically by defining a module property. For how to define module properties, see "Using Process and Module Properties" in TIBCO ActiveMatrix BusinessWorks Samples.