PeopleSoft Adapter 6.0 | webMethods PeopleSoft Adapter Documentation | webMethods PeopleSoft Adapter Installation and User’s Documentation | Adapter Services | Configuring Delete Row Services
 
Configuring Delete Row Services
Delete Row services enable the adapter to delete a level 1 or higher CI record from a PeopleSoft database. For more information about Delete Row services, see Delete Row Services. You configure PeopleSoft Adapter services using Designer.
*To configure a Delete Row service
1. Review the steps in Before Configuring or Managing Adapter Services.
2. Start Designer.
3. 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 PeopleSoft 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 Delete Row template.
7. Click Finish.
The adapter service editor for the Delete Row service appears. 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.
8. Select the Component Interface tab to specify the PeopleSoft component interface to use with the Insert service. Specify values for the following fields:
Parameter
Description/Action
Component Interface
Specify the name of the CI with which the adapter service will interface, as follows:
*If the Enable List Of All Available CIs parameter for this service's associated adapter connection is set to TRUE, you can select the CI from a list of all available CIs on the PeopleSoft system.
The list of CIs reflects all CIs on the PeopleSoft system. However, the adapter service will only work if the CI's .class files are copied to the Integration Server directory. See Setting Up Your Adapter's Environment for details.
*If the Enable List Of All Available CIs parameter for this service's associated adapter connection is set to FALSE, you must type the name of the CI. This field is case sensitive.
For more information about the Enable List Of All Available CIsoption, see Configuring Adapter Connections. If you want Designer to display an error if you select an invalid CI name, you can turn on automatic validation of adapter services as described in Validating Adapter Service Values.
Interactive Mode
Select this option if you want the service to emulate an online component. That is, select this option if you want the service to apply values and run PeopleSoft business rules immediately, or whether you want the service to queue the items and run the business rules later, in a single step.
Get History Items
Select this option if you want the service to get records that have effective dates that are set to a past date.
Edit History Items
Select this option if you want the service to be able to modify records with effective dates that are set to a past date.
To use this option, you must also select the Get History Items option.
9. Select the Lookup Key Fields tab and specify the CI key fields that the service will use to locate the level 0 record from which you want to delete level 1 or higher records.
The tab contains the following information:
Parameter
Description/Action
CI Field Name
This column lists all Get key fields that you can use to identify records for the CI.
CI Field Type
This column lists the PeopleSoft data type for the CI Get field name.
Use Field
Select this option for each field you want to use as an input for locating the level 0 record, or click the icon to select all of the fields.
Fields that you select on this tab will appear in the adapter service's input signature (see the Input/Output tab) within a document called ServiceNameInput.LookupFields, where ServiceName is the name you specify for the service.
Input Field Name
If you choose to use a CI field, this column lists the webMethods field name.
Input Field Type
This column lists the webMethods data types for the service's CI input fields.
10. Select the Delete Key Fields tab and specify the CI fields that the service will use to delete level 1 or higher records. That is, the service uses the delete key fields to identify the level 1 or higher records to delete.
The tab contains the following information:
Parameter
Description/Action
CI Field Name
This column lists all available key fields for the CI.
CI Field Type
This column lists the PeopleSoft data type for the CI field.
Use Field
Select this option for each field you want to use as an input field to identify the record to delete, or click the icon to select all of the fields.
Fields that you select on this tab will appear in the adapter service's input signature (see the Input/Output tab) within a document called ServiceNameInput.DeleteKeys, where ServiceName is the name you specify for the service.
Delete Row Key Name
When you choose a field on this tab, this column lists the webMethods field name. Do not change the name of the field or the service will not work.
Fields you select here are included as output fields on the service's Input/Output tab.
Delete Row Key Type
This column lists the webMethods data types for the delete key fields.
11. Select the Output Fields tab and specify whether the service will return a status.
The tab contains the following information:
Parameter
Description/Action
Status Field
This column shows the STATUS output field.
Use Field
Select this option if you want the service to return a status.
If you choose to use the STATUS field, the field in the service's output signature (see the Input/Output tab).
Output Field Name
If you choose to use the STATUS field, this column lists the webMethods field name.
Output Field Type
This column lists the webMethods data type for the STATUS output field.
12. When using Designer, the Designer contains only the Adapter Settings and Input/Output tabs. The information from the Audit and Permissions tabs appears in the Properties panel, and the information from the Results tab appears in the Service Results panel (in Designer). For more information see the webMethods Service Development Help for your release.
13. From the File menu, select Save.