WORKFORCE_SYNC Error when Changing Job Effective Date

(Doc ID 2060020.1)

Last updated on MAY 02, 2018

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 9.2 and later
Information in this document applies to any platform.


When changing job data in HCM, the WORKFORCE_SYNC delete process between CRM 9.2 and HCM 9.2 results in the following error:

"Cannot delete this job detail. An assignment needs at least one job detail record. (18076,4027) RB_CDM.RB_CDM_UTILITIES.Assignments.OnExecute Name:DeleteJob PCPC:22704 Statement:350
Called from:RB_EIP.SUBSCRIBE.WorkForceSubscribeAdapter.OnExecute Name:ProcessMsgVersion2 Statement:210
Called from:RB_EIP.SUBSCRIBE.WorkForceSubscribeAdapter.OnExecute Name:HandleWorkForceSubscription Statement:21
Called from:WORKFORCE_SYNC.WorkForceSync.OnExecute Name:OnNotify Statement:7"


1. Create a new person in HCM, create job 2 job rows - hire and data change. This should come over to CRM properly.
2. Change the effdt of the 2 job rows. The above errors are generated out and the change does not come over to CRM.



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