Running the OracleCP Project

You can run the OracleCP project to see how to use the Oracle Concurrent Program WICMLP to call JDBC to insert data into interface tables and to submit a Concurrent Program request.

Note: See WICMLP Concurrent Program Configuration for details of the configuration and inputs of the activity.

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 OracleCP project.
  2. Configure the Oracle E-Business Suite connection:
    1. Expand Resources > oraclecp.
    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 > oraclecp.
    2. Double-click WICMLP.bwp.
  4. Execute the generated SQL script:
    1. Click Generate SQL Script in the General tab to generate the SQL scripts.
      See Oracle Concurrent Program General Tab for more details.
    2. Execute the SQL script on the command line to grant insertion privileges to the plug-in user for the interface table.
  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 STATUS in the Output tab in the Job Data view to see whether the process runs successfully. "Normal" stands for success, and "Error" 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 Manufacturing and Distribution Manager > Other > Concurrent to open the Find Requests dialog.

    3. Click Find to view the search results.

      The following figure shows the search results:

    4. Close the Requests dialog.
    5. In the Navigator - Manufacturing and Distribution Manager dialog, expand WIP > Discrete, and then double-click Discrete Jobs.
    6. In the Organizations dialog, select the M1 organization that is defined in the input, and then click OK.

    7. In the Find Discreet Jobs (M1) dialog, enter tib_job0% in the Jobs field, and then click Find.
      The following figure shows the Jobs dialog:

    8. Click OK to view the Discrete Jobs details.

      The following figure shows the Discrete Jobs details:

Contents
Search Results