Symptom
Importing the OnboardingCandidateInfo fails with the following error in Monitor Job Status: Date format is invalid. Please provide a date with format yyyy-MM-dd.
Environment
SAP SuccessFactors Onboarding 1.0
Reproducing the Issue
- Navigate to SAP SuccessFactors HXM > Admin Center > Import and Export Data
- Select the action to perform (Import Data)
- Select Generic Object (OnboardingCandidateInfo) and choose the CSV file in your source folder
- Confirm other attributes
- Click Validate or Import button
- Navigate back to Admin Center > Import and Export Data
- Download the validated upload and check the last column where the validation error shows
Cause
Date format not valid
Resolution
In order to solve this, please ensure the import has the correct date format:
- Navigate to SAP SuccessFactors HXM > Admin Center > Import and Export Data
- Change the file's Hired Date with following format: yyyy-MM-dd
- Change the file´s readyToHireDate with following format: MM/dd/yyyy
- Select the action to perform (Import Data)
- Select Generic Object (OnboardingCandidateInfo) and choose the CSV file in your source folder
- Confirm other attributes
- Click Validate or Import button
Keywords
sf, success factors, OCI, ONB, OBD, onboarding, Import, Export, Manage, Data, Failure, Incorrect, Format, OnboardingCandidateInfo, date, yyyy-MM-dd, MM/dd/yyyy, failed, Monitor, Jobs, MDF , KBA , LOD-SF-OBD-INT , Integrations with Onboarding , LOD-SF-OBD-REP , Reporting & Analytics, Data Imports & Exports , Problem