SAP Knowledge Base Article - Public

3048779 - OCI update failed

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...'

8.png

  • 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).

2.png

  • 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'.

4.png

5.png

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.

7.png

  • 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.

2.png

See Also

 2419074 - Manually Updating the OnboardingCandidateInfo Object - Onboarding 1.0

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