Symptom
You uploaded the file with column "Delete Record" to delete some employees record but it is not working.
Environment
SAP SuccessFactors HXM Cloud
Variable Pay
Reproducing the Issue
- Go to Compensation Home
- Select your Variable Pay program
- Plan Setup > Manage Users > Edit Employee History
- click on Import Data
- Upload the file with column "Delete Record" as shown below.
The records got imported with no errors but also didn't delete the desired record.
Cause
This is because TRUE is not a valid value for deleting records
Resolution
Please use the value "Y" or 'y' for deleteRecord column instead of "TRUE". Then the record will be deleted.
Note: if you used Y for deleteRecord but it didn't update (and not errors were generated), then likely you are using an older version of an employee history record export and a more recent import the system IDs. Always make changes from a fresh export of employee history records, so that you're using the most updated system IDs.
Keywords
KBA , LOD-SF-CMP-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-CMP-VAR , Compensation Integration Issues with Variable Pay , Problem