SAP Knowledge Base Article - Public

3226503 - Data for field "Married" under object "User" is returning blank values

Symptom

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


You wish to know why data for field "Married" under object "User" is returning blank values

Environment

SAP SuccessFactors Integration Center

Reproducing the Issue

  1. Add new employee
  2. Map "unmarried" in Marital Status in personal information
  3. Run the integration
  4. Check marital status column

Cause

Configuration

Resolution

Please note the User API is querying the married flag from the User side, whereas when you add new employee and update the married status, this will come from EC Personal Info.

This sync mapping from EC married status to User married is controlled by the EC HRIS sync.

The marital status field of personal info block is configured as a picklist, but the married field in user block is a Boolean. In the code, we will check the picklist value and convert it as below:

 

 
 
external code
Boolean value
Single
S
false
Married
M
true
Divorced
D
false
Widowed
W
false

(please note,  true for "M" and false for "W/S/D"  are hard coded values and cannot be changed)  


In the picklist center you need to configure the external code like this, otherwise it will not be recognized by the system:



When adding a new hire or updating the personal info block on people profile page for existing employees, the converted Boolean value will be true for "M" and false for "W/S/D". If you define any other external code, it will not be synced to the User side. 

Keywords

ECT-199786, marital, marital status, boolean, IC, Integration Center, Integration Centre, User, blank , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-INC-JOB , Integration Center Job , Known Error

Product

SAP SuccessFactors HXM Suite all versions