Understand the Oracle E-Business Suite Adapter

This chapter covers the following topics:

Oracle E-Business Suite Adapter Capabilities

The Oracle E-Business Suite Adapter is one of many predefined adapters included with Oracle Integration Cloud allowing you to securely connect and use Oracle E-Business Suite services in integrations in Oracle Integration Cloud. It not only provides the connectivity between Oracle E-Business Suite and other cloud-based applications, but also significantly simplifies the complexity of typical integration experiences. Through the Oracle E-Business Suite Adapter, you can quickly integrate your systems with desired Oracle E-Business Suite services in the cloud, as well as monitor and manage the integrations when needed.

The Oracle E-Business Suite Adapter in Oracle Integration Cloud leverages the functionality of Oracle E-Business Suite Integrated SOA Gateway (ISG) to provide the access of Oracle E-Business Suite REST services.

Note: The Oracle E-Business Suite Adapter in Oracle Integration Cloud allows you to connect to Oracle E-Business Suite Release 12.1.3 as well as Release 12.2.3 and onwards.

The following diagram illustrates the supported integrations when using the Oracle E-Business Suite Adapter from Oracle Integration Cloud:

Supporting Inbound and Outbound Integrations

the picture is described in the document text

In this diagram, Business Events and XML Gateway messages are available for inbound integrations in Oracle Integration Cloud when adding the Oracle E-Business Suite Adapter as a trigger (source) connection in an integration. If the Oracle E-Business Suite Adapter is added as an invoke (target) connection, PL/SQL APIs, Concurrent Programs, as well as Open Interface Tables and Views are available as REST services for invocation from Oracle Integration Cloud.

To access these REST services or interfaces in Oracle E-Business Suite on-premise which is behind the firewall, Oracle Integration Cloud agents can be used if your Oracle E-Business Suite is not set up in a DMZ configuration.

Please note that an outbound integration from Oracle E-Business Suite into Oracle Integration Cloud is also referred as an inbound (trigger or source) integration in Oracle Integration Cloud.

Key Features

The Oracle E-Business Suite Adapter in Oracle Integration Cloud serves as a connection tool for you to access Oracle E-Business Suite services in the cloud. It has the following key features:

Common Terminologies

To better understand the Oracle E-Business Suite Adapter, the following common terminologies are explained in this section.

Oracle E-Business Suite Integrated SOA Gateway (ISG)

Oracle E-Business Suite Integrated SOA Gateway provides the functionality to expose integration interfaces published in the Integration Repository as SOAP and REST based web services.

Oracle E-Business Suite users with appropriate privileges can deploy these integration interfaces as REST services and manage the service lifecycle activities through the Integration Repository. The Oracle E-Business Suite Adapter in turn provides the access to these REST services that you can use for creating integrations in Oracle Integration Cloud.

Integration Repository

Integration Repository is an essential component in Oracle E-Business Suite Integrated SOA Gateway. It is the centralized repository that contains numerous interface endpoints within Oracle E-Business Suite.

When the connection to Oracle E-Business Suite is successfully established, Oracle E-Business Suite service metadata will be retrieved from the Integration Repository and imported to Oracle Integration Cloud. You can then create an integration by selecting a desired Oracle E-Business Suite service. The supported interface types for integrations in Oracle Integration Cloud through the Oracle E-Business Suite Adapter are:

Representational State Transfer (REST)

REST is an architecture principle in which the web services are viewed as resources and can be uniquely identified by their URLs. The key characteristic of a REST service is through the use of four HTTP methods (GET, POST, PUT, and DELETE) to denote the invocation of different operations.

Please note that POST is the only supported method for PL/SQL and concurrent program REST services. For open interface tables with Inbound direction, four HTTP methods are supported for REST service. For open interface tables with Outbound direction and open interface views, only the GET method is supported.

HTTP Basic Authentication

HTTP Basic Authentication is the only supported authentication security for REST services in this release.

When an HTTP client application tries to access an Oracle E-Business Suite REST service, user credentials (username/password) should be provided as input data in HTTP header as part of the REST request message. The username and password will be used for authentication and authorization.

From the perspective of the Oracle E-Business Suite Adapter in Oracle Integration Cloud, the username and password information is provided when creating an Oracle E-Business Suite connection. This credential information is then passed from Oracle Integration Cloud to Oracle E-Business Suite at runtime.

What Application Version Does the Oracle E-Business Suite Adapter Support?

For information about which application version is supported by Oracle E-Business Suite Adapter, see the adapter certification matrix:

Oracle Integration Adapters Certification at: http://www.oracle.com/technetwork/middleware/adapters/documentation/index.html

Typical Task Flow for Using the Oracle E-Business Suite Adapter

The following table describes the typical task flow of using the Oracle E-Business Suite Adapter in Oracle Integration Cloud:

Task Description More Information
Prerequisites Before using the Oracle E-Business Suite Adapter, you must perform setup tasks to ensure the appropriate user privileges and required features are in place and the Oracle E-Business Suite Adapter is ready for creating integrations in Oracle Integration Cloud. Set Up and Enable Oracle E-Business Suite Adapter for Integrations
1 Create an Oracle E-Business Suite connection.
Establish the connection between Oracle E-Business Suite and Oracle Integration Cloud through the Oracle E-Business Suite Adapter.
Create an Oracle E-Business Suite Connection
2 Test the Oracle E-Business Suite connection.
Ensure that you can successfully connect to the Oracle E-Business Suite instance you specified.
Test an Oracle E-Business Suite Connection
3 Create the integration.
Add the Oracle E-Business Suite Adapter as a trigger (source) or an invoke (target) connection while creating the integration.
4 Create mappings between the source and target data structures in the integration.
(Optional) Create lookups that map the different values used by those applications to identify the same type of object (such as gender codes or country codes).
Map Data and Create Lookups, Using Integrations in Oracle Integration Cloud
5 Activate the integration.
Once an integration is created with the required data mappings between the source and target connections, you can activate the integration to use it at runtime.
6 Monitor the integration on the dashboard. Monitor Integrations During Runtime, Using Integrations in Oracle Integration Cloud
7 Track payload fields in messages during runtime.
  • Assign Business Identifiers for Tracking Fields in Messages, Create Integrations chapter, Using Integrations in Oracle Integration Cloud

  • Manage Business Identifiers for Tracking Fields in Messages, Monitor Integrations During Runtime chapter, Using Integrations in Oracle Integration Cloud

8 Manage errors at the integration level, connection level, or specific integration instance level.
  • Manage Errors, Monitor Integrations During Runtime chapter, Using Integrations in Oracle Integration Cloud

  • Error Messages - error messages while testing the connection and creating the integration with the Oracle E-Business Suite Adapter at the design time

To better understand how to use the Oracle E-Business Suite Adapter in an integration, see:

Additionally, refer to the following documents for more information about the Oracle E-Business Suite Adapter: