SAP Knowledge Base Article - Public

2704862 - Background SFAPI entity throws error: Fail to delete background

Symptom

Even when the call is successful, Background SFAPI entity intermitently throws error on delete operation: Fail to delete background: Unable to delete background id on Data Deletion, failed on update or delete by foreign key constraint violation.

Environment

SuccessFactors SFAPI.

Reproducing the Issue

  1. Attempt to re-import/delete variable pay employee history records after Bonus payout calculation is run.
  2. The call is successful but we can see an error in the SFAPI audit log response payload.
  3. Error should be like: Fail to delete background: Unable to delete background id

Cause

This is expected behavior with Background SFAPI when we want to delete/re-import variable pay employee history records after Bonus payout Calculation is run.The assignment records generation typically happens when Bonus Payout   Calculation is run and is also dependent on the factors like if the employee history record is eligible for any bonus plans etc.

 Situation where the error may not happen:

  • Employee not eligible for any bonus plans and hence no assignment records generated for them in the system.
  • The employee record was deleted before bonus payout calculation

Resolution

Once you have an assignment generated for the employee history record, the Delete SFAPI will not work (because of Foreign Key Constraint error) and hence we have addressed the limitation with VariablePay Employee History ODATA API.

See Also

 2613670 - What are the available APIs for SuccessFactors?

Keywords

Even when the call is successful, Background SFAPI entity throws error: Fail to delete background: Unable to delete background id on Data Deletion, failed on update or delete by foreign key constraint violation, Background SFAPI entity throws error on Data Deletion. , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , PA-SFI-TM , Integration with SuccessFactors BizX Talent Management , Problem

Product

SAP SuccessFactors HCM Core all versions