SAP Knowledge Base Article - Public

2575567 - RBP Gourp Membership not updating when defining group using picklist

Symptom

  • Group membership won't update when we define group with people pool.
  • Permissions group update doesn't work when we use custom field.
  • Role Based Permissions not updating.
  • Picklist won't work to define permission group. 

Environment

BizX Platform

Reproducing the Issue

  1. Admin Center
  2. Manage Permission Groups
  3. Select Permission Group
  4. Select People Pool
  5. Define the Pool by selecting a picklist value
  6. Done
  7. Click Update
  8. Notice that group membership has not updated.

Cause

The Custom Field values in the User Directory File for the Option ID's have leading zero's.

Resolution

Ensure that all Option ID's do not have leading zero's.

Opening a *.csv data file that contains leading zeroes with Excel will strip the zeroes by default.

Please follow below to check:

  1. Export the User Directory File from Admin Tools > Employee Export
     
  2. Save the file to your desktop
     
  3. Open Excel, DO NOT OPEN THE USER DATA FILE!!!
     
  4. Create a new blank workbook
     
  5. Click ‘Data’
     
  6. Hover over ‘Import External Data’
     
  7. Click ‘Import Data’. You want to import from a text file. Your‘Text Import Wizard’ may appear in some versions of excel.
     
  8. Verify that the ‘Delimited’ radio button is selected then click ‘Next’
     
  9.  Put a check mark in the box to the left of  ‘Comma’, since the delimiter in your file are commas.
     
  10. Click ‘Next’
     
  11. The first column should already be highlighted (If it is not highlighted then click once on the column header labeled ‘General’ over the first column.)
     
  12. Using the horizontal scroll bar at the bottom, scroll all the way to the right.
     
  13.  Hold down the ‘Shift’ key and click the last column header.
    This should highlight all columns
     
  14. Click the ‘Text’ radio button
    You should immediately see all column headers change to ‘Text’
     
  15. Click ‘Finish’
     
  16. Click ‘OK’
  17. Now you are able to make edits to the file
     
  18. When you have completed all updates you must save the file as a .CSV (Comma Separated Value)

Keywords

Role Based Permission, Group, Roles, People Pool, Picklist, Custom Field, Members, Leading Zero, csv, Option ID , KBA , LOD-SF-PLT , Foundational Capabilities & Tools , LOD-SF-PLT-PCK , Picklist Management Issue , LOD-SF-PLT-RBP , Role Based Permissions , Problem

Product

SAP SuccessFactors HCM Suite all versions