SAP Knowledge Base Article - Public

3708341 - MDI Integration Error - Illegal DateTimeOffset format: . Please follow the standard DateTimeOffset format: datetimeoffset'yyyy-mm-ddThh:mm:ss"+"|"-"hh:mm' or datetimeoffset'yyyy-mm-ddThh:mm:ssZ' (UTC timezone)

Symptom

Error while running MDI Integration: "Illegal DateTimeOffset format: . Please follow the standard DateTimeOffset format: datetimeoffset'yyyy-mm-ddThh:mm:ss"+"|"-"hh:mm' or datetimeoffset'yyyy-mm-ddThh:mm:ssZ' (UTC timezone)."

Environment

  • SAP S/4HANA Public Cloud
  • SAP SuccessFactors HCM Suite
  • SAP Master Data Integration

Cause

The issue arises due to incorrect configuration of Time-based filters in the MDI interface settings. The "Modified Since Query Mode" field was incorrectly set, leading to improper handling of the "Last Run Time" variable.

Resolution

  1. Remove the value from the "Modified Since Query Mode" field and set it to "None". Even though this is not set, only modified records will be replicated (based on the "Last Run Time" value set).
  2. Enable the "Server Side Pagination" feature in the Destination Settings of the Business Scenario.
  3. Test the configuration by running the interface and verify that only modified records since the last run time are replicated.

Keywords

MDI, SAP SuccessFactors, S/4HANA Public Cloud, replication, time-based filters, Last Run Time, Modified Since Query Mode, Server Side Pagination, Message Monitoring, employee data replication, delta replication, interface configuration, business scenario, Illegal DateTimeOffset format , KBA , LOD-SF-INT-MDI , OneMDI Business Scenarios , Problem

Product

SAP SuccessFactors HCM Suite all versions