Symptom
Customers want to Delete the employee data for starting entity "EmpPayCompNonRecurring" They are getting below error from different environment.
This is a sample response on a preview environment:
Invalid operation value. Only supported values are [DELETE].
However, if use DELETE on the Test environment :
Invalid operation value. Only supported values are [DELIMIT]., Record contains incorrect delimit token. Delimit token is DELIMIT and it is case sensitive
- Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HXM Suite
- Integrations
- OData
- Integrations
Reproducing the Issue
1. Created the payload and Run DELET operation through the postman
2. use below payload
{
"__metadata": {
"uri": "EmpPayCompNonRecurring",
"type": "SFOData.EmpPayCompNonRecurring"
},
"payDate":"/Date(1530396000000)/",
"payComponentCode":"SAP10A",
"operation": "DELIMIT",
"userId": "SFADMIN",
"sequenceNumber": "10"
}
3. Getting below error
<d:status>ERROR</d:status><d:editStatus m:null="true"></d:editStatus><d:message>Invalid operation value. Only supported values are [DELETE].
Cause
These criteria doesn't apply to entities supported by Centralized services.
Business key changes are considered as a 'Delete' of existing business keys and 'Insert' of new business keys. This applies whether the business key is changed or if the same business key is deleted and re-added.
Resolution
Employee data can be deleted in Incremental Load mode, by choosing an operation type between DELETE and DELIMIT. The operation type depends on the entity you select for importing data.
While preparing import data, enter DELIMIT or DELETE (depending on the selected entity) in the operation column.
For deleting.. | Enter in the Operation Column |
---|---|
Addresses | DELIMIT |
Compensation Information | DELETE |
Email Information | DELETE |
Emergency Contact Information | DELETE |
Global Information | DELIMIT |
Job History | DELETE |
Job Relationships | DELIMIT |
National ID Information | DELETE |
Non Recurring Pay Component Information | DELETE |
Person Relationship | DELIMIT |
Personal Information | DELETE |
Phone Information | DELETE |
Recurring Pay Component Information | DELIMIT |
Social Accounts Information | DELETE |
Note:- Please check with Centralized services. if centralized services is enabled, system consider some fields are business key and hence Delete operator is expected.
See Also
Keywords
Centralized services, Deleting Employee Data, EmpPayCompNonRecurring, DELIMIT, DELETE, Invalid operation value, supported , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-JOB , Integration Center Job , Problem