SAP Knowledge Base Article - Public

2339754 - Invalid SFQL! Error: Invalid WHERE clause. No internal code exists for external code "XXXXX" of "company"

Symptom

Receiving below error message when querying Compound Employee API having filter criteria as 'company IN ('XXXXX')'

Screenshot1.jpg

Environment

Successfactors

Cause

Incorrect value 'XXXXX' passed in the query

Resolution

To verify whether the value passed in the query is correct or not, you can follow below steps-

  1. Login to SFSF Instance and navigate to 'Admin Center -> Manage Data'.
  2. Now select the option 'company' as shown in the screenshot below and you can see a list of all the values present in the drop down right next to it.
  3. And if you select any of the values from the dropdown, you will see below screen in which the highlighted 'Company ID' field is actually the external Code value that should be used in the query.

Screenshot2.jpg

Keywords

Getting error message- No internal code exists for external code "XXXXX" of "company" , KBA , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Suite all versions