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

API request example:

<queryString>SELECT ... FROM CompoundEmployee WHERE (last_modified_on &gt; 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.

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.

• 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)

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