My Oracle Support Banner

WORKFORCE_SYNC Error when Changing Job Effective Date (Doc ID 2060020.1)

Last updated on NOVEMBER 02, 2020

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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.