3370017 - Error "bad data type detail=Illegal DateTimeOffset-value" when using default values (<NOW>, <TODAY>, ...) in Integration Center

When mapping a default value such as <NOW> or <TODAY> to a field of type DateTimeOffset and performing an insert of data in such field, the error below occurs:

"bad data type detail=Illegal DateTimeOffset-value: Tue Aug 22 09:51:41 UTC 2023. The row will not be processed for subsequent entities"

This issue does not occur when you run the integration in the preview (Run Preview Records feature), only when it is effectively executed.

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

The datatype is being dynamically set as DateTime at runtime, even though the field type is DateTimeOffset.

This is a known issue which is currently being investigated by the Integration Center engineering team.

It is currently planned to be fixed in 2H 2023 Release.

INT-17068, KI2305, DateTime, DateTimeOffset, NOW, TODAY, time, bad data type , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Known Error