Running the EGO_ITEM_PUB.bwp Process

You can run the EGO_ITEM_PUB.bwp process in the OracleAPI project to see how to create inventory items for Oracle E-Business Suite by using the Oracle API activities.

Note: See EGO_ITEM_PUB Package Configuration for details of the configurations and inputs of the activities in the EGO_ITEM_PUB.bwp process.

Prerequisites

Before running the project, ensure that you have connected to an Oracle Database Server and imported the project to TIBCO Business Studio. See Connecting to Oracle Database Server and Importing Sample Projects for more details.

Procedure

  1. In the Project Explorer view, expand the OracleAPI project.
  2. Configure the Oracle E-Business Suite connection:
    1. Expand Resources > oracleapi.
    2. Double-click OEBSConnectionResource.oebsconnectionResource.
    3. In the OEBS Connection editor, edit the resource connection, and then click Test Connection to validate your connection.

    See Oracle E-Business Suite Connection for more details about how to configure the connection.

  3. Open the process:
    1. Expand Processes > oracleapi.
    2. Double-click EGO_ITEM_PUB.bwp.
    Note: The activities in this process are already configured; therefore, you do not need to configure the activities. However, if you switch to a different Oracle E-Business Suite version, you must click Search Procedure to reselect the PROCESS_ITEM procedure. This is because the parameter number of the PROCESS_ITEM procedure in the EGO_ITEM_PUB package changes when you connect to a different version of Oracle E-Business Suite. In Oracle E-Business Suite 12.1.x and 12.0.x, the parameter number of the PROCESS_ITEM procedure is 74; in Oracle E-Business Suite 12.2.x, the parameter number is 75. The samples of plug-in 6.1.0 are created on Oracle E-Business Suite 12.1.x.
  4. Expand Module Descriptors and double-click Components.
    By default, both processes are listed in the Components editor. Click the Create Process Component icon to add the process you want to run, or click to remove the process.
  5. Save the project.
  6. From the menu, Click Run > Debug Configurations, or click Debug > Debug Configurations.
  7. Click BusinessWorks Application > BWApplication in the left panel in the Debug Configurations window.
    By default, all applications in the current workspace are selected in the Applications tab.
  8. Click Deselect All in the Applications tab, and select the check box next to the project you want to run.
  9. Click Debug to run the process.
  10. Click the Terminate icon in the Console view to stop the running process.
    You can check the value of X_RETURN_STATUS in the Output tab in the Job Data view to see whether the process runs successfully. "S" stands for success, and "E" stands for error.
  11. Request result in Oracle E-Business Suite:
    1. Log in to the Oracle E-Business Suite system with the user name MFG and password welcome.
    2. Click Inventory > Items > Master Items to open the Oracle Applications window with the Navigator - Inventory dialog and the Organizations dialog is displayed.

    3. Select V1 organization from the Organizations dialog, and click OK.
    4. Click the Find icon.
    5. In the Find Master Items (V1) dialog, specify the search filter in the Item field (for example, TIB_%), and click Find.

      The following figure shows the result in the System Items dialog:

Contents
Search Results