Working with the OracleAPI Project

The OracleAPI project demonstrates how to create inventory items and BOM (Bill of Material) bills by Oracle PL/SQL Interface through the TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite.

Note: This example requires the use of the Vision Demo environment. It relies on responsibility, users, and data in the demo installation.

Two processes are preconfigured in the OracleAPI project, EGO_ITEM_PUB.bwp process and BOM_BO_PUB.bwp process . In these two processes, inventory items, assembly item, and BOM bill are created, as shown in the following figure.

Sample of the Created BOM Bill

Note: This example is configured to work against the Oracle E-Business Suite Vision Demo environment. All inputs are valid under this environment.

EGO_ITEM_PUB.bwp Process

The EGO_ITEM_PUB.bwp process creates inventory items for Oracle E-Business Suite by using the Oracle API activities.

The process is designed with the following activities:

Note: For the five activities in this process, you can create an activity, and then rename the activity and modify the parameters to create different activities and run the activities separately; or you can create all activities at a time and run them simultaneously.

Activity	Description
TIB_CPU	Creates the CPU inventory item for Oracle E-Business Suite.
TIB_HD	Creates the Hard Disk inventory item for Oracle E-Business Suite.
TIB_RAM	Creates the RAM inventory item for Oracle E-Business Suite.
TIB_RAM1	Creates the RAM1 inventory item for Oracle E-Business Suite.
TIB_MAINBOARD	Creates the Main Board inventory item for Oracle E-Business Suite.

BOM_BO_PUB.bwp Process

The BOM_BO_PUB.bwp process creates an assembly item and a BOM bill for Oracle E-Business Suite by using the Oracle API activities.

The process is designed with the following activities:

Activity	Description
TIB_MainMachine	Creates the Main Machine assembly item for Oracle E-Business Suite.
OracleAPI	Creates a BOM bill for Oracle E-Business Suite.