Symptom
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.
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
API request example:
<queryString>SELECT ... FROM CompoundEmployee WHERE (last_modified_on > to_datetime(...)) and (fromDate = to_date(...)) and (toDate = to_date(...))
<param>
<name>queryMode</name>
<value>periodDelta</value>
</param>
OBS.: If you use <value>delta</value> but also the fromDate and toDate parameters, the Delta Transmission runs as Period-Based as well.
Resolution
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
- KBA 2649816 - CompoundEmployee API Delta Transmission
- Period-Based Delta Transmission with the CompoundEmployee API (CE guide)
- Effective-Dated and Period-Based Delta Transmission (CE guide)
Keywords
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