Symptom
When changing a Contingent Workforce Work Order end date, the system blocks the update with the message: "You can’t set the work order end date to [date] as there is a regular employment from [date] to 12/31/9999. Adjust the date to avoid any overlap."
Environment
SAP SuccessFactors Employee Central - Contingent Workforce
Reproducing the Issue
- Open a Contingent Worker’s Work Order.
- Change the Work Order End Date to an earlier date.
- Save the change.
- Observe the error: "You can’t set the work order end date to [date] as there is a regular employment from [date] to 12/31/9999. Adjust the date to avoid any overlap."
Cause
A soft‑purged regular employment linked to the same person still exists with an open end date (12/31/9999). The overlap validation detects this employment and prevents saving the Work Order end date change.
Resolution
Identify all employments linked to the person using Data Inspector Tool:
Steps to follow:
- Make note of Person ID External
- Go to Data Inspector Tool
- Select Table_PER_PERSON filtered by Person ID External to obtain the PERSON_ID.
- Select Table_EMP_EMPLOYMENT_INFO filtered by PERSON_ID to list all associated user ids/employments.
- Select Table_USERS_SYSINFO for each user id to verify the status (active-t, inactive-f, soft‑purged-x).
- If a soft‑purged regular employment with an open end date exists, plan to permanently purge that employment (hard purge).
- Perform the permanent user deletion by following: 2392076 - Permanently deleting users (Hard Purge).
- After the hard purge completes, retry updating the Work Order end date; the change should save successfully.
See Also
Keywords
contingent workforce, work order, end date, overlap, regular employment, soft purged, hard purge, data inspector, per_person, emp_employment_info, users_sysinfo, overlapping employment, 12/31/9999, error message, overlap validation,""You can’t set the work order end date to [date] as there is a regular employment from [date] to 12/31/9999. Adjust the date to avoid any overlap.",""You can’t set the work order end date to"," there is a regular employment from",."Adjust the date to avoid any overlap." , KBA , LOD-SF-EC-CWF , Contingent Workforce , How To
SAP Knowledge Base Article - Public