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. See
Configuring Compound Select SQL
Services for instructions. |
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. |