SAP Knowledge Base Article - Public

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

Symptom

How to match OptionID between two instances?

Environment

SAP SuccessFactors HCM Suite

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.

Cause

This is an expected behavior. Performing an Export/Import Picklist or an Instance Sync the 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 and not overlap with some value that might already exist.

Resolution

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

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

Keywords

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

Product

SAP SuccessFactors HCM Suite all versions