SAP Knowledge Base Article - Public

3349285 - CompoundEmployee not respecting last_modified_on filter criteria


You are using Period-Based Delta Transmission with the CompoundEmployee (CE) API to query SuccessFactors data.

However, the API response is not respecting the last_modified_on filter criteria of the API request.


SAP SuccessFactors HXM Suite

Reproducing the Issue

API request example:

<queryString>SELECT ... FROM CompoundEmployee WHERE (last_modified_on &gt; to_datetime(...)) and (fromDate = to_date(...)) and (toDate = to_date(...))

OBS.: If you use <value>delta</value> but also the fromDate and toDate parameters, the Delta Transmission runs as Period-Based as well.


In short, Period-Based Delta Transmission returns records that match either the last_modified_on set OR that become effective into the given period (start_date).

This is independent of the operations used in the API request filters, such as AND/OR.

OBS.: If you want to learn more about Period-Based Delta Transmission, check the See Also section.

See Also


fromDate, toDate, periodDelta, delta, period based, period-based, transmission, does not, doesn't, not, do not, don't, match, matching, respect, respecting, consider, considering, effective, start_date, period, and, or, last modified on, last modified, filter, filters, criteria , KBA , LOD-SF-INT-CE , Compound Employee API , Problem


SAP SuccessFactors HCM suite all versions