Transaction Definitions
Transaction definitions map to functions you can perform in Oracle Applications systems. Use the Oracle Applications Adapter to configure and run adapter services, which execute transactions to retrieve data from, and insert and update data in, Oracle Applications systems via the Oracle Applications open interface tables.
There are sample transaction definitions for Oracle Applications versions 10.7SC, 11.0, and 11.5. See the following chapters for descriptions of the sample transaction definitions.
A transaction definition can map to open interface tables, stored procedures, views, and raw SQL statements. The Oracle Applications Adapter enables you to modify the sample transaction definitions and to define your own transaction definitions. This flexibility facilitates integration with highly customized Oracle Applications. For more information about configuring or editing transaction definitions, see the webMethods Oracle Applications Adapter User’s Guide.
Note:
The sample transaction definitions described in this guide are the same transaction definitions that were provided with the Oracle Applications Adapter version 2.0.
Importing and Exporting Transaction Definitions
The sample transaction definitions are provided as .txp files, and are located in the following directory, where nnn is the version of Oracle Applications:
IntegrationServer_directory\packages\WmOAAdapter\OriginalTxns_nnn
The transaction definitions are delivered in the following files:
Transaction Set | File Name |
Oracle Applications 11.5 | wm_115.txp |
Oracle Applications 11.0 | wm_110.txp |
Oracle Applications 10.7SC | wm_107SC.txp |
Before you can use the sample transaction definitions you must import them into your system.
You can import transaction definition files from the Server Administrator or from Designer. For instructions, see the chapter on managing transactions in the webMethods Oracle Applications Adapter User’s Guide. After you import the transaction definitions, they are stored in the repository.
Note:
If you are upgrading from an earlier version of the adapter to version 6.0, you must re‐import the transaction definitions into the repository.
The adapter also enables you to export your transaction definitions to files. You can export your transactions to files to back up your transaction definitions or to transfer them to a different installation of the Oracle Applications Adapter. See the webMethods Oracle Applications Adapter User’s Guide for instructions for importing and exporting transaction definitions.