SAP Knowledge Base Article - Public

2678229 - COE_PROPERTY_NOT_FOUND [COE0021]invalid property name(s): EmployeeDataReplicationConfirmation/lastModifiedDateWithTZ


You are receiving the below errors when the query for the Data Replication Confirmation message:


[COE0021]invalid property name(s): EmployeeDataReplicationConfirmation/lastModifiedDateWithTZ


  • SuccessFactors BizX
  • Data Replication Monitor

Reproducing the Issue

Request like below, for the Employee Data Replication Confirmation message is being performed

  1.$format=json&$filter=lastModifiedDateWithTZ gt datetimeoffset'2018-01-01T02:02:02Z' and lastModifiedDateWithTZ lt datetimeoffset'2018-01-01T07:07:07Z'
  2. Request fails and returns the error message displayed in the 'Symptom' section


To identify if the issue is caused by the API Sub-Version being used,

The following check will have to be performed:

  • Check the object definition of EmployeeDataReplicationConfirmation object via 'Configure Object Definition' page in SuccessFactors.
  • If the API Sub Version field within this object is v1.0, then the OData object / entity will have the lastModifiedDateWithTZ property.
  • If it's v1.1 then it will have only lastModifiedDateTime. (V1.0 is already deprecated so it is recommended to change the query to use lastModifiedDateTime instead).

(Technically speaking, it will also work if you change it to V1.0 and keep using the lastModifiedDateWithTZ one, but this is not recommended)


If the API Sub-Version being used is not inline with the lastModified field supplied in the request,

The below action will need to be performed:

  1. The query will have to be adjusted to use the lastModifiedDateTime instead of lastModifiedDateWithTZ, inline with API sub-version v1.1
  2.$format=json&$filter=lastModifiedDateTime gt datetimeoffset'2018-01-01T00:00:00Z' and lastModifiedDateWithTZ lt datetimeoffset'2018-01-01T00:00:00Z'


  • DRM, Data Replication Monitor, Property Not Found, API Sub Version, COE_PROPERTY_NOT_FOUND, [COE0021], invalid property name(s), EmployeeDataReplicationConfirmation/lastModifiedDateWithTZ
, KBA , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-DRM , Data Replication Monitor , Problem


SAP SuccessFactors HXM Core all versions