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 is exposed as an input to the adapter service. After the service inserts records into the corresponding open interface tables, Oracle Applications must run the respective import process.

After a transaction completes, you can test it for errors from the Integration Server by using the error SQL query. The SQL query has inputs into which you can map query parameter values. The service then runs the query and the results are available as service outputs.

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

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