Creating Integration Server-to- Oracle Applications Transaction Definitions
Perform the following procedure to create transaction definitions that insert data from Integration Server into Oracle Applications tables.
To create a new
Integration Server-to-
Oracle Applications transaction definition
1. In the Adapters menu in the Integration Server Administrator navigation area, click Oracle Apps Adapter.
2. In the Oracle Apps Adapter menu in the navigation area, click Transaction Mgmt.
3. Click Transaction Configuration.
4. Select the Oracle Applications release from the list.
5. Select IS-to-Oracle in the Transaction Type field if it is not currently selected.
6. Click Add. The adapter displays the New Transaction screen.
7. Specify a name for the transaction in the Transaction Name field.
8. Click Submit.
9. Enter the name of an open interface table in the Table Name field. If you want to specify that this table is required, check the Required option. Then click Submit.
Repeat this step for each table you want the transaction to have access to. If you want to add a new table but a table is currently selected, click Cancel to de-select the current table.
Each table added appears in the Current Tables area. If you want to delete a table from the list, select it and then click Delete Table.
10. To specify SQL to check for errors that occurred during the import process, click Edit Error SQL. The adapter displays the Error Service SQL for transaction screen. Add the SQL in the Error SQL field, and then click Submit.
To expose an SQL input parameter as a service input in Designer, enclose the input parameter within an ampersand (&) and an asterisk (*) (for example, &varname*). Stored procedure input parameters are exposed as service inputs in Designer.