Editing Oracle Applications -to-Integration Server Transaction Definitions
For information about how SQL trees are defined in
Oracle Applications -to-
Integration Server transaction definitions, see
Working with SQL Trees in
Oracle
Applications
-to-Integration Server Transactions.
Note:
You should be familiar with the Oracle Applications data schema before editing transaction definitions. Please see 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 Oracle-to-IS in the Transaction Type field.
6. Select the transaction definition you want to edit from the Current Oracle-to-IS Transactions list.
7. Click Edit.
8. Update the transaction definition as follows:
To update an existing alias, select the alias you want to edit from
Current SQL Tree for: transaction . If you want to edit a child alias, drill down to the child alias by selecting the parent alias and clicking
Next Level. Update the Alias Name, SQL, and Relations (if applicable) and then click
Submit.
To delete an alias, select the alias from
Current SQL Tree for: transaction and then click
Delete Alias.
To add a new alias, select the alias to which you want to add a child alias and then click
Next Level. Enter the Alias Name, SQL, and Relations information and then click
Submit.
9. When you are finished updating the transaction definition, click Previous Level until you return to the Transaction Configuration screen.
Important:
If you change a transaction, 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.