Oracle E-Business Suite Adapter enables you to orchestrate discrete data into a meaningful business process and creates Web services for various interface types within Oracle E-Business Suite. It plays the role of service provider for Oracle E-Business Suite to allow seamless integration between business partners, processes, applications, and end users in heterogeneous environment.
Oracle E-Business Suite Adapter provides the following features which are further discussed in this chapter:
Oracle E-Business Suite Adapter acts as a highly flexible integration interface for Oracle E-Business Suite. It supports the following interface types for integrating with Oracle E-Business Suite applications:
These APIs enable you to insert and update data in Oracle E-Business Suite using PL/SQL.
A business event is an occurrence in an internet application that might be significant to other objects in a system or to external agents. An example of a business event can be the creation of a new sales order or changes to an existing order.
The Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. The Business Event System consists of the Event Manager, which lets you register subscriptions to significant events.
When a local event occurs, the subscribing code is executed in the same transaction as the code that raised the event. Subscription processing can include executing custom code on the event information, sending event information to a workflow process, and sending event information to other queues or systems.
Business Event Groups
A business event group is a type of event containing a set of individual business events. Once an event group is defined, a subscription that is registered for an event group will be executed when any of the individual events within it is triggered.
With the support for business event groups, different business events belonging to an even group can be handled through a single partner link. Service created for an event group would be able to dequeue payloads corresponding to any of the events within the group.
Open Interface Tables
Interface tables enable you to insert or update data into Oracle E-Business Suite. The associated concurrent program should be running to move the data from the interface tables to base tables.
Concurrent programs enable you to move data from interface tables to base tables or execute any application logic.
Oracle XML Gateway
XML Gateway enables bidirectional integration with Oracle E-Business Suite. It helps you to insert and retrieve data from Oracle E-Business Suite. XML Gateway is a higher-level interface that exposes OAGIS-formatted XML documents for commonly used Oracle E-Business Suite business objects and business interfaces. XML Gateway integrates with interface tables, Oracle Workflow Business Event System (BES), and interface views to insert and retrieve data from Oracle E-Business Suite. It maps the underlying table data to XML and back.
Oracle e-Commerce (EDI) Gateway
Oracle e-Commerce Gateway provides a common, standards-based approach for Electronic Data Interchange (EDI) integration between Oracle E-Business Suite and third party applications.
Interface views help you to retrieve data from Oracle E-Business Suite using the application tables.
Please note that Oracle E-Business Suite Adapter also supports the following custom integration interface types that are exposed by the Oracle E-Business Suite Module Browser, not by Oracle Integration Repository:
Custom PL/SQL APIs
Custom Business Events
Note: Business events integration interface type is also exposed by Oracle E-Business Suite Module Browser, not by Oracle Integration Repository.
Custom XML Gateway Maps
Customized Concurrent Programs
Oracle Integration Repository, an integral part of Oracle E-Business Suite, is a prebuilt catalog of information about the numerous public integration interfaces delivered with Oracle E-Business Suite. It provides a comprehensive view of the integration interfaces with details for Oracle E-Business Suite.
Oracle Integration Repository can only provide information about an integration interface that has been specifically annotated by the developer to make it public. Oracle E-Business Suite Adapter takes advantage of the annotations that have already been created to make the following integration interface types visible in the Oracle E-Business Suite Module Browser:
XML Gateway message maps
Open Interface tables
e-Commerce Gateway EDI messages
These integration interfaces are exposed as Web services, and are available for process orchestration through the Oracle BPEL Process Manager.
For more information about Oracle Integration Repository, see the Navigating Through Oracle Integration Repository section, Oracle E-Business Suite Integrated SOA Gateway User's Guide. This guide is part of the Oracle E-Business Suite Documentation Library which can be accessed on the Oracle Technology Network (OTN).
Note: Oracle Integration Repository is integral part of Oracle E-Business Suite Release 12.0 onwards.
Oracle E-Business Suite Adapter leverages Integration Repository for Oracle E-Business Suite Release 11.5.10 and Release 12 as the source of truth for the integration content.
Oracle E-Business Suite Adapter supports selecting custom integration interfaces from the Integration Repository for the following versions of Oracle E-Business Suite:
Important: Please note that the support for various versions of Oracle E-Business Suite has the following conditions:
The required Oracle E-Business Suite database version for Oracle E-Business Suite Adapter 12c (12.1.3) is listed in the following table:
|Oracle Database Release||Oracle Database 11g Release 1||Oracle Database 11g Release 2||Oracle Database 12c Release 1|
|Minimum Required Database Version||18.104.22.168 or higher||22.214.171.124 or higher||126.96.36.199 or higher|
Oracle E-Business Suite Adapter supports Oracle E-Business Suite Release 11.5.10 (OWF.G.Rollup 7 required) as well as Release 12.0 and above.
To enable the native Oracle E-Business Suite connectivity using J2EE data sources feature, the minimum requirement for Oracle E-Business Suite Release 11i is 11i.ATG_PF.H.Delta.6 (RUP6), and for Oracle E-Business Suite Release 12 is Release 12.0.4.
See My Oracle Support Knowledge Document 787637.1 for details.
From the business service creation and run-time perspectives, Oracle E-Business Suite Adapter supports custom PL/SQL APIs as far as the packages are available in the APPS schema. The Oracle E-Business Suite Module Browser can expose these custom PL/SQL APIs for integration purposes during the design time.
From Release 12, Oracle Integration Repository is shipped as part of the Oracle E-Business Suite which enables Oracle E-Business Suite Adapter to directly connect to the live database of Oracle Integration Repository querying for the public interfaces and then displaying the list of custom integration interfaces under the Other Interfaces > Custom Objects node in the Oracle E-Business Suite Module Browser.
Supporting Custom Integration Interfaces in Release 12
Please note that Oracle E-Business Suite Adapter allows you to extract the Integration Repository data file from the live database you connect to Oracle E-Business Suite and create a local copy of the Integration Repository data file in your workplace. Next time when you look for public interfaces, the system can retrieve data from the cache in your workplace.
For detailed information about connecting to Oracle E-Business Suite Release 12, please refer to the Creating a Partner Link or Adding a Partner Link design-time task for each integration interface.
To support Oracle E-Business Suite Release 11.5.10, Oracle E-Business Suite Adapter provides the Integration Repository data file bundled as part of the product in xml format. During design time, Oracle E-Business Suite Adapter queries public interfaces from the native XML data file of the Integration Repository shipped with Adapter. Custom integration interfaces are queried directly from the live database and displayed under the Other Interfaces > Custom Objects node in the Module Browser.
Supporting Custom Integration Interfaces in Release 11.5.10
Oracle E-Business Suite Adapter supports high availability by completely relying on the functionality of the underlying Oracle Database Adapter and Oracle AQ Adapter to support the scenarios, such as Real Application Cluster (RAC) database configuration or clustering configuration.
For information about Oracle Database Adapter and Oracle AQ Adapter, see Oracle Fusion Middleware User's Guide for Technology Adapters.
To effectively diagnose and troubleshoot potential configuration issues, Adapter configuration reports can be enabled and displayed in the Oracle Fusion Middleware Control.
For information about these configuration reports, see the Monitoring Oracle JCA Adapters chapter, Oracle Fusion Middleware Administering Oracle SOA Suite and Oracle Business Process Management Suite.