SAP Knowledge Base Article - Public

2170510 - API Query returns external Code instead of Option Id for picklist type field in Successfactors system

Symptom

API Query for picklist fields returns ambiguous resuts i.e. for some employees the query returns ‘Option Id’ value, whereas for some it returns ‘external code’ value of the corresponding Picklist field.

Cause

This is a system behavior.

When there is no value defined in the Employee Central UI for a picklist field of some employee record, there is a possibility that the Select Query might fetch the external code value for that picklist field for that specific employee record rather than the Option Id.

Resolution

The solution to this problem is to update a valid value in the Employee Central UI in Successfactors system for those picklist fields for the employees where no value is defined.

Keywords

KBA , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SuccessFactors HCM Suite 1207 ; SuccessFactors HCM Suite 1210 ; SuccessFactors HCM Suite 1302 ; SuccessFactors HCM Suite 1305 ; SuccessFactors HCM Suite 1308 ; SuccessFactors HCM Suite 1311 ; SuccessFactors HCM Suite 1402 ; SuccessFactors HCM Suite 1405 ; SuccessFactors HCM Suite 1408 ; SuccessFactors HCM Suite 1502 ; SuccessFactors HCM Suite 1505 ; SuccessFactors HCM Suite 1508