The sample transactions enable you to use the Oracle Apps Adapter to create adapter services to insert data into Oracle Applications open interface tables. A fully defined IS‐to‐Oracle transaction has two parts: the open interface table(s) and an error SQL query. The transaction may group one or more open interface tables together. Every column from each open interface table for the defined transaction will be exposed as input to the adapter service. After the service inserts records into corresponding open interface tables, Oracle Applications must run the respective import process. When completed, you can test the transaction for errors from the Integration Server by using the error SQL query. This has inputs into which the user maps query parameter values. The service then runs the query and the results are available as service outputs.

For more information on the IS‐to‐Oracle transactions, see your Oracle Applications documentation.

This chapter shows the transactions in alphabetical order. The table below shows the transactions organized by Oracle Applications module.