SAP Knowledge Base Article - Public

2767508 - How to match MDF Picklist OptionID value between two instances?


How to match OptionID between two instances?


  • SAP SuccessFactors HCM Suite
  • Metadata Framework (MDF)

Reproducing the Issue

Scenario #1:

When performing an Export Picklist from source instance and importing Picklist to target instance, the optionID value is with different than what is set on target instance.

Scenario #2:

When performing an Instance Sync between two instances, the optionID value is different than on target instance.

Scenario #3:

After performing an Export/Import Picklist, business rules which are associated with picklists are with inconsistencies.


This is an expected behavior. While performing an Export/Import Picklist or an Instance Sync, system will use current option ID sequence in the target instance to generate new option IDs.
This process is necessary to ensure that option ID uniqueness will continue on target instance and not overlap with some value that might already exist.


Only workaround available would be to perform an Instance Refresh, which would copy all data that exists from the source to the target environment.

It should be last resort and this decision should be taken by customer at their side whether or not they want to perform refresh to get the same option Id values in both the instances.

NOTE: More info about Instance Refresh see KBAs 2088117 and 2277508.


Option ID, MDF Picklist, Picklist Center, same optionID, change OptionID, match option id, option id sequence, STE-11946 , KBA , LOD-SF-MDF-PKL , Picklists , Problem


SAP SuccessFactors HXM Suite all versions