SAP Knowledge Base Article - Public

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

Symptom

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

Environment

All BizX non-picklist migrated instacne / Enabled with Picklist Managment

Resolution

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
  4. Copy option ID to this newly created column
  5. Insert a new column called parent – picklist ID after Column for parent option ID
  6. Create a VLOOKUP in the newly created parent – picklist ID as follows

  =VLOOkUP(J1,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

Keywords

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

Product

SAP SuccessFactors HCM Core 1811