Incremental Synchronization Messages

PeopleSoft Resource Management utilizes application messages to integrate PeopleSoft Resource Management tables with PeopleSoft HCM application tables. The messages are delivered with a default status of inactive. You must activate each message before attempting to publish messages or subscribe to messages between databases.

The direction of the publish and subscribe rule for each message may be bidirectional or unidirectional. The publish and subscribe rule may also be incremental or full table synchronization for each message.

Bidirectional, Incremental Messages—General Data Synchronization

When you use PeopleSoft HCM with PeopleSoft Resource Management, you install two databases, HCM and Financials, and synchronize fundamental, general data records across the two databases. If you update the records in both databases and then make a change in PeopleSoft Resource Management, the change is published back to PeopleSoft HCM, and vice versa. This type of data synchronization is called bidirectional incremental messaging.

The following list shows the bidirectional, incremental synchronization messages to activate in the HCM and Financials databases. You must activate and execute the messages in this list.

Note:

Oracle recommends that you do not implement the messages as bidirectional. If you set up the incremental messages as bidirectional, you may have data validation issues if you update the same record in each database at the same time. It is better to set up one database as the master so that all updates can occur in one place. The messages can then be set up as unidirectional and published to the subscribing database:

• DEPT_SYNC

• LOCATION_SYNC

Unidirectional, Incremental Messages - PeopleSoft Resource Management-Specific Synchronization

The following list contains the incremental synchronization messages that update the PeopleSoft Resource Management application every time a user changes PeopleSoft HCM data that is relevant to Resource Management. These messages are published from PeopleSoft HCM to PeopleSoft Resource Management, which means that HCM is always the source of data. Do not modify data in the Financials database that is transmitted through these messages from PeopleSoft HCM.

Once you activate these messages in PeopleSoft HCM and PeopleSoft Resource Management, every subsequent change to HCM data in any of the records that are associated with these messages triggers the publication and subscription of the new, modified, or deleted data. The result is that PeopleSoft Resource Management reflects the change within a few seconds.

This is a list of the unidirectional, incremental synchronization messages that you must activate in the HCM and Financials databases:

• BUS_UNIT_HR_SYNC

• CLUSTER_ACCOMP_SYNC

• CLUSTER_COMP_SYNC

• CM_TYPE_SYNC

• COMPETENCY_SYNC1

• COMPETENCY_SYNC2

• COMPETENCY_SYNC3

• FREQUENCY_SYNC

• HOLIDAY_DATE_SYNC

• JOBCODE_SYNC

• JOB_FAMILY_SYNC

• PERSON_ACCOMP_SYNC

• PERSON_COMPETENCY_SYNC

• PERSON_BASIC_SYNC

• PERSON_VISA_CITIZEN_SYNC

• RATING_MODEL_SYNC

• ROLE_ACCOMP_SYNC

• ROLE_CLUSTER_SYNC

• ROLE_COMP_SYNC

• ROLE_SYNC

• SCHOOL_SYNC

• WORKFORCE_SYNC