Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Installation and User’s Documentation | Transaction Definitions | Editing Oracle Applications -to-Integration Server Transaction Definitions
 
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 fromCurrent 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.