Implement Common Patterns Using the Oracle E-Business Suite Adapter

Overview

The Oracle E-Business Suite Adapter supports both inbound and outbound integrations in Oracle Integration Cloud. You can use the Oracle E-Business Suite Adapter as a trigger or as an invoke connection in an integration.

When adding the Oracle E-Business Suite Adapter as a trigger (source) connection, you can use a business event or an XML Gateway message to trigger an inbound integration in Oracle Integration Cloud.

When adding the Oracle E-Business Suite Adapter as an invoke (target) connection, you can use an Oracle E-Business Suite REST service to invoke an outbound integration from Oracle Integration Cloud. The available interface types that support this integration pattern are PL/SQL, Concurrent Program, and Open Interface Table and View.

Use Oracle E-Business Suite Business Events to Trigger Integration Endpoint in Oracle Integration Cloud

A business event is an occurrence in Oracle E-Business Suite that may trigger the next business process or action. An example of a business event can be a purchase order status change which may trigger an notification to be sent to the parties who have subscribed to the event. Oracle E-Business Suite provides various business events for use in integrations. To leverage the business event and event subscription features, you can configure the Oracle E-Business Suite Adapter with business events to invoke an integration endpoint in Oracle Integration Cloud.

You can locate a desired business event based on selected product family and product for your integration. When the selected business event is raised in Oracle E-Business Suite at runtime, the Oracle E-Business Suite Adapter will propagate the event information from Oracle E-Business Suite to Oracle Integration Cloud to trigger the integration.

Important: Before adding the Oracle E-Business Suite Adapter as a trigger (source) connection for an inbound integration in Oracle Integration Cloud, ensure that you have performed the required setup tasks to enable this feature. See Setup Tasks for Using the Oracle E-Business Suite Adapter as a Trigger (Source) Connection.

Use Oracle E-Business Suite XML Gateway Messages to Trigger Integration Endpoint in Oracle Integration Cloud

Oracle E-Business Suite provides various XML Gateway interfaces for use in integrations with trading partners and third party applications. By leveraging these XML Gateway interfaces and messages, Oracle E-Business Suite Adapter can be configured to support an easy integration between Oracle E-Business Suite and Oracle Integration Cloud through standard-based XML messaging. This integration pattern is an ideal solution when you need to interact with third party applications that use open standards. Moreover, it is also suitable for scenarios where trading partners change frequently.

Similar to business events, you can use outbound XML Gateway messages from Oracle E-Business Suite to trigger inbound integrations in Oracle Integration Cloud when adding the Oracle E-Business Suite Adapter as trigger (source) connections.

When an XML Gateway outbound transaction occurs in Oracle E-Business Suite at runtime, this message is enqueued to the ECX_OUTBOUND queue as an existing XML Gateway processing. Oracle Transport Agent (OTA) from Oracle XML Gateway will fetch the message from the queue and post it to Oracle Integration Cloud.

Note: You can define custom XML Gateway message maps to meet your needs if required.

Important: Before adding the Oracle E-Business Suite Adapter as a trigger (source) connection for an inbound integration in Oracle Integration Cloud, ensure that you have performed the required setup tasks to enable this feature. See: Setup Tasks for Using the Oracle E-Business Suite Adapter as a Trigger (Source) Connection.

After you create and activate the integration with XML Gateway messages, you must perform the post activation steps for the selected XML Gateway map to be successfully used in Oracle Integration Cloud. See: Post Activation Manual Steps for XML Gateway Messages as a Trigger.

Invoke Oracle E-Business Suite PL/SQL APIs from Oracle Integration Cloud

Oracle E-Business Suite contains numerous interface integration endpoints which can be exposed as REST services through Oracle E-Business Suite Integrated SOA Gateway. To leverage and use these Oracle E-Business Suite REST services to access Oracle E-Business Suite application data, you need to configure the Oracle E-Business Suite Adapter as invoke (target) connections.

PL/SQL REST services are one of the available interfaces for use in outbound integrations from Oracle Integration Cloud. In response to a request in an integration, a PL/SQL REST service can be invoked to access or update Oracle E-Business Suite application data to fulfill the integration needs.

Note: In addition to Oracle seeded PL/SQL APIs, you can use custom PL/SQL APIs or REST services for your integration needs.

Invoke Oracle E-Business Suite Concurrent Programs from Oracle Integration Cloud

In addition to using PL/SQL REST services as explained earlier, you can access and update Oracle E-Business Suite data through the use of concurrent program REST services.

A concurrent program runs as a concurrent process that executes multiple programs running in the background. To leverage the functionality provided by concurrent programs for Oracle E-Business Suite applications, you can configure the Oracle E-Business Suite Adapter to invoke a desired concurrent program REST service as an outbound integration from Oracle Integration Cloud.

Note: Similar to PL/SQL APIs, you can define and use custom concurrent programs in integrations in Oracle Integration Cloud.

Invoke Oracle E-Business Suite Open Interfaces from Oracle Integration Cloud

This pattern allows you to directly interact with the Oracle E-Business Suite application data stored in a desired open interface table. When you add the Oracle E-Business Suite Adapter as invoke (target) connections, open interface table and open interface view REST services are available for outbound integrations from Oracle Integration Cloud.

Depending on the direction of a selected open interface table in an integration, you can perform various actions to manage the data.

Open interface views are database objects that make data from Oracle E-Business Suite products available for selection. If you use an open interface view in an integration, you can only read the data stored in the selected open interface view.

Note: Custom interface types of open interface tables and open interface views are not supported.