Understanding the ELM Full Sync Integration Guided Process

PeopleSoft Enterprise Learning Management (ELM) integrates with other applications to enable the sharing of person and organization data. You can use the integration points that are delivered with PeopleSoft ELM to import data for internal learners and departments from PeopleSoft Human Capital Management (HCM). PeopleSoft HCM remains the system of record for all of the imported data. This data can be viewed, but not changed in PeopleSoft ELM.

Integration points are divided into two distinct categories: full sync and incremental sync. PeopleSoft ELM uses full sync integration points during system implementation to import all data for a given set of HCM tables. After all full sync points are processed, you activate incremental sync integration points to ensure that additions, modifications, and deletions of data in PeopleSoft HCM are imported into PeopleSoft ELM.

To manage integration between PeopleSoft HCM and ELM, you use Integration Broker technology to configure, activate, and monitor integration that synchronizes a given set of HCM tables. In addition, you use Enterprise Components integration definitions and processes to configure full sync data rules and to initiate the full sync integration points.

When you run a full or incremental integration point, the system loads the imported data either directly into the PeopleSoft ELM tables or sends it to a staging table for validation before it is loaded. The process depends on the type of data that is being imported. Because of data dependencies, some integration points must be run in a specific order. Generally, data that is updated frequently or for which there is a high volume, such as learner and workforce data, goes to a staging table first.

To improve and simplify the processing of full sync integration points between PeopleSoft HCM and ELM, Oracle provides the ELM Full Sync Integration Guided Process. This feature enables users to initiate and monitor full sync integration points between PeopleSoft HCM and PeopleSoft ELM, including the process that validates and loads ELM data from a staging table.

Users can initiate and monitor the following full sync integration points:

• Foundation Data

  • COUNTRY_FULLSYNC

  • CURRENCY_FULLSYNC

  • STATE_FULLSYNC

  • SETID_INITIALIZE

• Organization Data

  • DEPT_FULLSYNC

  • COMPANY_FULLSYNC

  • POI_TYPE_TBL_FULLSYNC

  • BUS_UNIT_HR_FULLSYNC

  • JOBCODE_FULLSYNC

• Position Data - POSITION_FULLSYNC

• Person Data

  • PERSON_BASIC_FULLSYNC

  • WORKFORCE_FULLSYNC

• Employee Photo Data - USER_PHOTO_FULLSYNC

To process this integration, users need to configure Integration Broker for both their PeopleSoft HCM and PeopleSoft ELM environments so that they can communicate. The easiest way to do this is with the Integration Network Workcenter delivered with PeopleTools.

For more information on the Integration Network Workcenter, see the product documentation for PeopleTools: Integration Broker Administration.