Overview

Adapter services enable you to integrate with Oracle Applications systems by executing transactions against Oracle Applications systems. Adapter services use transaction definitions to determine the processing to perform on an Oracle Applications system.

Sample transaction definitions are available that you can use to configure your own adapter services. You can use the samples as they are provided, or you can modify them or create new transaction definitions customized for your needs. This flexibility facilitates integration with highly customized Oracle Applications.

Transaction definitions are interfaces to Oracle Applications functions. The sample transaction definitions wrap the functionality of open interface tables, stored procedures, views, and raw SQL statements. For example, there is a sample transaction definition that wraps the Sales Order open interface table in the Oracle Applications Financials package. The transaction definitions, along with the Oracle Applications Adapter connection definitions, are stored in the webMethods repository.

For Oracle Applications integrations that are not highly customized, there are sets of predefined transaction services that are available as add-ons to the Oracle Apps Adapter. Predefined transaction services are complete, ready‐to‐use flow services that simplify the process of integrating with Oracle Applications systems. We recommend that if there are predefined transaction services that perform the operation you want to accomplish using a adapter services you created, you should use the predefined transaction services rather than creating your own adapter services.

Oracle Apps Adapter. The Oracle Apps Adapter is delivered in a package named WmOAAdapter. The WmOAAdapter package includes:

Administrative user interfaces to configure and manage adapter connections and transaction definitions. Using these interfaces you can:

Configure the login parameters that the Oracle Apps Adapter uses to establish a client connection with one or more Oracle Applications.

Designer user interface to configure an adapter service for each transaction that you want to expose (make available) through the Integration Server.

The built‐in services perform activities such as inserting and updating data, and managing database connections. Adapter services wrap built‐in functions and make them accessible to the Integration Server.

Open Interface Tables. Rather than directly updating the Oracle Applications DBMS, the adapter services first place the data into open interface tables. Oracle then runs an import process to copy the data from the tables into the live Oracle Applications database. Data is checked during table insertion and again during the import process, thus ensuring data integrity.

Stored Procedures. webMethods product suite provides sample transaction definitions that map to the stored procedures. You configure adapter services from these transaction definitions to programmatically retrieve data from the DBMS.

Views. webMethods product suite provides views that you install on the Oracle Applications instance. Oracle Applications uses the views to perform webMethods transactions.