This chapter provides an in‐depth explanation of the Oracle Applications 10.7SC‐to‐IS sample transaction definitions. Oracle Applications‐to‐IS transactions perform queries against the Oracle database and return the requested information to the client.

This chapter describes the transactions as they exist in the samples. It does not cover any modifications that you can make to the sample transactions.

You should already have an understanding of the Integration Server, the Oracle Apps Adapter, and the Oracle Application open interfaces.

For information about IS‐to‐Oracle Applications 10.7SC transactions, see Chapter 5, "Transaction Definitions (IS-to-Oracle 10.7SC)".

The sample transactions retrieve data from Oracle Applications. These transactions are triggered from within the Integration Server. A fully defined Oracle‐to‐IS transaction has two parts: a functional query and an acknowledgment update. The functional query will have inputs into which the user maps query parameter values. The service then runs the query and the results are available as service outputs. The acknowledgment service updates the database to indicate that a record has been processed.

The current list of transactions includes the following: