Symptom
When making a job information change or when last workflow approver is trying to approve workflow request following error is getting triggered:
"Your workflow approval request cannot be completed as there is already data in the system with the same external code and effective date".
Environment
- SAP SuccessFactors Employee Central
- Position Management
Reproducing the Issue
- Try to make two changes to the position object on the same effective date;
- Receive the error.
Cause
If you try to make two changes to the position object on the same effective date, since you have the Job Info to position Sync active in position management, you will receive the error, because the object doesn't allow for multiple events for the same user on the same effective date.
Resolution
Based on the way the system works and the fact that we have a Job Info to Position Sync as well as a Position to Job Info Sync, the system is unable to have 2 single records for the same effective date for the same Position object.
So is an expected behavior to receive this error because this is not supported.
You are not able to make 2 changes to the position object on the same effective date, since you have the Job Info to position Sync active in position management.
It's not possible to have multiple changes because it's literally one row in the database for each change, so two effective changes for the same date, for the same object is not possible, because one will overwrite the currently active record.
Keywords
approver , error , position sync , employee central , EC , job2pos, Your workflow approval request cannot be completed as there is already data in the system with the same external code and effective date, job to position sync, , KBA , LOD-SF-EC-POS-JTP , Job Information to Position Sync , LOD-SF-EC-JOB , Job Information , LOD-SF-EC-WFL , Workflows - Configuration, Tools, Objects & Rules , Problem