Employee Import failing with error in Job Details - "Date/time value out of range"
SAP SuccessFactors HCM Suite
Reproducing the Issue
When creating a UDF file to import new users or update existing users
- In the Hire Date or Exit Date column
- Add the hire date or exit date as normal but also add a time stamp of hh:mm:ss
- Import the file - note it will fail with the error - Date/time value out of range
The system only processes the date and not the time.
Issue only started after 1911 release for customers who prviously had a time in the hire date/ exit date column
The expected behavior for hiredate/exitdate is that only date can be recorded into system DB. System only process date not time.
For example, when the date being processed, it will catch the 'MM/DD/YYYY' only and skip later content like 'HH,MM,SS'
To improve and support more locale date format, we add some logic to detect/prevent space issue for later content. E.g, let "DD/MM/YYYY " equal to "DD/MM/YYYY". However, if customer add some error content after date, it will cause date out of range.
Remove the time from the hire date and/or exit date column in the import file
- This will need to be done by the product/system which is populating and placing the import file on the SFTP server, for scheduled import jobs
Although hiredate/exitdate only support date without time and skip later content, we also think it is necessary to extend tolerance on these fields. B2005 will fix and prevent this issue. The workaround could be let customer remove time on hiredate/exitdate and re-import again.
Employee Import, Date/time value out of range, UDF , KBA , LOD-SF-PLT-UIM , Employee Import Issues , Problem