You have created a Integration Center job that sends data from a SuccessFactors entity to another SuccessFactors entity. You have then mapped a DateTime type field from the source entity to a DateTimeOffset type field in the destination entity. When running the integration, you see the error below:
UPSERT failed for the row with key: . Reason: Property:[dueDate] parse failed: code=bad data type detail=Illegal DateTimeOffset-value :2000-10-10
If you copy the preview payload from Integration Center and send it via OData API, no issue occurs.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
- SAP SuccessFactors HXM Suite
- Integration Center
Reproducing the Issue
- Mapping a DateTime type field (dateOfBirth from User, for example) into a DateTimeOffset field (dueDate from TodoEntryV2)
- The Preview shows a proper payload in the DateTimeOffset field:
- The error occurs when you run the integration.
This is known issue currently being verified by Integration Center engineering team. The fix for the issue is currently planned to be applied in 1H 2021 release.
More info about the SF Release and its dates can be checked in this page of the SF Community portal.
integration center, date time offset, date time, odata api, upsert fail, failed, error, sf to sf, successfactors to successfactors, inbound, ic , KBA , LOD-SF-INT-INC , Integration Center , Known Error