SAP Knowledge Base Article - Public

2927171 - Duplicate Country Values When Filtering by Candidate Country in Adhoc Reporting


When creating an ad-hoc report on candidate information and filtering by candidate country, we see duplicate values for some countries.


SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1. Create an ad-hoc report and add in candidate information. For example First Name, Last Name and Country
  2. Now try to filter the report by country
  3. You will see duplicate countries when selecting the appropriate filter


This is caused by the anonymize attribute of the country field in the candidate profile template.

If the anonymize attribute is set to false on the candidate profile template for the country field, when anonymizing candidates, the system will change the candidate country value to the option ID for that picklist value in the back-end.

However, as the system will not show an option ID in the UI, it will then display one label for the anonymized candidates with this country value and another label for the active candidates with this country.


To avoid this issue, the anonymize attribute will need to be set to true for the country field in the Candidate Profile Template so that the country value is anonymized with the candidate. Otherwise, the system will display two values in reporting - one for the anonymized candidates who have the option ID for their country in the back end and one for the active candidates in the system.

Please note, if the anonymized attribute is changed from false to true in the CPT, this may not affect already anonymized candidates.

See Also

2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products


KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem


SAP SuccessFactors Recruiting all versions