2160265 - Compound Employee API’s Query limitation with Where clause.

You would see below errors in the SFAPI audit log's SOAP_Response for the "Query" operation with API entity "Compound Employee".

• <faultstring>SFAPI Domain Error!</faultstring>
• errorMessage>Query failure! Error: Failed to query</ns2:errorMessage>

SuccessFactors 

This issue occurs when the Compound Employee API queries a large number (over 999) of person_id_external in where clause.

Sample query:

SELECT accompanying_dependent,address_information,alternative_cost_distribution,compensation_information,deduction_non_recurring,deduction_recurring,

direct_deposit,email_information,employment_information,global_assignment_information,job_information,job_relation,national_id_card,

paycompensation_non_recurring,paycompensation_recurring,payment_information,person,person_relation,personal_information,

phone_information FROM CompoundEmployee WHERE person_id_external IN ('120052','120053','120060','120061','120062','120063','120065',...........

.......

......

......

This is an expected behavior of the product.

As of now, Database only supports upto a number of 999 ids passed in a list in the where clause of the query.

For larger requirement, It is advised to split or reduce the number of employees in the list for person ids.

Compound employee ,Query Failure , where clause limitation , sfapi query failure    , KBA , LOD-SF-INT , Integrations , Problem