SAP Knowledge Base Article - Public

3266951 - Picklist values are duplicated or missing in a Custom MDF Object

Symptom

  • In a Custom MDF Object (Portlet or Manage Data) one or more picklist values are missing
  • In a Custom MDF Object (Portlet or Manage Data) one or more picklist values are duplicated
  • You can't see a picklist value, unless you type it in the dropdown

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

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Go to Employee Profile or Manage Data
  2. Search for the Custom MDF Object which contains the affected picklist
  3. Open the picklist dropdown and see a duplicated value or missing values
  4. Type the missing picklist value in the dropdown and you can see it now

Cause

The Display Order in the Picklist is set as "custom", however the field "Sort Order" is not defined for each picklist value.

System fills the "Sort Order" field with a random number for each picklist value.

Resolution

You must add a unique value in each Picklist Value to sort the order this value will display in the dropdown.

  1. Go to Picklist Center
  2. Search for the affected picklist
  3. Open each value and add the order values in "Sort Order" field (e.g. 0, 10, 20, 30 and so on)

Another option is to change the "Display Order" in the picklist to "Numeric" or "Alphabetical"

See Also

2848565 - MDF Picklist - How to control the Display order? 

MDF Picklists

Keywords

Picklist order, display order, duplicated values, missing values, picklist values, sort order , KBA , LOD-SF-MDF-PKL , Picklists , LOD-SF-PLT-PCK , Picklist Management Issue , How To

Product

SAP SuccessFactors HXM Core 2211