When running the Employee Delta Export (Excel Tool) you encounter the below OData API error (or a similar error)
- <?xml version="1.0" encoding="utf-8"?>
<message lang="en-US">[COE0021]Invalid property names: PerPersonal/middleName. Please check the property name in Admin Center > OData API Data Dictionary or entity metadata.
Ensure there were no data model changes that removed this field, and please execute a refresh metadata to ensure the cache is not corrupted.
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
- Employee Delta Export
The error is caused by the field / property mentioned in the error being disabled.
In the above example, the field Personal Information > Middle Name is not enabled in Manage Business Configurations section of your EC-Enabled SuccessFactors system.
While the Employee Delta Export tool is primarily leverages Compound Employee API, there is some supplemental information which is retrieved via OData API.
It is during this process the errors occur.
There is two options to address the issue:
- The field mentioned in the error can be enabled via Manage Business Configurations
The second approach (assuming you do not want to enable the field / property) is remove the column in the Employee delta Export tool which is responsible for triggering the OData API call:
As a pre-requisite, the Developer tab must be enabled in Excel:
To enable this, please refer to the Microsoft documentation on the topic:
After this, you need to navigate to the Developer tab & select Tools > Show Internal Sheets:
After which, you will see additional sheets shown at the bottom of the workbook, this is concerned with tab: LookupPerson:
In this sheet, select the column & then in the Developer Tab: Design > Delete Column
This should remove the middleName from the $select in the OData API call to PerPersonal object & subsequently resolve the error
Employee Delta Export, excel, Developer, tab, OData, API, COE_PROPERTY_NOT_FOUND, [COE0021], Invalid property names , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , How To