Setup Tasks for Enabling the Oracle E-Business Suite Adapter

Perform the following steps to set up the Oracle E-Business Suite Adapter:

  1. Configure Oracle E-Business Suite Integrated SOA Gateway REST services.

    Oracle E-Business Suite Integrated SOA Gateway is an essential component for the Oracle E-Business Suite Adapter in Oracle Integration. It is the path to access all Oracle E-Business Suite REST services that you can use in integrations in Oracle Integration.

    If you have not configured Oracle E-Business Suite Integrated SOA Gateway, perform the setup and configuration steps as described in the following documents:

    • For Oracle E-Business Suite 12.2

      Refer to Part A: Configuring Oracle E-Business Suite REST Services, Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2, My Oracle Support Knowledge Document 1311068.1.

      Ensure that you apply the latest patches for REST services in Document 1311068.1.

    • For Oracle E-Business Suite 12.1.3

      Ensure that you configure Oracle E-Business Suite Integrated SOA Gateway to enable the REST service features. If Oracle E-Business Suite Integrated SOA Gateway is not configured, follow the setup tasks as described in My Oracle Support Knowledge Document 556540.1 to configure Oracle E-Business Suite Integrated SOA Gateway Release 12.1.3.

      If Oracle E-Business Suite Integrated SOA Gateway is already configured in your instance, then apply these REST service patches in the sequence as described in My Oracle Support Knowledge Document 1998019.1 to enable the REST service features.

  2. Configure access to Oracle E-Business Suite services.

    To access Oracle E-Business Suite services from Oracle Integration, Oracle E-Business Suite services must be accessible in either of the following ways:

    • These services are deployed in an environment set up in a DMZ (DeMilitarized Zone) configuration so that Oracle E-Business Suite REST services are publicly accessible through the Internet.

      For DMZ configuration instructions in Oracle E-Business Suite, see Oracle E-Business Suite Release 12.2 Configuration in a DMZ, My Oracle Support Knowledge Document 1375670.1.

    • If your Oracle E-Business Suite is not set up in a DMZ configuration, these services must be accessible through Oracle Integration agent framework.

      For information about agents, see Manage the Agent Group and the On-Premises Connectivity Agent in Using Integrations in Oracle Integration Generation 2.

      Please note that the on-premises agent should not be installed in an Oracle E-Business Suite instance. Instead, it should be installed in a separate machine.

  3. Deploy the required REST services in Oracle E-Business Suite.

    To use Oracle E-Business Suite REST services for integrations, ensure that you have performed the following tasks:

    • Deploy the Metadata Provider/Integration Repository service

      The Metadata Provider/Integration Repository service is an API that fetches a list of services available for integration. To integrate these Oracle E-Business Suite services, you must deploy the "Metadata Provider" API as a REST service.

      You can search the "Metadata Provider" API from the Integration Repository, and then select the Metadata Provider API from the search results to display the interface details page.

      Please note that you must enter "provider" as the service alias name for the Metadata Provider API and select the GET HTTP method check boxes for ALL the methods contained in the API before deploying it as a REST service.

      Important: If the Metadata Provider API is not deployed as a REST service with GET HTTP method and "provider" as the service alias, the Oracle E-Business Suite Adapter in Oracle Integration will not work as expected.

    • Deploy the Event Manager service

      To use business events from Oracle E-Business Suite as a trigger (source) in an integration in Oracle Integration, you must deploy the Event Manager API as a REST service.

      Similar to the Metadata Provider service, you can search the "Event Manager" API from the Integration Repository, and then deploy it as a REST service. Before the deployment, you must enter "subscription" as the service alias name and select the POST HTTP method check boxes for ALL the methods contained in the API.

    • Deploy business function related APIs as Oracle E-Business Suite REST services

      If you want to integrate or use Oracle E-Business Suite integration interfaces in Oracle Integration, you must first deploy these interface definitions as Oracle E-Business Suite REST services.

      For example, to process a sales order in Oracle E-Business Suite, you must deploy the Sales Order Service (OE_INBOUND_INT) API as a REST service first before you can use this deployed Sales Order Service REST service from Oracle Integration through the Oracle E-Business Suite Adapter.

    For information on deploying REST services, see Deploying REST Web Services, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide.

  4. Grant the required user privileges.

    To use Oracle E-Business Suite REST services through the Oracle E-Business Suite Adapter in Oracle Integration, ensure that an Oracle E-Business Suite user has the privileges to:

    • Access the Metadata Provider/Integration Repository service

      Allowing the access of the "Metadata Provider" API enables the user to browse Oracle E-Business Suite services in Oracle Integration through the Oracle E-Business Suite Adapter.

    • Access the Event Manager service

      This enables the user to use business events as a trigger in Oracle Integration when adding the Oracle E-Business Suite Adapter as a trigger (source) in an integration.

    • Access or execute desired Oracle E-Business Suite APIs and services

      To protect application data from unauthorized access or execution, you must grant the user the interface access privileges for the REST services provided through Oracle E-Business Suite Integrated SOA Gateway.

    The Oracle E-Business Suite user credentials should be used to create an Oracle E-Business Suite connection in Oracle Integration. For example, if you plan to use an Oracle E-Business Suite user hrmanager from Oracle Integration to "create employee" in Oracle E-Business Suite, you need to:

    • Create a security grant on all the methods contained in the Metadata Provider API to the hrmanager Oracle E-Business Suite user.

    • Create a security grant on all the methods contained in the Event Manager API to the hrmanager Oracle E-Business Suite user.

    • Create a security grant on the "Create Employee" method in the Employee API to the hrmanager Oracle E-Business Suite user.

    • Use the hrmanager user credentials while creating an Oracle E-Business Suite connection in Oracle Integration.

    At runtime, the username and password information provided through the Oracle E-Business Suite Adapter connection will be passed to Oracle E-Business Suite for user authentication for the service being invoked in an integration.

    For information on creating security grants for REST services, see Managing Grants for Interfaces with Support for SOAP and REST Web Services, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide.

    For information on creating a connection with Oracle E-Business Suite Adapter, see Create an Oracle E-Business Suite Adapter Connection.