You have built an integration of type SuccessFactors to SuccessFactors and the error below occurs when a date value is upserted from a DateTime field into a DateTimeOffset field:
<entityName>: UPSERT failed for the row with key: . Reason: Property:<fieldName> parse failed: code=bad data type detail=Illegal DateTimeOffset-value :<dateValue>. The row will not be processed for subsequent entities
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
This issue occurs because Integration Center is not being able to parse the DateTime type into DateTimeOffset. However, same issue doesn't occur on OData API because the API is able to parse such type of data.
You can solve this issue by following these steps:
- Select the "Detail View" in the integration
- Select the field which is receiving the data
- Click in the hamburger button and select "More Field Options"
- Select the date format as "yyyy-MM-dd"
After this, the issue shouldn't occur anymore.
ic, date format, field, date-type, type, integration center, successfactors, sf, success factors, api, odata, datetimeoffset, datetime, convert, transform, parse, source, destination , KBA , LOD-SF-INT-INC , Integration Center , Problem