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

Resolution

  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. Select the action to perform (Import Data)
  4. Select Generic Object (OnboardingCandidateInfo) and choose the CSV file in your source folder
  5. Confirm other attributes
  6. Click Validate or Import button

Keywords

sf, success factors, OCI, ONB, OBD, onboarding, Import and Export, Manage Data, Failure, Incorrect Format, OnboardingCandidateInfo, date format, yyyy-MM-dd, Import failed, Monitor Jobs, MDF Import failed , KBA , LOD-SF-OBD-INT , Integrations with Onboarding , LOD-SF-OBD-REP , Reporting & Analytics, Data Imports & Exports , Problem

Product

SAP SuccessFactors Onboarding