Configuring Insert SQL Services

Insert services enable the adapter to insert records into the Oracle Applications open interface tables. These records will either insert new information or update existing information in the Oracle Applications system.

For more information about Insert SQL services, see Adapter Service Templates.

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.

4. Select Oracle Apps Adapter as the adapter type and click Next.

5. Select the appropriate Adapter Connection Name and click Next.

6. From the list of available templates, select the Insert SQL 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.

Once you create the service in Designer, the adapter service editor for the Insert SQL service appears.

8. Select the Insert SQL tab, if it is not already selected.

9. Select a transaction definition from the Transaction list.

10. 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.

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.

To test the service directly from Designer, see Testing Adapter Services.

You might also want to configure an Error service to verify that the information was correctly inserted. For more information, see Configuring Simple SQL Services.