ELM 9.X: After WORKFORCE_SYNC Message Subscribed, the Stage Table LM_STG_PRS_ATTRB Record Contains a Blank in field AUDIT_ACTN
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