1. Using the Oracle E-Business Suite Adapter with Oracle Integration 3
  2. Oracle E-Business Suite Adapter Samples
  3. An Example of Using a PL/SQL REST Service as an Invoke (Target) Connection in an Integration
  4. Add the Oracle E-Business Suite Adapter as an Invoke (Target) Connection

Add the Oracle E-Business Suite Adapter as an Invoke (Target) Connection

After adding the REST Adapter trigger connection to the integration, you can add the Oracle E-Business Suite connection "EBS122" that you created earlier as an invoke (target) connection.

Perform the following steps to add the Oracle E-Business Suite Adapter as an invoke (target) connection:

  1. In the Create Order integration canvas, hover your cursor over the lines after the Trigger icon and click the + sign to search the "EBS122" connection that you created earlier from the Invokes menu selection.

    The Oracle E-Business Suite Adapter Endpoint Configuration Wizard appears.

  2. In the Basic Info page, enter the following information for your endpoint:

    • What do you want to call your endpoint? - Enter "EBS_Reference".

    • What does this endpoint do? - Enter "Create a Sales Order in Oracle E-Business Suite".

    Click Next.

  3. In the Web Services page, specify the following information for your target connection:

    • Product Family: Select "Order Management Suite" from the drop-down list.

    • Product: Select "Order Management".

    • Interface Type: Select "PL/SQL" from the list.

    After you select a desired product family, a product, and an interface type, a list of PL/SQL APIs including Oracle seeded APIs and custom ones contained in the selected product "Order Management" is populated for further selection.


    This image shows the Web Services page of the Oracle E-Business Suite Adapter Endpoint Configuration Wizard. It includes Product Family, Product, Interface Type, API, Internal Name, and Description. In the API field, “Filter by name” and “a list of API names” options are displayed top to bottom allowing you to locate your desired API.

    Select a desired API name, such as "Sales Order Services". The corresponding API internal name (OE_INBOUND_INT) and description are automatically populated.

    Click Next.

  4. The selected API internal name OE_INBOUND_INT appears in the Operations page.

    Select a desired method name contained in the selected OE_INBOUND_INT API for this invoke (target) connection. For example, select "PROCESS_ORDER".


    This image shows the Operations page of the Oracle E-Business Suite Adapter Endpoint Configuration Wizard. The following fields are displayed top to bottom: API, Methods, Service Status, and Description

    Click Next.

  5. The Summary page displays all the selected interface details. This information includes the selected "PROCESS_ORDER" operation (with "Ready to Use" status) contained in the "OE_INBOUND_INT" web service from the Order Management Suite product family and Order Management product. This page also displays the default interaction pattern "Synchronize" for the selected service.


    This image shows the Summary page of the Oracle E-Business Suite Adapter Endpoint Configuration Wizard. The following read-only fields are displayed top to bottom with selected values, including Description: Create a Sales Order in Oracle E-Business Suite, Product Family: Order Management Suite, Product: Order Management, Web Service: OE_INBOUND_INT, Method: PROCESS_ORDER, Status: Ready to Use, and Interaction Pattern: Synchronous.

    The Oracle E-Business Suite Adapter Target Endpoint configuration is successfully created.

    Click Done.

  6. Click Save to save your work.

The connection for Oracle E-Businses Suite now appears in the canvas.