HCM to ELM Integration: LM_PERSON_ATTRB Data is Deleted After Modifying Data in HCM (Doc ID 2106054.1)

Last updated on JUNE 21, 2017

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

In ELM the Record LM_PERSON_ATTRB data gets deleted when we modify the data in HCM and run the Process Asynchronous Data.

When modifying data in HCM for an employee multiple times before Asynchronous process in ELM is run, data in LM_PERSON_ATTRB gets deleted.
As a result, LM_PERSON_JOB and LM_PERSON_ATTRB gets out of sync.
This impact learners who have just been hired or old employees whose job data has been modified multiple times before asynchronous process run in ELM.

STEPS TO REPLICATE
--------------------
- Verify the data before modification in HCM and ELM instance :
- HCM : The Employee ID (KU0097) had two 2 row with the Eff Date (8-Sep-2015 and 15-Nov-1997) in the Record PS_JOB.
- ELM  : The Learner ID (437) has 2 row with the Eff Date (8-Sep-2015 and 15-Nov-1997) for both the records LM_PERSON_ATTRB and LM_PERSON_JOB.

- Now, Login to HCM
- Navigate to Main Menu > Workforce Administration > Job Information > Job Data.
- Search for EMPLID. (KU0097) (Note: Make sure that Correct History is checked)
- Modify any non-key field value in Job component then click save.
- Modified data in HCM will be synced in ELM.
- Review the records (LM_STG_PRS_ATT and LM_STG_PRS_JOB) in the ELM side.
- Both contains a row which was modified in the HCM side.
- Now, Modify the key field values in Job and click save. EX: modify Effective Date from 09/08/2015 to 09/09/2015.
- Review the records (LM_STG_PRS_ATT and LM_STG_PRS_JOB) in the ELM side.
- one row was added in the records LM_STG_PRS_ATT and  two row was added in the record LM_STG_PRS_JOB.
- Now Revert back the Key field value changes. ie, Effective Date to its original value (from 09/09/2015 to 09/08/2015) and hit save.
- Review the records (LM_STG_PRS_ATT and LM_STG_PRS_JOB) in the ELM side.  
- one row was added in the records LM_STG_PRS_ATT and  two row was added in the record LM_STG_PRS_JOB.

- Now, Login to ELM.
- Navigate to Main Menu > Setup ELM > Process Asynchronous Data.
- Enter Run control ID and Run the program and validate that Asynchronous process run to success.
- Validate the Data in LM_PERSON_ATTRB and LM_PERSON_JOB in ELM.
- In the record LM_PERSON_ATTRB for the above leaner (437) the row with EFFDT = ‘09/08/2015’ in LM_PERSON_ATTRB is deleted.
- in the record LM_PERSON_JOB  for the above leaner (437) the row with EFFDT = ‘09/08/2015’ is there which is correct.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms