Establish Oracle E-Business Suite Connections

Before creating an integration, you need to establish the following connections that will be used later in this example:

Create the Connection for Oracle E-Business Suite Order Management

This section describes how to create a connection for the Oracle E-Business Suite Order Management instance by using the Oracle E-Business Suite Adapter. This connection will be added later as a trigger (source) in an integration.

Perform the following steps to establish the connection for Oracle E-Businss Suite Order Management in Oracle Integration:

  1. In the navigation pane, click Home > Integrations > Connections.

  2. On the Connections page, click Create.

  3. In the Create Connection - Select Adapter dialog appears.

    You can locate the Oracle E-Business Suite Adapter by entering a full or partial name to locate "Oracle E-Business Suite" from the dialog.

    For example, enter "Oracle E-Business Suite" in the Search field. The Oracle E-Business Suite Adapter is filtered from the list of adapters.

    Click the Select button for "Oracle E-Business Suite" to use the Oracle E-Business Suite Adapter. The Create Connection dialog appears.

  4. Enter the following information for the Oracle E-Business Suite Order Management connection:

    • Connection Name: Enter "Order Management".

    • Identifier: Accept the default populated identifier such as, ORDER_MANAGEMENT".

    • Keywords: Enter "Order Management".
    • Connection Role: Select the "Trigger and Invoke" role for this connection.

    • Description: Enter "Create an Oracle E-Business Suite Order Management connection" as the description.

    Click Create to create the connection.

  5. The Connection Details page is displayed for the "Order Management" connection you just created. Enter additional connection details by specifying the following information:

    • In the Connection Properties section, enter a URL (http://<Oracle E-Business Suite host name>:<port>) to connect to an Oracle E-Business Suite Order Management instance.

    • In the Security section, enter operations as the user name and its associated password to access the Oracle E-Business Suite

      Order Management instance you specified earlier in the Connection Properties section.
  6. Click Test to test the "Order Management" connection you just specified.

  7. When complete, click Save and then click Back button.

Oracle E-Business Suite connection "Order Management" appears in the Connections page.

Create the Connection for Oracle E-Business Suite Accounts Receivables

As described earlier that Oracle E-Business Suite Order Management and Accounts Receivables are two different instances used in this example, you need to create a connection for the Oracle Accounts Receivables instance by using the REST Adapter. This connection will be added later as an invoke (target) to an integration.

  1. In the navigation pane, click Home > Integrations > Connections.

  2. On the Connections page, click Create.

  3. In the Create Connection - Select Adapter dialog appears.

    Enter "REST" in the Search field. The REST Adapter is filtered from the list of adapters.

    Click the Select button for "REST" to use the REST Adapter. The Create Connection dialog appears.

  4. Enter the following information for the Oracle E-Business Suite Accounts Receivables connection:

    • Connection Name: Enter "Receivables" as the connection name.

    • Identifier: Accept the default populated identifier such as "RECEIVABLES".

    • Keywords: Enter "Receivables".
    • Connection Role: Select the "Trigger and Invoke" role for this connection.

    • Description: Enter "Create a connection for Oracle E-Business Suite Receivables" as the description.

    Click Create to create the connection.

  5. The Connection Details page is displayed for the "Receivables" connection you just created. Enter additional connection details by specifying the following information:

    • In the Connection Properties section, enter the following information:

      • Connection Type: Select "REST API Base URL".

      • Connection URL: Enter a connection URL (http://<Oracle E-Business Suite host name>:<port>/webservices/rest/invoice) for the Invoice Creation REST service with invoice alias name that you deployed earlier while preparing the Receivables instance.

    • In the Security section, accept the "Basic Authentication" as the default security policy.

      Enter operations as the user name and its associated password to access the Invoice Creation REST service you specified earlier in the Connection Properties section.

  6. Click Test to test the connection you just specified for Oracle E-Business Suite Accounts Receivables.

  7. When complete, click Save and then click Back button.

Oracle E-Business Suite connection "Receivables" now appears in the Connections page.