2391638 - Field per_person_uuid is not sortable in CompoundEmployee API

SAP Knowledge Base Article - Public

2391638 - Field per_person_uuid is not sortable in CompoundEmployee API

Symptom

The idea behind using this field for ORDER BY condition is per_person_uuid is a unique field returned in the CompoundEmployee API response.

But, when we use this then the following error occurs: QUERY_FAILURE

Environment

SFAPI, BizX

Reproducing the Issue

Request:

<?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,personal_information,employment_information,emergency_contact_primary,dependent_information,associated_employee_information FROM CompoundEmployee WHERE per_person_uuid = 'C12CF06BB32C497DA565B462B6DD0771'ORDER BY per_person_uuid ASC</queryString>
    </query>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Response:

<?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:ns2="urn:fault.sfapi.successfactors.com" xmlns="urn:sfobject.sfapi.successfactors.com">
          <ns2:errorCode>QUERY_FAILURE</ns2:errorCode>
          <ns2:errorMessage>Query failure! Error: ORDER BY for per_person_uuid field is not supported</ns2:errorMessage>
        </ns2:SFWebServiceFault>
      </detail>
    </ns2:Fault>
  </S:Body>
</S:Envelope>

Cause

As indicated in the response from the CompoundEmployee API, the field does not support sorting even though it is unique.

Resolution

CompoundEmployee API only supports "start_date" for sorting. No other field is supported.

Keywords

KBA , per_person_uuid field is not supported , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT-PAY , P2P & Cloud Payroll , Problem

Product

SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors HCM Core 1611