Symptom
You are using Compound Employee to replicate employees from SuccessFactors Employee Central, but receives the following error from API:
"Invalid SFQL! Error: "xxxxxx" must be specified in the SELECT clause"
Environment
- SAP SuccessFactors HCM Suite
- Compound Employee API
Cause
This issue happens whenever any of the mandatory segments of Compound Employee are not included on the SELECT Clause for replication purposes:
- Compensation Information
- Personal Information
- Job Information
- Employment Information
- Biographical Information
Resolution
Add all the mandatory segments to the SELECT clause of Compound Employee API
See Also
Keywords
compound employee, CE, invalid sfql, must be specified in the select clause, segments, select clause, personal_information, employment_information, job_information, compensation_information , KBA , LOD-SF-INT-CE , Compound Employee API , Problem