SAP Knowledge Base Article - Public

3494571 - Invalid SFQL! Error: "xxxxxx" must be specified in the SELECT clause - Compound Employee API

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

Product

SAP SuccessFactors HCM Suite all versions