Integrating Setup 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

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

   1. Navigate to select PeopleTools , then select Security , then select Permissions & Roles , then select 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 and add access to the relevant Service Operation(s) listed on the Web Service Permissions secondary page by selecting the Full Access option for the Access column.

      Image: Web Services page-Permission List

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

      

      Image: Web Services Permissions page

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

      

2. Activate Service Operation(s) and Create Routing(s):

   1. Navigate to select PeopleTools, then select Integration Broker, then select Integration Setup, then select 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 will need to verify that the Queue is in Running status later.

   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.

      Image: General page

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

      

      Image: Routings page

      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. Click the Save button at the bottom of the Routings Definition page to 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.

       Image: Routing Definitions page

       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 select PeopleTools, then select Integration Broker , then select Service Operations Monitor, then select Administration, then select Queue Status

   2. Scroll down the page until you 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. The queue status should be set to Running before leaving this page.

      Image: Queue Status page

      This example illustrates a partial sample of the Queue Status page.

      

Target Database Configuration Tasks

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

   1. Navigate to select PeopleTools, then select Security, then select Permissions & Roles, then select 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.

      Image: Web Services page

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

      

      Image: Web Service Permissions 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 select PeopleTools, then select Integration Broker, then select Integration Setup, then select 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 will need to verify that the Queue is in the Running status later.

      Image: General page

      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.

       Image: Routings page

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

       

       Image: Routing Definitions page

       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.

   2. Enter a Handler Name as shown below if one does not exist.

   3. Set Handler Name = For example, “BusUnitHRFullSync”. See the Full Sync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.

   4. Set Type = OnNotify.

   5. Set Implementation =Application Class.

   6. Set Status = Active.

   7. Select the Details link.

   8. Set 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.

   9. Set Path = “:”

   10. Set Class ID = For example, CountryFullSync. See the FullSync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.

   11. Set Method = OnNotify.

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

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

       Image: Handlers page

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

       

       Image: Handler Details page

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

       

4. Activate Message Queue.

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

   2. Scroll down the page until you 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 the data between your HCM and CS systems.

1. Define Full Data Publish Rules.

   1. Navigate to select Enterprise Components , then select Integration Definitions , then select Full Data Publish Rules.

   2. Enter the Message Name of the Service Operation.

   3. Enter a Publish Rule ID, a Description, and set the Status field to Active.

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

   5. Save the page.

      Image: Full Table Publish Rules page

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

      

2. Execute the Full Data Publish Process.

   1. Navigate to select Enterprise Components, then select Integration Definitions, then select Initiate Processes.

   2. Create a new Run Control ID as shown below.

   3. Enter a Request ID.

   4. Select Always for the Process Frequency.

   5. Enter the Message Name from the Full Table Publish Rule created earlier (example: COUNTRY_FULLSYNC).

   6. Save the page and click Run.

   7. Select the Full Table Data Publish process from the Process Scheduler Request page.

   8. Verify the process ran successfully.

      Image: Full Data Publish page

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

      

      Image: Process Scheduler Request

      This example illustrates the fields and controls on the Process Scheduler Request page to run the Full Table Data Publish process.

      

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

   Image: Operation Instances page

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

   

Service Operations and Handlers

The following table identifies the FullSync and Sync Service Operations, and subscription handlers that you should use to configure your CS – HCM setup data integrations. Activate and configure all integrations that you have identified according to your business requirements and implementation plans.

See also:

PeopleTools: Integration Broker Testing Utilities and Tools

Implementing Portal Navigation aggregation for CS and HCM Integration on My Oracle Support.