Configuring Web Services for Setup Data

Oracle delivers several EIPs to automate the process of synchronizing setup data between CS and HCM; this ensures that the setup data underlying the transactional data remains in sync. Other delivered EIPs enable your institution to integrate data in support of External Search/Match and core business processes.

Note that person data EIPs are designated sync or fullsync. Fullsync EIPs republish all the data in their source records at once. Incremental sync EIPs send real-time sync messages; as soon as you make a change in the database of record, the system triggers the sync and sends only the changed information to the other database. This section discusses how to configure FullSync Service Operations.

See Configuring Web Services for Person Data

Configuring Full Sync Service Operations

The following steps for setting up and activating each FullSync service operation in Integration Broker must be performed on the source and target databases.

Source Database Configuration Tasks

Note:

These source database configuration instructions are for an HCM 9.1/9.2 database on PeopleTools 8.54.

1. Update security by adding the Service Operation(s) to your primary permission list:

   1. Navigate to PeopleTools , and then Security , and then Permissions & Roles , and then Permission Lists.

   2. Select the relevant permission list from the search dialog box.

   3. Select the Web Services tab.

   4. Enter the corresponding Service(s) for the Service Operation(s) you wish to use.

   5. Click the Edit link. On the Web Service Permissions secondary page, add access to the relevant Service Operation(s) listed by selecting the Full Access option for the Access column.

      This example illustrates the fields and controls on the Web Services page-Permission List.

      

      This example illustrates the fields and controls on the Web Services Permissions page for HCM.

      

2. Activate Service Operations and create Routings.

   1. Navigate to PeopleTools, and then Integration Broker, and then Integration Setup, and then Service Operations.

   2. Select the relevant Service Operation(s) from the search dialog box.

   3. Check the Active check box on the General tab.

   4. Make note of the Queue Name field, as you need to verify later that the Queue status is Running.

   5. Select the Routings tab and add a new routing for the Service Operation by entering a value in the Routing Name field and clicking the Add button.

      This example illustrates the fields and controls on the General page for the COUNTRY_FULLSYNC service operation.

      

      This example illustrates the fields and controls on the Routings page for the COUNTRY_FULLSYNC service operation.

      

   6. Enter a Sender Node and a Receiver Node on the Routings Definition page of the Routings component.

   7. Verify that the Active check box is checked.

   8. Save the routing.

   9. Click the Return button at the bottom of the Routings Definition page to return to the Service Operation setup component.

   10. Click Save at the bottom of any page in the Service Operations component to save the Service Operation.

       This example illustrates the fields and controls on the Routing Definitions page for the COUNTRY_FULLSYNC service operation.

       

3. Activate Message Queue.

   1. Navigate to PeopleTools, and then Integration Broker , and then Service Operations Monitor, and then Administration, and then Queue Status

   2. Scroll down the page to find the relevant Queue Name (from the Service Operation setup page noted earlier).

   3. Review the queue Status and activate the queue by clicking the Run button if needed. Before leaving this page, ensure that queue status is set to Running.

Target Database Configuration Tasks

Note:

These target database configuration instructions are for a CS 9.2 database on PeopleTools 8.54.

1. Update security by adding the service operation to the required user’s permission list.

   1. Navigate to PeopleTools, and then Security, and then Permissions & Roles, and then Permission Lists.

   2. Select the relevant permission list from the search dialog box (primary permission list for the user).

   3. Select the Web Services tab.

   4. Enter the corresponding Service(s) for the Service Operation(s) you wish to leverage.

   5. Click the Edit link and add access to the relevant Service Operation(s) listed on the Web Service Permissions secondary page.

   6. Click OK to return to the Web Services page.

   7. Click Save to save the updated Permission List.

      This example illustrates the fields and security controls on the Web Services page.

      

      This example illustrates the fields and security controls on the Web Service Permissions page in Campus Solutions.

      

2. Activate Service Operation and Create Routing.

   1. Navigate to PeopleTools, and then Integration Broker, and then Integration Setup, and then Service Operations.

   2. Select the relevant Service Operation(s) from the search dialog box.

   3. Select the Active check box on the General tab.

   4. Make note of the Queue Name field, as you need to verify later that the Queue status is Running.

      This example illustrates the fields and controls on the General page for the COUNTRY_FULLSYNC service operation.

      

   5. Select the Routings tab and add a new routing for the Service Operation.

   6. Enter a Sender Node and a Receiver Node on the Routings Definition page of the Routings component.

   7. Verify that the Active check box is checked.

   8. Click Save at the bottom of the Routings Definition page to save the routing.

   9. Click the Return at the bottom of the Routings Definition page to return to the Service Operation setup component.

   10. Click Save at the bottom of any page in the Service Operations component to save the Service Operation.

       This example illustrates the fields and controls on the Routings page for the COUNTRY_FULLSYNC service operation.

       

       This example illustrates the fields and controls on the Routing Definitions page for the COUNTRY_FULLSYNC service operation.

       

3. Activate or create the required Service Operations OnNotify handler.

   1. Click the Handlers tab of the Service Operations component and set up the following:

      This example illustrates the fields and controls on the Handlers page for the COUNTRY_FULLSYNC service operation.

      

      Field or Control	Description
      Name	Enter a Handler Name if one does not exist. For example, BusUnitHRFullSync. See the Full Sync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.
      Type	OnNotify
      Implementation	Application Class
      Status	Active

   2. Click the Details link and set up the following:

      This example illustrates the fields and controls on the Handler Details page.

      

      Field or Control	Description
      Package Name	For example, GEN_UPG_HANDLER_12332. See the FullSync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.
      Path	:
      Class ID	For example, CountryFullSync. See the FullSync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.
      Method	OnNotify

   3. Click OK to return to the Handlers setup page.

   4. Click Save at the bottom of the Handlers page to save your changes.

4. Activate Message Queue.

   1. Navigate to PeopleTools , and then Integration Broker, and then Service Operations Monitor, and then Administration, and then Queue Status.

   2. Scroll down the page to find the relevant Queue Name (from the Service Operation setup page noted earlier).

   3. Review the queue Status and activate the queue by clicking Run if needed.

Executing the Full Data Publish Utility

Run the Full Data Publish process to synchronize data between your HCM and CS systems.

1. Define Full Data Publish Rules.

   1. Navigate toEnterprise Components , and then Integration Definitions , and then Full Data Publish Rules,and set up the following:

      This example illustrates the fields and controls on the Full Table Publish Rules page for the COUNTRY_FULLSYNC service operation.

      

      Field or Control	Description
      Message Name	Name of the Service Operation.
      Publish Rule ID	Enter a publish rule ID.
      Description	Enter a description of the Publish Rule.
      Status	Set to Active.

   2. Check the Create Message Header and Create Message Trailer check boxes.

   3. Save the page.

2. Execute the Full Data Publish Process.

   1. Navigate to Enterprise Components, and then Integration Definitions, and then Initiate Processes, and set up the following:

      This example illustrates the fields and controls on the Full Data Publish page.

      

      Field or Control	Description
      Run Control ID	Create a new Run Control ID.
      Request ID	Enter a Request ID.
      Process Frequency	Select Always.
      Parameters	Select the existing Service Operation, for example, COUNTRY_FULLSYNC.

   2. Save the page and click Run.

   3. Select the Full Table Data Publish process from the Process Scheduler Request page and verify that the process runs successfully.

      This example illustrates the fields and controls on the Process Scheduler Request page where the Full Table Data Publish process is selected.

      

3. Navigate to PeopleTools, and then Integration Broker, and then Service Operations Monitor, and then Monitoring , and then Asynchronous Services to review the status of the Full Sync messages created by the Full Data Publish process.

   This example illustrates the fields and controls on the Operation Instances page to monitor asynchronous service operations.