Running the BOM_BO_PUB.bwp Process

You can run the BOM_BO_PUB.bwp process in the OracleAPI project to see how to create assembly items and BOM bills for Oracle E-Business Suite by using the Oracle API activities.

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

Prerequisites

Run the EGO_ITEM_PUB.bwp process successfully. See Running the EGO_ITEM_PUB.bwp Process for details.

Procedure

  1. Open the process:
    1. Expand Processes > oracleapi.
    2. Double-click BOM_BO_PUB.bwp.
    Note: The activities in the 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, for the TIB_MainMachine activity, 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.
  2. Execute the BOM_BO_PUB.sql file by using the apps user on the command line.

    Because the BOM_BO_PUB.PROCESS_BOM procedure contains package types, you must use JPublisher to generate wrapper package first. In this example, two PL/SQL files are generated, BOM_BO_PUB.sql and BOM_BO_PUB_drop.sql. See Introduction to Oracle Database JPublisher for more details.

    Note: After using JPublisher to generate the wrapper package for the BOM_BO_PUB.PROCESS_BOM procedure, if you issue the BOM_BO_PUB.sql file, issue the BOM_BO_PUB_drop.sql file, reissue the BOM_BO_PUB.sql file, and then run the process, the invalid data type error exception is thrown. To solve this issue, you can restart TIBCO Business studio, and then run the process again.
  3. 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.
  4. Save the project.
  5. From the menu, Click Run > Debug Configurations, or click Debug > Debug Configurations.
  6. 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.
  7. Click Deselect All in the Applications tab, and select the check box next to the project you want to run.
  8. Click Debug to run the process.
  9. Click the Terminate icon in the Console view to stop the running process.
    You can check the value of 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.
  10. 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 Manufacturing and Distribution Manager > Bills of Materials > Bills > Bills to open the Navigator - Manufacturing and Distribution Manager dialog.
    3. Select V1 organization from the Organizations dialog, and click OK.

    4. Click the Find icon.
    5. In the Find Bills (V1) dialog, specify the search filter in the Item field (for example, TIB_%), and click Find.

      The following figure shows the result in the Oracle E-Business Suite web system:

Contents
Search Results