SAP Knowledge Base Article - Public

2946940 - The field "last_modified_on" is not being return for DELETE action - Compound Employee API


You make a Compound Employee query using the parameters queryMode=Delta and resultOptions=renderPreviousTags, and you noticed that on action=DELETE segments, there is no <last_modified_on> field:


Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


  • SAP SuccessFactors HXM Suite
    • Compound Employee API


The action=DELETE segments don't have "last_modified_on" field, and this is the expected behavior.

On Compound Employee Guide, you'll be able to see the following statement on section " Select Parameters for the WHERE Clause":

Deletion of records is considered in queries for last modified employees. These deleted records aren’t returned by the API. For example: WHERE last_modified_on > to_datetime('2012-11-06T23:30:00Z') WHERE last_modified_on > to_date('01/07/10', 'DD/MM/YY')>

See Also

Compound Employee Guide

Compound Employee Guide in Delta Transmission Mode


ce api, compoundemployee, sf, successfactors, success factors, last modified on, portlet, segment, object,  , KBA , LOD-SF-INT-CE , Compound Employee API , How To


SAP SuccessFactors HXM Core 2005