SAP Knowledge Base Article - Public

2464855 - HRIS Sync stopped working for certain mappings after MDF Picklist Migration

Symptom

After the Legacy Picklists have been migrated to MDF Picklists, certain HRIS Sync mappings stopped working (for elements such as emailInfo, phoneInfo, homeAddress).

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

Environment

SAP SuccessFactors HCM Suite - MDF Picklists (post migration)

Reproducing the Issue

This can only potentially after Legacy Picklists are migrated to MDF Picklists

Cause

The "Non-unique External Code" field was empty for each of the picklist values. For example the ecEmailType picklist was migrated but the "Non-unique External Code" value for each of the email types was not -:

BrokenExternalCodeInMDFMigratedPicklist.jpg

 

This "Non-unique External Code" value is the legacy "external_code" which is used in the HRIS Sync Mapping configuration to identify which Email Type value is synchronized to Employee Profile > email field. Example EC HRIS Sync Mapping configuration -:

    <hris-element-ref refid="emailInfo">
      <hris-mapping entity-type="B" >     <-- Is the "Non-unique External Code" of the picklist
        <hris-field-ref refid="email-address"/>
        <standard-element-ref refid="email"/>
      </hris-mapping>
    </hris-element-ref>

Resolution

The issue is easily resolved. You will need to add the correct value to the "Non-unique External Code" field. Normally this is the "External Code" value. But, if you are not sure, for Employee Central related picklists, the legacy picklists "external_code" should be set here. You can download the EC Master Picklists (legacy) file to verify the the "Non-unique External Code" value. Make sure to check and correct ALL picklists that are used by Employee Central, which were migrated from Legacy to MDF.

You can correct the MDF Picklist either using the UI or on mass via Import.

 

Correcting using the UI

  1. Navigate to Admin Center > Manage Picklist
  2. Search for the related picklist in question
  3. Edit the picklist
  4. Copy the "External Code" value to the "Non-unique External Code" field, for all picklist values
  5. Save the Picklist

FixExternalCodeInMDFMigratedPicklist.jpg

 

 

Correcting using Imports

  1. Navigate to Admin Center > Import and Export Data
  2. "Export Data" and "Picklist-Values"
  3. Navigate to Monitor Job and download the export file.
  4. Make a copy of the export file and keep it as a backup
  5. Open the exported file in Excel or OpenOffice
  6. Remove all of the rows for picklists that you do not wish to update
  7. Add the missing value to the "Non-unique External Code" field
    1. Either by copying the values from column "External Code" to "Non-unique External Code"
    2. Comparing and correcting the values based on the values in the legacy EC Master Picklist (you can download the EC Master Picklists)
  8. Save the file to your Desktop
  9. Navigate to Admin Center > Import and Export Data
  10. "Import Data" and "Picklist-Values"
  11. Choose the File.
  12. Set "Purge Type" to "Incremental Load" and click "Import"

Import.jpg

 

 

Full HRIS Sync must be run

Finally, you will need to have a Full HRIS Sync job run on the instance to correct the data in Employee Profile. Please do open a Support case for this request, unless you have access to Provisioning.

For more information regarding the HRIS Sync, please refer to the following articles:

  • 2080728 - HRIS Sync - Explained - Employee Central
  • 2080065 - What is a Full HRIS Sync? - Employee Central
  • 2263251 - How to run a one time Full HRIS Sync

 

See Also

Employee Central Master:
https://help.sap.com/viewer/b14dd15ca58f43e0856184a740a4b212/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Employee Central Position Management:
https://help.sap.com/viewer/cf23ba26985f4d4a8df3a34b7392847d/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Manage Pending Hires:
https://help.sap.com/viewer/11888ce8119846ecab730236b601aeb4/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Contingent Workforce Management:
https://help.sap.com/viewer/7b2dec4ed4d9459f893cce6f5920528d/latest/en-US/2f555274e4ad4dcc92a427dcbfb3dc5e.html

Keywords

MDF Picklist, Migration, Manage Picklist, HRIS Sync, sync failing, no data sync, emailInfo, email, phoneInfo, phone info, homeAddress, PLT-58555, Picklist center, Picklist Migration , KBA , LOD-SF-EC-HRS , HRIS Sync , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-FWK-MDF , MDF Framework , Problem

Product

SAP SuccessFactors HCM Suite all versions