SAP Knowledge Base Article - Public

2653787 - Unable to delete records using OData for entity EC or MDF entities - SuccessFactors HXM Suite

Symptom

You want to delete an existing record for some EC or MDF entity like PerAddressDEFLT, EmpPayCompNonRecurring and others.

You want to use SFOData for this and you received the error like the one above in the response:

{
"error": {
"code": "COE_ENTITY_NOT_DELETABLE",
"message": {
"lang": "en-US",
"value": "[COE0012]Entity XXXXXXX is not deletable."
}
}
}

Environment

  • SuccessFactors HXM Suite
    • OData API

Cause

Expected behavior

Resolution

If you try to delete some entity that by standard is not allowed, you will get the error message: COE_ENTITY_NOT_DELETABLE

And that is because this entity does not support DELETE operation.

You can find the operations available for each entity in the Admin center > OData API Data Dictionary.

As workaround, please evaluate to use the parameter purgeType (purgeType=full).

Note about Purge type = Full:

  • If there are multiple time slices for the given record, the upsert operation with purgeType=full deletes all the time slices and creates new ones specified in the request. If you want to keep a particular time slice, make sure to include all of its data in the request payload. If some time slices are missing, then import engine will delete them.

Keywords

COE_ENTITY_NOT_DELETABLE, SFOData, COE0012, entity is not deletable, EC, MDF, purgeType, Full, DELETE, SuccessFactors HXM HCM Suite, Employee Central , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-MDF , Metadata Framework API (MDF) , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , How To

Product

SAP SuccessFactors HXM Suite all versions