SAP Knowledge Base Article - Public

2976319 - Error "code=bad data type detail=Illegal DateTimeOffset-value" - Integration Center

Symptom

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.

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Cause

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.

Resolution

You can solve this issue by following these steps:

  1. Select the "Detail View" in the integration



  2. Select the field which is receiving the data



  3. Click in the hamburger button and select "More Field Options"


  4. Select the date format as "yyyy-MM-dd"

After this, the issue shouldn't occur anymore.

Keywords

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

Product

SAP SuccessFactors HXM Core all versions