SAP Knowledge Base Article - Public

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

Symptom

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

COE_PROPERTY_NOT_FOUND

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

Environment

  • SuccessFactors BizX
  • SAP ERP
  • Data Replication Monitor

Reproducing the Issue

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

  1. https://apiX.successfactors.eu/odata/v2/EmployeeDataReplicationConfirmation?$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

Cause

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)

Resolution

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. https://apiX.successfactors.eu/odata/v2/EmployeeDataReplicationConfirmation?$format=json&$filter=lastModifiedDateTime gt datetimeoffset'2018-01-01T00:00:00Z' and lastModifiedDateWithTZ lt datetimeoffset'2018-01-01T00:00:00Z'

Keywords

  • 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

Product

SAP SuccessFactors HCM Core all versions