SAP Knowledge Base Article - Public

3106806 - Results missing from Compound Employee API query response when using WHERE clause 'employment_information_country' - SAP SuccessFactors HXM Suite

Symptom

A Compound Employee API query with the parameter 'suppressUnwantedGlobalInfo' and the filter 'employment_information_country' is sent to SuccessFactors, and either employees from a given country are missing in the response, or 0 results are returned.

Sample request

Response

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

Environment

  • SAP SuccessFactors HXM Suite
    • Compound Employee API

Cause

The 'employment_information_country' filter relies on the associations between Country' and Company/Legal Entity records. This association is required, but it might be missing in some Company records because some Country record may have been deactivated or deleted. This can be verified using the 'Manage Data' tool in SuccessFactors.

Example

In case there are Company/Legal Entity records with this association missing, the 'employment_information_country' will not work properly, causing missing results.

Resolution

Correct the Company/Legal Entity records by adding an association to a Country.

Keywords

ce, api, missing, no, results, blank, 0, records, incomplete, response, message, payload, query, delta, compoundemployee, employees, information, not, returned, inconsistent, global, country, company, filter, filtered, correctly , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , Problem

Product

SAP SuccessFactors HCM Suite all versions