CRM 9: WRKR_JOB_SEQ is not Incrementing in HRMS to CRM incremental sync (Doc ID 1372573.1)

Last updated on MAY 23, 2017

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 2-Jun-2014***

Symptoms

CRM 9.0 integrated with HRMS 9.0:

When an employee has two job instances 0, 1 when job data is added and modified or deleted, the wrkr_job_seq is taken from maximum wrkr_asgn_seq regardless whether the new row of the job is in the lower wrkr_asgn_seq.
See the WorkerJobSeq.doc file attached for more details on it.

The worker details in CRM are not retrieved correctly.

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