Symptom
When trying to run the Employee Delta Export you receive the following error:
An error occurred during an API call to the backend: Invalid SFQL! Error: "deduction_recurring" is not supported in query mode "delta". For more details see the (hidden) 'Responses' sheet.
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
- Compound Employee API
Reproducing the Issue
- Perform an Employee Delta Export in query mode
- Select the segment to be used as "deduction_recurring"
- Fails with the error above
Cause
Not all segments are supported by Compound Employee API in Delta transmission mode (queryMode=delta)
There are some segments that do not support Delta transmission and the "deduction_recurring" is one of them
Resolution
Delta Transmission (queryMode=delta) is not support for this segment: "deduction_recurring"
We encourage our customers to submit this enhancement to SAP using the website “Influence SAP”.
Your opinions on how we can improve the products that drive your business are critical to our mutual success. The link to Influence is http://influence.sap.com/successFactors
See Also
Employee Central Compound Employee API > Segments Supporting Delta Transmission
Keywords
Invalid SFQL Error, delta, queryMode, deduction_recurring, not supported, Employee, delta export , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , Problem