WORKFORCE_SYNC message subscribe. Stage table LM_STG_PRS_ATTRB record contains a blank field. (Doc ID 2202025.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

On:   9.2 version, Integration

ACTUAL BEHAVIOR
---------------
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.

Discrepancy in LM_PERSON_ATTRB and LM_PERSON_JOB.


STEPS
-----------------------
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



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