SAP Knowledge Base Article - Public

2770433 - How To Resolve Picklist With Multiple Parent Error - Pre Picklist Migration

Symptom

  • You have faced the error Picklists with multiple parents in the Picklist Migration Conflicts Tool;
  • What are the steps I need to follow to get the error Picklists with multiple parents fix?

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
  • Metadata frameowrk (MDF)

Resolution

When a picklist has parent picklist options from more than 1 parent, it said to have multiple parent picklists. Like in the example below – picklist Fruit has parent options from 2 parent picklists

  1. Fruit-Harvest-Season
  2. Vegetable Harvest Season

Picture1.JPG

This is not allowed in MDF, hence before picklist migration all parent option ID’s in picklist must belong to ONLY 1 parent picklist.

**NOTE: This applies also to options that are in status DELETED, OBSOLETED, INACTIVE

All parent options must belong to single picklist like below.

Picture2.JPG

How to identify multiple parents in your legacy picklist?

  1. Export all picklist including system generated option ID’s
  2. Open in excel
  3. Insert a column before column A and calls as OptionId (as the example below in the column A);
  4. Copy option ID to this newly created column
  5. Insert a new column called Parent Picklist ID after Column for parentOptionID;
  6. Create a VLOOKUP in the newly created Parent Picklist ID (as the example below in the column J);

  =VLOOKUP(I2;A:B;2;FALSE) . Drag formula to all rows of column J

    7. In column B filter on the picklists that the pre-check reported multiple parents for

    8. In Column I &. J you can see parent option ID & parent picklist they belong

Picture4.JPG

  1. After you find two or more parent picklist that are assign to the same PicklistID, you will need choosing one of them to be the only Parent Picklist;
  2. After you choose, you should import the csv file to system again;

Keywords

Picklist Migration, MDF Picklist, Picklist Center, Picklist Management , KBA , LOD-SF-PLT-PCK , Picklist Management Issue , LOD-SF-MDF-PKL , Picklists , Problem

Product

SAP SuccessFactors HXM Suite all versions