ELM 9.X: After WORKFORCE_SYNC Message Subscribed, the Stage Table LM_STG_PRS_ATTRB Record Contains a Blank in field AUDIT_ACTN

(Doc ID 2138886.1)

Last updated on NOVEMBER 01, 2017

Applies to:

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


After WORKFORCE_SYNC message subscribed, the Stage Table LM_STG_PRS_ATTRB record contains a blank in field AUDIT_ACTN.  
Steps to Replicate Issue:
1. Integrate WORKFORCE_SYNC service operation from HCM to ELM.
2. In HCM, Add a new Job row to Employee with a new Position number, which triggers the WORKFORCE_SYNC message.
3. In ELM, WORKFORCE_SYNC message subscribed and populates the PS_LM_STG_PRS_JOB table and PS_LM_STG_PRS_ATT.  However, the table LM_STG_PRS_ATTRB record contains a blank in field AUDIT_ACTN.
4. As a result after the Process Asynchronous Data runs, data loaded into PS_LM_PERSON_JOB table but corresponding row not added to PS_LM_PERSON_ATTRB table.


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