Configuring Compound Select SQL Services
Includes Select services. For more information about Compound Select SQL services, see
Adapter Service Templates.
To configure a Compound Select SQL service
2. Start Designer.
3. If you are using Designer, perform the following:
a. Right-click the package in which the service should be contained and select New > Adapter Service.
b. Select the parent namespace and type a name for the adapter service.
c. Click Next.
4. Select Adapter Service from the list of elements, and click Next.
5. Select Oracle Apps Adapter as the adapter type, and click Next.
6. Select the appropriate Adapter Connection Name, and click Next.
7. Select the Compound Select SQL template and do the following:
Select a package and folder to contain the service, type a unique name for the service.
Select a package that contains only services that execute Oracle Applications transactions. By doing this, it is easier to back up and replicate those services because they are all contained in a separate package.
Important:
Do not store the services in the Oracle Applications package ( WmOAAdapter ) because the package is replaced when you upgrade the Oracle Apps Adapter.
8. Click Finish.
9. Select the Compound Select SQL tab, if it is not already selected.
10. Select a transaction definition from the Transaction list.
11. You can select the Adapter Settings tab at any time to confirm adapter service properties such as the Adapter Name, Adapter Connection Name, and Adapter Service Template, as necessary.
12. For information about configuring the Input/Output tab, see the webMethods Service Development Help for your release. This tab applies to all services that you configure using Designer.
13. From the File menu, select Save.
To test the service directly from
Designer, see
Testing Adapter Services.