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
- 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).
- Enable the "Server Side Pagination" feature in the Destination Settings of the Business Scenario.
- 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
SAP Knowledge Base Article - Public