Running the CustomAPI Project

You can run the CustomAPI project to see how to use the Custom API activity to call a PL/SQL procedure from Oracle Database Dictionary.

Note: See ACCOUNT_MGR Package 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 CustomAPI project.
  2. Configure the Oracle E-Business Suite connection:
    1. Expand Resources > customapi.
    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 > customapi.
    2. Double-click Custom_package.bwp.
  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 in the Output tab in the Job Data view to see whether the process runs successfully.

    The following figure shows a sample of the running result:

Contents
Search Results