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
- Attempt to re-import/delete variable pay employee history records after Bonus payout calculation is run.
- The call is successful but we can see an error in the SFAPI audit log response payload.
- 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
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