WORKFORCE_SYNC message subscribe. Stage table LM_STG_PRS_ATTRB record contains a blank field.

(Doc ID 2202025.1)

Last updated on FEBRUARY 14, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.


On:   9.2 version, Integration

WORKFORCE_SYNC Message Subscribe - the Stage Table LM_STG_PRS_ATTRB record contains a blank in field. 

The issue with the Workforce Sync message trying to send data from HCM to ELM.

Audit action for the LM_STG_PRS_ATTRB is set to blank and not consistent. When we the change Job code on the job data, the audit action (AUDIT_ACTN) is set to C where as when the Department ID was changed, the audit action is set to blank.

Running the Process Asynchronous Data, the data is loaded from PS_LM_STG_PRS_JOB but its not getting loaded from PS_LM_STG_PRS_ATT.


The issue can be reproduced at will with the following steps:

1. Login as HR admin

2. Update jobcode for employee

3. Verify the data moved with audit action


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