SAP Knowledge Base Article - Public

2397120 - ERROR: Invalid SFQL! Error: The enhanced SFQL capabilities of Compound Employee API are not enabled - CEAPI

Symptom

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

This KBA describes the resolution for the error "The enhanced SFQL capabilities of Compound Employee API are not enabled" which is encountered while running the CompoundEmployee API in Successfactors.

Note: This issue occurrs when you are trying to query the Compound Employee Mapping Extension fields.

Environment

  • Successfactors Employee Central (API)
  • BizX

Reproducing the Issue

To reproduce the issue, follow the steps below: (We have chosen SOAP UI to reproduce the problem)

1. Execute the log-in call to Successfactors instance through the "login" menthod (here a sample SOAP body is shown, in real time scenario company ID,username and password are filled in the place of [string])

<Envelope xmlns="XXXX">
    <Body>
        <login xmlns="XXXX">
            <credential>
                <companyId>[string]</companyId>
                <username>[string]</username>
                <password>[string]</password>
                <developerKey>[string?]</developerKey>
            </credential>
            <!-- Optional -->
            <param>
                <name>[string]</name>
                <value>[string]</value>
            </param>
        </login>
    </Body>
</Envelope>

2. After the successsful login, we would pass the following query

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="XXXX" xmlns="XXXX">
  <SOAP-ENV:Header />
  <SOAP-ENV:Body>
    <query xmlns="XXXX">
      <queryString>SELECT person/extensionFields,employment_information FROM CompoundEmployee</queryString>
      <param>
         <name>XXXX</name>
         <value>XXXX</value>
      </param>
    </query>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

3. Response received for this

<?xml version='1.0' encoding='UTF-8'?>
<S:Envelope xmlns:S="XXXX>
    <S:Body>
        <ns2:Fault xmlns:ns2="XXXX" xmlns:ns3="XXXX">
            <faultcode>ns2:Server</faultcode>
            <faultstring>SFAPI Domain Error!</faultstring>
            <detail>
                <ns2:SFWebServiceFault xmlns=XXXX" xmlns:ns2="XXXX">
                    <ns2:errorCode>INVALID_SFQL</ns2:errorCode>
                    <ns2:errorMessage>Invalid SFQL! Error: The enhanced SFQL capabilities of Compound Employee API are not enabled. Please enable the feature in provisioning.</ns2:errorMessage>
                </ns2:SFWebServiceFault>
            </detail>
        </ns2:Fault>
    </S:Body>
</S:Envelope>

Cause

When the feature "Compound Employee Mapping Extension" is enabled at the backend, this inturn needs the following feature also to be enabled "Enable enhanced segment and field selection".

If this is not enabled, it will lead to the error documented in the title.

Resolution

How to enable Enable enhanced segment and field selection?

  • Goto "Provisioning --> SFAPI Feature Settings --> Enable enhanced segment and field selection"

fieldSelectionFeature.JPG

See Also

Implementing the Employee Central Compound Employee API - Standard Documentation

Keywords

Compound Employee, Invalid SFQL!, capabilities , KBA , invalid_sfql , compoundemployee , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-BOM , Standard SF to 3rd Party Boomi Content , Problem

Product

SAP SuccessFactors HXM Suite all versions