SAP Knowledge Base Article - Public

3050980 - Employee Delta Export Error: Invalid SFQL! Error: "deduction_recurring" is not supported in query mode "delta"

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

  1. Perform an Employee Delta Export in query mode
  2. Select the segment to be used as "deduction_recurring"
  3. 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

Product

SAP SuccessFactors HCM Suite all versions