Setting Up Incremental Synchronization Web Services
PeopleSoft Pay/Bill Management uses the PeopleSoft Integration Broker tool to integrate PeopleSoft Pay/Bill Management tables with PeopleSoft HCM and PeopleSoft Financials (FSCM) application tables. The messages are delivered with a default status of Inactive. You must activate each message before you attempt to publish messages or subscribe to messages between databases.
Note:
You must activate these messages in the HCM and FSCM databases.
To begin using PeopleSoft Integration Broker, you need to enable publishing of several web services in HCM and subscribing to those services in PeopleSoft Pay/Bill Management. For some PeopleSoft systems, the direction of the publish/subscribe rule for web services may be bidirectional or unidirectional; however, in Pay/Bill Management, the model is unidirectional so that data can be synchronized. For a given set of data, only one source for add and one source for update is available. The publish and subscribe rules may also be incremental or full table synchronization for each message.
Note:
The source for publishing departments must be HCM because PeopleSoft Pay/Bill Management requires that the Company and Location fields be populated.
The following tables contain the incremental synchronization web services that update the PeopleSoft Pay/Bill Management, PeopleSoft HCM, and Financials applications every time a user changes data that is relevant to PeopleSoft Pay/Bill Management. These services are published from PeopleSoft Pay/Bill Management or PeopleSoft HCM and subscribe to some or all of the same databases. These are suggested service operations.
Set Up Tables – HCM to FIN
| Service Operation | Queue Name |
|---|---|
|
BUS_UNIT_HR_SYNC |
HR_SETUP |
|
CM_TYPE_SYNC |
PERSON_SETUP |
|
COMPANY_SYNC |
PERSON_SETUP |
|
COMPETENCY_SYNC1 |
PERSON_SETUP |
|
COMPETENCY_SYNC2 |
COMPETENCY |
|
COMPETENCY_SYNC3 |
COMPETENCY |
|
DEPT_SYNC |
ENTERPRISE_SETUP |
|
FREQUENCY_SYNC |
PERSON_SETUP |
|
FO_WC_CO_MOD_ SYNC |
FO_SETUP |
|
FO_WC_CO_STATE_SYNC |
FO_SETUP |
|
FO_WC_STATE_ SYNC |
FO_SETUP |
|
HOLIDAY_DATE_SYNC |
PERSON_SETUP |
|
JOBCODE_ SYNC |
PERSON_SETUP |
|
LOCATION_SYNC |
ENTERPRISE_SETUP |
|
RATING_MODEL_SYNC |
RATING_MODEL |
|
NID_TYPE_SYNC |
PERSON_SETUP |
|
PAYGROUP_SYNC |
PAYGROUP_SETUP |
|
REGULATORY_REGION_SYNC |
PERSON_SETUP |
|
TIME_REPORTING_CODE_SYNC |
TIME_AND_LABOR_SETUP |
|
SCHOOL_SYNC |
PERSON_SETUP |
Set Up Tables – FIN to HCM
| Service Operation | Queue Name |
|---|---|
|
ACCOUNT_CHARTFIELD_SYNC |
GL_SETUP |
|
FO_RATE_ELEM_SYNC |
FO_SETUP |
|
FO_MC_TYPE_SYNC |
FO_SETUP |
Set Up Tables – Either Way
| Service Operation | Queue Name |
|---|---|
|
COUNTRY_SYNC Note: This is delivered as system data. Although doing so is possible, you probably will not need to synchronize this message because you are unlikely to make changes to the Country Table. |
ENTERPRISE_SETUP |
|
CURR_QUOTE_MTHD_SYNC |
MARKET_RATES |
|
CURRENCY_SYNC Note: This is delivered as system data. Although doing so is possible, you probably will not need to synchronize this message because you are unlikely to make changes to the Currency Codes table. |
ENTERPRISE_SETUP |
|
MARKET_RATE_LOAD |
MARKET_RATE_LOAD |
|
MARKET_RATE_DEFN_SYNC |
MARKET_RATES |
|
MARKET_RATE_INDEX_SYNC |
MARKET_RATES |
|
MARKET_RATE_SYNC |
MARKET_RATES |
|
MARKET_RATE_TYPE_SYNC |
MARKET_RATES |
|
STATE_SYNC |
ENTERPRISE_SETUP |
Transactional Tables – HCM to FIN
| Service Operation | Queue Name |
|---|---|
|
FO_ASGN_CONFIRM |
FO_ASSIGNMENTS |
|
FO_EMPL_DATA_SYNC |
FO_SETUP |
|
PERSON_ACCOMP_SYNC |
PERSON_DATA |
|
PERSON_BASIC_SYNC |
PERSON_DATA |
|
PERSON_COMPETENCY_SYNC |
PERSON_DATA |
|
WORKFORCE_SYNC |
PERSON_DATA |
|
ACTUAL_TIME_ADD |
ACTUAL_TIME |
|
ACTUAL_TIME_BATCH_ADD |
ACTUAL_TIME |
|
ESTIMATED_TIME_BATCH_ADD |
ESTIMATED_TIME |
Transactional Tables – FIN to HCM
| Service Operation | Queue Name |
|---|---|
|
CUSTOMER_SYNC |
CUSTOMER |
|
FO_APP_HIRE |
FO_APP_HIRE |
|
FO_ASGN_CREATE |
FO_ASSIGNMENTS |
|
FO_ASGN_RATES_SYNC |
FO_ASSIGNMENTS |
|
FO_ASGN_UPD |
FO_ASSIGNMENTS |
|
PROJECT_ACTIVITY_SYNC |
PROJECTS_SETUP |
|
PROJECT_ACTIVITY_TEAM_SYNC |
PROJECTS_SETUP |
|
PROJECT_SYNC |
PROJECTS_SETUP |
|
PROJECT_TEAM_SYNC |
PROJECTS_SETUP |
|
FO_MC_ART_BATCH |
FO_MASS_CHANGES |
After you activate these service operations, every subsequent change to data in any of the records associated with these messages triggers the publication and subscription of the new or deleted data. The result is that Pay/Bill Management reflects the change within a few seconds.
Note:
Depending upon the release versions being integrated, multiple versions of a message may be in the database. The default version is the recommended version for use. If the default version in the source database does not match the version in the target database, then either a relationship or transformation needs to be set up in the source database.