Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Overview | Query Services | Using Query Services
 
Using Query Services
Before you can use a query service you must first:
1. Install the package containing the service you want to use. See Installing the Predefined Transaction Services for instructions.
2. Make sure you have installed the database scripts for the service. If a query service has a corresponding send service, the query service uses the same database scripts as its corresponding send service. If you will not be using the query service’s corresponding send service, you should disable all triggers associated with the send service. If you install triggers associated with a send service but do not use that service, the triggers will populate the WM_TRACKCHANGES table with records (according to the logic of the send service), and the records will never be removed from the table, causing the WM_TRACKCHANGES table to grow, consuming resources in your Oracle Applications system. You should disable triggers that are not being used by send services to avoid this problem. See Database Scripts for more information.
3. Before you can use any predefined transaction services you must reconfigure the default Oracle Apps Adapter connection parameters to point to your Oracle Applications system. All predefined transaction services for Oracle Applications 12.2.7 use a connection named OracleAppsDB1227. For instructions about editing connections, see the chapter on adapter connections in webMethods Oracle Applications Adapter Installation and User’s Guide .
To locate query services in Software AG Designer, see Database Scripts.