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

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

• Same error can be noticed in tcode SRTUTIL/SRT_MONI for BIB replication scenario.

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

• SuccessFactors HXM suite
  • Integrations
    • SFAPI

Incorrect value 'XXXXX' passed in the query.

To verify whether the company 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 BIB replication query.

       4. You can go to SPRO path below to check the company used in BIB query in ERP system:
           >Personnel Management
               >Integration with SuccessFactors Employee Central
                   >Business Integration Builder
                       >Employee Data Integration
                            >Define Parameters for Employee Master Data and Org. Assignment Query
                             

Company ID, Company, Legal Entity, Legal entity, Compound Employee error, SFAPI Domain Error!, Invalid SFQL, API, SFAPI,V_ECPAO_QRY_CFG , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , How To