SAP Knowledge Base Article - Public

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

Symptom

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)

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="http://schemas.xmlsoap.org/soap/envelope/">
    <Body>
        <login xmlns="urn:sfobject.sfapi.successfactors.com">
            <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="http://schemas.xmlsoap.org/soap/envelope/" xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP-ENV:Header />
  <SOAP-ENV:Body>
    <query xmlns="urn:sfobject.sfapi.successfactors.com">
      <queryString>SELECT person/extensionFields,employment_information FROM CompoundEmployee</queryString>
      <param>
         <name>agent</name>
         <value>ce_CE_1611_test</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="http://schemas.xmlsoap.org/soap/envelope/">
    <S:Body>
        <ns2:Fault xmlns:ns2="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns3="http://www.w3.org/2003/05/soap-envelope">
            <faultcode>ns2:Server</faultcode>
            <faultstring>SFAPI Domain Error!</faultstring>
            <detail>
                <ns2:SFWebServiceFault xmlns="urn:sfobject.sfapi.successfactors.com" xmlns:ns2="urn:fault.sfapi.successfactors.com">
                    <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

Keywords

KBA , compoundemployee , invalid_sfql , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT-BOM , Std. SF to 3rd Party Boomi Content , Problem

Product

SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Core 1702