SAP Knowledge Base Article - Public

2575567 - RBP Group Membership not updating when Group is filtered with 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 doesn't work when defining permission group. 

Environment

SAP SuccessFactors HCM Core

Reproducing the Issue

  1. Go to Admin Center > Manage Permission Groups
  2. Select a Permission Group. 
  3. Select People Pool. 
  4. Define the Pool by selecting a Picklist value. 
  5. Click Update
  6. 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 Center > Employee Export
  2. Save the file to your deskto
  3. Open Excel but DO NOT OPEN THE USER DATA FILE (this is when the leading 0s get stripped). 
  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 column.
  14. Click the "Text" radio button. You should immediately see all column headers change to "Text"
  15. Click "Finish". 
  16. Now you are able to make edits to the file. 
  17. When you have completed all updates you must save the file as a .CSV (Comma Separated Value). 

Note: this is only one option to ensure leading 0's does not get stripped when editing a file. 

Keywords

Role Based Permission, Group, Roles, People Pool, Picklist, Custom Field, Members, Leading Zero, csv, Option ID, LOD-SF-PLT-RBP, rbp, group, people pool, , KBA , LOD-SF-PLT-RBP , Role Based Permissions , LOD-SF-PLT-PCK , Picklist Management Issue , Problem

Product

SAP SuccessFactors HCM Suite all versions