2909791 - Picklist codes appended with suffixes "~%1", "~MDF" or "~LEGACY" - Post Picklist Migration

SAP SuccessFactors HXM Suite

Whenever two picklists with the same ID exist on both MDF and Legacy sides (prior to the migration) but do not match perfectly (e.g. amount of values, statuses or labels are different), the migration keeps them both separate and appends a suffix to their IDs to make them distinguishable.

For example, if a picklist ID “country” exists on both MDF and Legacy sides (with some mismatch between them prior to the migration), you will see two MDF picklists created on Picklist Center after migration, as follows:

Prior to March 2020, the suffixes used were numerical and in the following format: “~%1”, “~%2” and so on. Those also used to be added to the original legacy picklist, as follows:

Please review where the picklists are being used/referenced across your instance and update the references to comply with the new Picklist Codes/IDs.

In the event of one of the picklists is not being used anywhere in your system and you want to deactivate and/or to rename one of them, then please follow the steps below.

For these resolution steps, we will consider, for example purposes, that you have a picklist named “country” and another one named “country~LEGACY” after migration.

1. Please review which of your two picklists is the correct one to be kept based on your business needs (e.g. “country” or “country~LEGACY”);
2. Then, make sure to take a backup of both picklists (for security reasons) and to confirm everywhere on your instance where the respective picklist is being used, so that you can adjust those references later accordingly;
3. After that, depending on the correct picklist to be kept, follow the below:
   1. If the correct picklist is "country"
      All you need to do is to change the status of picklist "country~LEGACY" to INACTIVE and make sure that your references are set to the desired picklist (“country”).
      
      
   2. If the correct picklist is "country~LEGACY", then:
      1. Rename the "country" picklist to anything such as "country_OLD" or “country_DONOTUSE”
      2. Now, rename the "country~LEGACY" picklist back to "country"
      3. Change the status of picklist "country_OLD" (or “country_DONOTUSE”) to INACTIVE
      4. Make sure to restore your references and have them point to the correct picklist

You can perform the steps above manually via Picklist Center (for which detailed instructions are available on the Picklist Center guide) or massively by exporting and importing your MDF Picklists (for instructions on how to do so, please refer to KBA 2714036 - How to Import and Export MDF Picklists).

2816504 - How to resolve Post Picklist Migration issues