Getting Started with the Oracle E-Business Suite Adapter

This chapter covers the following topics:

Getting Started with the Oracle E-Business Suite Adapter

The Oracle E-Business Suite Adapter is one of many predefined adapters included with Oracle Integration Cloud Service allowing you to securely connect and use Oracle E-Business Suite services in integrations in Oracle Integration Cloud Service. 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 Service 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 Service allows you to connect to Oracle E-Business Suite Release 12.1.3 as well as Release 12.2.3 and onwards.

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 Service 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 and Concurrent Programs are available as REST services for invocation from Oracle Integration Cloud Service.

To access these REST services or interfaces in Oracle E-Business Suite on-premise which is behind the firewall, Oracle Integration Cloud Service 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 Service is also referred as an inbound (trigger or source) integration in Oracle Integration Cloud Service.

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 Service.

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 Service. 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 Service 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 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 REST services.

HTTP Basic Authentication Security

HTTP Basic Authentication security is the only supported 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 Service, 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 Service to Oracle E-Business Suite at runtime.

Concepts and Features

Key Features

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

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 Service:

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 Service. Setting Up and Creating an Oracle E-Business Suite Adapter Connection
1 Create an Oracle E-Business Suite connection.
Establish the connection between Oracle E-Business Suite and Oracle Integration Cloud Service through the Oracle E-Business Suite Adapter.
Creating an Oracle E-Business Suite Connection with the Oracle E-Business Suite Adapter
2 Test the Oracle E-Business Suite connection.
Ensure that you can successfully connect to the Oracle E-Business Suite instance you specified.
Testing 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).
Creating Mappings and Lookups
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. Monitoring and Managing Integrations
7 Track payload fields in messages during runtime.
  • Assigning Business Identifiers for Tracking Fields in Messages, Developing Integration Cloud Services chapter, Oracle Cloud Using Oracle Integration Cloud Service

  • Managing Business Identifiers for Tracking Fields in Messages, Administering Integration Cloud Service chapter, Oracle Cloud Using Oracle Integration Cloud Service

8 Manage errors at the integration level, connection level, or specific integration instance level.
  • Managing Errors, Administering Integration Cloud Service chapter, Oracle Cloud Using Oracle Integration Cloud Service

  • 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: