The sample transactions 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 about the IS‐to‐Oracle Applications 10.7SC 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.