My Oracle Support Banner

ELM 9.X: When EFFDT is Modifed on Multiple Eff_Seq Rows in HCM,The Corresponding Row Deleted in PS_LM_PERSON_ATTRB Record in ELM (Doc ID 1062843.1)

Last updated on NOVEMBER 26, 2021

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.


When EFFDT is changed on any job row that has multiple Effective Sequence rows in HCM, corresponding EFFDT row is getting deleted from PS_LM_PERSON_ATTRB record in ELM.

WORKFORCE_SYNC transformation that is used for integration between HCM 8.9 and ELM 9 maps LM_HIRE_DT to ORIG_HIRE_DT of PER_ORG_INST record. Since HCM 8.9 publishes  WORKFORCE_SYNC with no transactional data for PER_ORG_INST in case of job data updates for an existent employment instance such as salary or position data changes,  LM_HIRE_DT is nulled out as a result of the transformation.

Replication Steps:

1) Login in HRMS
2) Add multiple effective Sequence rows on same effdt.
3) Click on correction mode
4) Select and modify the effdt of one of the employee rows
5) Verify the rows exist in LM_PERSON_ATTRB record in ELM


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.