Editing Integration Server-to- Oracle Applications Transaction Definitions
Note:
You should be familiar with the Oracle Applications data schema before editing transaction definitions. Please refer to your Oracle Applications technical documentation or consult your Oracle Applications administrator before editing the transaction definitions.
To edit transaction definitions
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.
6. Select the transaction definition you want to edit, and then click Edit. The adapter displays the Edit transaction Transaction screen.
7. Update the transaction definition as follows:
To add a new table, enter the table name in the
Table Name field, indicate whether the table is required, and then click
Submit.
To delete a table, select the table from the list of current tables, and then click
Delete Table.
To change the error log SQL, click
Edit Error SQL. The adapter displays the
Error Service SQL For transaction screen. Update the SQL in the
Error SQL field, and then click
Submit. The error log SQL is SQL code that checks for errors that occur during the import process.
8. When you are finished updating the transaction definition, click Back.
Important:
If you change a transaction definition, you must refresh any services that were created from that transaction. Refreshing the services causes Integration Server to update the information in its cache for the affected services. For more information about updating the information in Designer, see the webMethods Service Development Help for your release.