Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Installation and User’s Documentation | About Oracle Apps Adapter | Adapter Services | Adapter Service Templates
 
Adapter Service Templates
You use adapter service templates to configure adapter services. Each adapter service template represents a specific Oracle Applications operation. For example, the Insert SQL template enables you to insert business documents into the Oracle Applications open interface tables in one operation.
Adapter service templates contain all of the code that is necessary to perform an operation on an Oracle Applications system, but without the Oracle Applications data specifications. You provide these specifications through transaction definitions when you configure an adapter service.
Configuring a new adapter service from an adapter service template is straightforward. Using Designer, you assign the service a default adapter connection, select the adapter service template, and supply your transaction definition.
After you configure an adapter service, you can incorporate it into a flow service or Java service to interact with an Oracle Applications system. For example, you can create a flow service that collects customer order information from another one of your backend systems and then within that service you can call an Insert SQL service to insert the customer order information into your Oracle Applications system.
Oracle Apps Adapter provides the following adapter service templates for adapter services:
Adapter Service Template
Description
Insert SQL
This type of service is used to insert business documents into Oracle Applications using the open interface tables names specified in the IS-to- Oracle Applications transaction definitions.
You can execute this service with an Error service (using the Simple SQL service template) to verify the status of the import performed by the concurrent process.
See Configuring Insert SQL Services for instructions.
Compound Select SQL
This type of service is used to query an Oracle Applications system and retrieve data based on the query conditions (specified in either a SQL tree or stored procedure).
You can execute this service with an Acknowledge service (using the Simple SQL service template) to notify Oracle Applications that the document has been processed. This prevents the document from being retrieved multiple times.
Simple SQL
Use this template to create Acknowledge services or Error services:
*When used with a Compound Select SQL service, Acknowledge services maintain an accurate status of the transactions within the Oracle system. You create an Acknowledge service from an Oracle Applications -to-IS transaction definition that either calls a stored procedure or executes a SQL UPDATE statement to tell the Oracle Applications instance that the transaction has been processed.
*When used with an Insert SQL service, Error services query Oracle Applications for errors that might have occurred during the import process. You create an Error service from an IS-to- Oracle Applications transaction definition that is based on a stored procedure, view, or SQL SELECT statement. The service receives the query parameters for the SQL statement via the service specification.
See Configuring Simple SQL Services for instructions.