SAP Knowledge Base Article - Public

2694367 - OnboardingCandidateInfo Import Fails Because of an Invalid Date Format - Onboarding 1.0

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

  1. Navigate to SAP SuccessFactors HXM > Admin Center > Import and Export Data
  2. Select the action to perform (Import Data)
  3. Select Generic Object (OnboardingCandidateInfo) and choose the CSV file in your source folder
  4. Confirm other attributes
  5. Click Validate or Import button
  6. Navigate back to Admin Center > Import and Export Data
  7. 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:

  1. Navigate to SAP SuccessFactors HXM > Admin Center > Import and Export Data
  2. Change the file's Hired Date with following format: yyyy-MM-dd
  3. Change the file´s readyToHireDate with following format: MM/dd/yyyy
  4. Select the action to perform (Import Data)
  5. Select Generic Object (OnboardingCandidateInfo) and choose the CSV file in your source folder
  6. Confirm other attributes
  7. 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

Product

SAP SuccessFactors Onboarding