Adapter Services
You use the Oracle Apps Adapter to configure adapter services from transaction definitions. The services you configure perform the actions that the transaction definitions define. In other words, adapter services:
Interact with open interface tables to update the Oracle DBMS.
Execute a stored procedure or view to retrieve or update information in the Oracle DBMS.
Execute the SQL SELECT to retrieve information from the Oracle DBMS.
Execute the SQL UPDATE to modify information in the Oracle DBMS.
You can invoke the services that you create from any type of webMethods client: browser client, Java client, C/C++ client, or Visual Basic client. For example, you can create a browser client that allows a user to fill in an HTML form that interacts with your Oracle Applications instance via the Oracle Apps Adapter.
You can create a webMethods client that invokes the adapter service, or you can integrate the adapter service into an existing flow service. For example, if you want to code a webMethods client that creates a customer order from a purchase order, code the webMethods client to invoke the service that executes the OEOrderImport transaction of Oracle Order Management.