Symptom
This KBA lists the solutions available to address common Post Picklist Migration issues.
Environment
SAP SuccessFactors HXM Suite
Resolution
Issue | Solution | This applies to |
Post picklist migration errors validating reports | KBA 2973443 | Analytics Advanced Reporting |
Numbers Displaying Instead of Picklist Value in a Field | KBA 2705217 | Employee Central |
EC2MDF mapping wasn’t set up before migration. | KBA 2770463 | Employee Central |
Picklists Values duplicated with ~%1 | KBA 2786336 | HXM Suite |
Picklist codes appended with suffixes "~%1", "~MDF" or "~LEGACY" | KBA 2909791 | HXM Suite |
Post migration, the parent_option_id doesn’t exist. | As part of migration, the <parent_option_id> reference is dropped and it’s set to "-1", which is the default value. If this proves to be an issue, specify the correct mapping using the Picklist Center. | HXM Suite |
Duplicate external codes exist in the existing MDF picklist. | Duplicate <external_code> values aren’t supported by MDF. As a result, during migration, a unique external code is generated for MDF and the legacy external code is preserved in a new database field. This new database field appears on the UI as non-unique external code while the other code is displayed as the external code. You can edit both these fields using the Picklist Center. Note: To edit the NonUniqueExternalCode field, you first have to make the field editable using the Configure Object Definition page in the Admin Center. |
HXM Suite |
Picklist ID is 'null' in the Legacy table | 'Null' picklist ID values aren’t supported by migration. Such picklists aren’t migrated. | HXM Suite |
Legacy Picklists with no labels | Legacy picklists without labels aren't migrated in the following scenarios:
|
HXM Suite |
External Code field is always unique but doesn't impact integration. | The external code field in new MDF picklists is always unique but you don’t have to change any integration. During migration, the original Option ID value in a legacy picklist is copied as-is to the External Code field in MDF if it's unique. Or, if there are conflicts, a new unique external code value is assigned. The original legacy Option ID value is always copied as-is to the "nonUniqueExternalCode field" in MDF. For integration, the parent picklist mapping is based on the Option ID in legacy picklists, which is transferred to the "nonUniqueExternalCode field" in MDF as-is. The generated External Code in MDF shouldn’t impact any parent picklist fields. |
HXM Suite |
For overall information on Picklist Migration, please refer to KBA 2328179 and to the Implementing Picklists.
After reviewing the above, if you still cannot identify the root cause of an unexpected behavior related to picklists after migration, please report an case for our support team to assist you further.
Keywords
picklist migration, post picklist migration, mdf picklist, picklist center, picklist centre, MDF picklist , KBA , LOD-SF-MDF-PKL , Picklists , LOD-SF-EC , Employee Central , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To