Symptom
When you make some changes for the OCI and import it into the system, you find that the data has not been updated successfully.
Environment
SAP SF Onboarding 1.0
Reproducing the Issue
- Export OCI via 'Import and Export Data'.
- Change data in OCI (For example, remove 'UserID')
- Then import OCI via 'Import and Export Data', get message 'Your file has been uploaded to the server successfully, and...'
- But if you check this candidate's OCI in Manage Data, data isn't updated successfully. (UserID still exists)
- Then navigate to Monitor Job -> Click on 'download status' of the job submitted just now (Job type: MDF Data Import).
- Open the csv. file and check the last column, you find the error message 'readyToHireDate: yyyy-MM-dd is not a valid date value' or 'Date format is invalid. Please provide a date with format yyyy-MM-dd'.
Cause
- 'Hired Date' should with following format: yyyy-MM-dd
- 'ReadyToHireDate' should with following format: mm/dd/yyyy.
Resolution
Note: Use Notepad++ or Windows Notepad when making changes to values. As MS Excel may change dates into the format used by your PC (Windows or Apple).
- Open the 'OnboardingCandidateInfo.csv' file by using Notepad++ or Windows Notepad, check if 'Hired Date' and 'ReadyToHireDate' are in correct date format.
- Then import 'OnboardingCandidateInfo.csv' again into the system.
- Goto Monitor Job -> Click on 'download status' of the job submitted just now (Job type: MDF Data Import). If the update is successful, it should be like the following screenshot.
See Also
Keywords
OnboardingCandidateInfo, OCI, import and export, date format. Onboarding 1.O, OBD, manage data, SAP SuccessFactors onboarding. , KBA , LOD-SF-OBD , Onboarding , How To
Product
SAP SuccessFactors Onboarding all versions
SAP Knowledge Base Article - Public