SAP Knowledge Base Article - Public

3479296 - Picklist label field displays ID/numerical value/blank data instead of label in Story report

Symptom

  • When logged into the instance with a user that has locale language set to e.g EN_UK, no label is returned for Picklist Label Field in a Story report even after correct permissions are provided. When changing user's language to English US - EN_US, the texts will appear.
  • MDF picklist label field displays ID/numeric value/blank data in Query Designer filter instead of a label in various locales.

"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. Login to SF
  2. Navigate to Reporting
  3. Run the affected Story report
  4. Observe that the picklist field does not display correct label in various locales (numeric value/ID or blank data is seen instead of text).

Cause

The picklist view definition doesn't contain relevance to the selected language.

Resolution

Kindly verify if the translations are maintained properly, before moving forward.

1. Company Data Migrate Job:

  1. Access Provisioning
  2. Navigate to "Manage Scheduled Job" -> Create a new job
  3. Select the Job type as "Company Data Migrate Job" and make sure that the Job parameter is added as "com.successfactors.arb.service.upgrade.CreateMDFPicklistViewV5"



  4. Create the Job -> Run it once.

2. Picklist Migration to MDF:

  1. Access Provisioning
  2. Navigate to "Manage Scheduled Job" -> Create a new job
  3. Select the Job type as "Picklist Migration to MDF" and choose "Recreate Picklist and Label Views" under job parameter. Fill the rest of the mandatory fields.
  4. Create the job -> Run it once.

Note: Only Partners/SAP has access to Provisioning. If require assistance from support, please create a ticket to LOD-SF-ANA-SAC-DAM component.

3. If the first options do not work, Enable and disable a locale:

  1. In SF, navigate to Admin Center > Tool Search > Manage Languages
  2. Enable a new locale by checking the locale you would like to enable under the "ACTIVE" column
  3. Wait for few minutes.
  4. Verify that the labels are populating correctly in Story.
  5. Disable the newly enabled locale by unchecking the locale under the "ACTIVE" column

4. If the issue persists, Disable and enable the affected locale:

  1. In SF, navigate to Admin Center > Tool Search > Manage Languages
  2. Disable the affected locale by unchecking the locale under the "ACTIVE" column
  3. Wait for few minutes.
  4. Enable the affected locale by checking the locale under the "ACTIVE" column
  5. Wait for few minutes.
  6. Verify that the labels are populating correctly in Story.

Note: Refer the following KBA for a detailed explanation on enabling locale:
2576325 - Enable a New Language Pack in SuccessFactors - SAP for Me 

If neither of these actions do not work, then please create a support ticket to LOD-SF-ANA-SAC-DAM component, providing all necessary details as per 2949729 KBA.

***Note to SAP Support: Please see Internal Memo.

See Also

2576325 - Enable a New Language Pack in SuccessFactors - SAP for Me 

Keywords

story report, sac, mdf, picklist, field, label, numerical value, id, missing data, code, Locale, language, translation, text, Manage languages, enable, disable, Recreate Picklist and Label View, Picklist Migration to MDF, job, provisioning, definition, filter, query designer, hidden, not showing, appearing, blank, en_uk, en_us, generic object, table, description , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-MDF-PKL , Picklists , Problem

Product

SAP SuccessFactors Platform all versions