SAP Knowledge Base Article - Public

2988225 - How to resolve "Found extra options on one side with the same label" error - Pre Picklist Migration

Symptom

The following error shows up in the "Premigration Check Result" of the "Validation Check & Merge Tool for Picklist Migration" page: "Found extra options on one side with the same label".

Environment

SAP SuccessFactors HXM Suite

Cause

This precheck error comes from a pair of partially matched legacy and MDF picklists, which also is showing up in the "Decision Required" tab. There are multiple options with the same label, and yet the number of those options are different on the two sides. Therefore, it is impossible to make an automatic match between those options without the customer's manual instruction.

This situation is shown as a pre-migration check error, with detailed information printed out in the "Error Details" column.

For example, the following pair of partially matched legacy and MDF picklists could be the cause of the precheck error above:

The match logic will try to match options from two sides based on the values of the company locale labels, which in this case is en_US. So when there are multiple options with the same label, and one side has more options than the other side, it will be impossible to match the two sides. In this case, the highlighted "Permanent" option in legacy picklist and the highlighted "External" option in MDF picklist are considered as "extra duplicate options", as listed in Error Details.

Resolution

There are two possible resolution steps:

  1. If you choose “Keep Separate” as your decision for this partial match in the “Decision Required” tab of the migration conflicts tool, the error will be solved.
    With that, the legacy picklist will be migrated to a separate MDF picklist, so it doesn't matter how different it is from the MDF picklist.

  2. If you want to merge the legacy and MDF picklists into one picklist, you need to make both match perfectly. That means both sides should at least have the same amount of options with exact same label. To achieve that, we need to check the options listed in "Error Details" and make the necessary adjustments.

    In the example above, we should either remove the second "Permanent" option from the legacy picklist or add a second "Permanent" option to the MDF picklist.
    We also recommend making all external codes and labels unique, e.g. changing the label of the second "Permanent" option to "Permanent Franchise", and external code to "PF".

See Also

2816514 - How to Resolve Pre Picklist Migration Issues

2770495 - What are Picklist Migration Conflicts and how to prepare for migration - Pre Picklist Migration

Keywords

Found extra options on one side with the same label, pre picklist migration, premigration, picklist migration, label, AFT-18452 , KBA , LOD-SF-PLT-PCK , Picklist Management Issue , LOD-SF-MDF-PKL , Picklists , LOD-SF-PLT , Platform Foundational Capabilities , Problem

Product

SAP SuccessFactors HXM Suite all versions