Loading Business Attribute Tables

Loading Business Attributes from PeopleSoft HCM

To load business attribute data from PeopleSoft HCM to PeopleSoft Interaction Hub:

1. Using Application Designer, login to the PeopleSoft HCM database, copy the record definition of the business attribute table and any defined subrecords into a project, then export the project to a file.

   For example, for the Department business attribute, you would export the record PS_DEPT_TBL and its Related Language record.

2. Using Application Designer, login to the PeopleSoft Interaction Hub database, import the project from the previous step and build the record definition.

   Note: Steps 1 and 2 have been completed for these sample delivered PeopleSoft HCM 9.1 records: BU_UNIT_TBL_HR, COMPANY_TBL, DEPT_TBL, LOCATION_TBL. If you are using a different record version due to a different PeopleSoft HCM release or patch level, you will need to export the record definition from PeopleSoft HCM and import that record definition into the PeopleSoft Interaction Hub database.

3. For the initial data load, populate the tables using either a DMS script or the PeopleSoft Publish utility.

Sample Export DMS Script

This is an example of a DMS script to export company data from PeopleSoft HCM.

set log c:\temp\company_exp.log;
set output c:\temp\company.dat;
export COMPANY_TBL;
export COMPNY_TBL_LANG;

Sample Import DMS Script

This is an example of a DMS script to import the company data that was exported from PeopleSoft HCM into PeopleSoft Interaction Hub.

set log c:\temp\company_imp.log;
set UPDATE_DUPS;
set input c:\temp\company.dat;
import *;

Configuring Integration Broker in PeopleSoft HCM

To configure Integration Broker in PeopleSoft HCM:

1. Navigate to PeopleTools > Integration Broker > Integration Setup > Service and select BUS_UNIT_HR_FULLSYNC.

2. Select the default service operation and set it to active.

3. Activate the routing to publish to the PeopleSoft Interaction Hub node. If no routing exists, add one.

Configuring Integration Broker in PeopleSoft Interaction Hub

To configure Integration Broker in PeopleSoft Interaction Hub:

1. Navigate to PeopleTools > Integration Broker > Integration Setup > Service.

2. Select and activate service BUS_UNIT_HR_FULLSYNC.

   If none exists, add a new service.

3. Select and activate the default service operation.

   • If this is a new service, add an asynchronous one-way service operation BUS_UNIT_HR_FULLSYNC.VERSION_1 using the corresponding message for the service.

   • If no message exists, add a rowset-based message called BUS_UNIT_HR_FULLSYNC, version VERSION_1 and add record definition BUS_UNIT_TBL_HR to the root.

   • If the service operation already exists for the Resource Finder feature and it uses a nonrowset-based message, continue to next step. A new handler will be created downstream to update the business attribute table.

   • Set the Queue name to match the one for the service operation in HR, for example, HR_SETUP.

4. Verify that the service operation permission is set. If none exists, set the service operation security to use permission list PAPP9000.

5. Activate handler. Depending on whether a handler already exists or not, proceed as follows:

   • If no handler exists, add an application package/class in Application Designer using the sample handler PeopleCode provided in “Sample Business Attributes Service Operation Handler PeopleCode.” The application package is usually the same name as the service.

     See Case 1: A Nonrowset-Based Message Does Not Exist for the Service Operation in PeopleSoft Interaction Hub.

     In PIA, add a handler to the service operation with the new application class.

   • If a handler already exists for the Resource Finder feature, in Application Designer add a new application class to the existing application package using the sample handler PeopleCode in “Sample Business Attributes Service Operation Handler PeopleCode.”

     See Case 2: A Nonrowset-Based Message Exists in PeopleSoft Interaction Hub for the Same-Name Service Operation in PeopleSoft HCM.

     In PIA, add a new handler to the service operation with the newly added application class.

6. Activate the routing.

   If none exists, generate an Any-to-Local routing on the General tab of the Service Operation.

7. Select the Routing Parameters tab and verify the EXTERNAL alias matches the expected incoming message name and version (BUS_UNIT_HR_FULLSYNC.VERSION_1 in this example).

Running the PeopleSoft Publish Utility in PeopleSoft HCM

To run the PeopleSoft Publish utility, complete these steps in PeopleSoft HCM:

1. Navigate to Enterprise Components > Integration Definitions > Full Data Publish Rules.

2. Select Service Operation BUS_UNIT_HR_FULLSYNC and verify that it is active. Select Create Message Header and Create Message Trailer if they are not already selected.

3. Navigate to Enterprise Components > Integration Definitions > Initiate Processes > Full Data Publish.

4. Add a run control or use an existing one.

5. Set Service Operation to BUS_UNIT_HR_FULLSYNC and click Run.

6. Select the Full Table Data Publish process and click OK.

7. Verify process goes to Success.

8. Navigate to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services.

9. Select the Publication Contracts page and verify transaction(s) are successful.

Verifying the Results in the PeopleSoft Interaction Hub Database

To verify the results, in PeopleSoft Interaction Hub complete these steps:

1. Navigate to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services.

2. Select the Subscription Contracts page and verify transaction(s) are successful.

3. Verify the User Profile has been populated by querying the BUS_UNIT_TBL_HR table.