SAP Knowledge Base Article - Public

2770481 - How to Fix Cyclic Picklist Errors Received During Precheck?

Symptom

Cyclical Picklist Relationship:

Picklist A has parent Picklist B

Picklist B has parent Picklist C

Picklist C has parent Picklist A

In this case Picklist A , B & C are said to be in a cyclical relationship:

Picture8.JPG

Environment

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

Resolution

Possible Correction

Picklist A has parent Picklist B

Picklist B has parent Picklist C

Picklist C  has no parent OR parent that is NOT picklist B or picklist A

How to identify cyclical picklists 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 cyclical relationship for

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

Picture7.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