SAP Knowledge Base Article - Public

2620706 - Is there a Unique Key to identify duplicated records when reporting - Recruiting Management

Symptom

When building a report using Recruiting V2 when I select some columns the results show multiple rows for the same piece of data.

Environment

Recruiting Management

  • Reporting

Reproducing the Issue

  1. Go to Reporting;
  2. Click in New, Select "Report - Table";
  3. Select "Single Domain", and "Recruiting V2" for the domain;
  4. Select the columns: Application Date and preview the report;
  5. You can see now that the dates repeat a couple of times.

Cause

This happens because there are columns that are not select to display in the report, and even they are not displaying in the report there is data that is different between the records.

Resolution

There is not a tool or a data column available to identify which data can be showing duplicated or multiple row records for the same data, and which field can be causing this to occur.

So, if there are multiple rows of the same information, even with more columns selected, check back in the data which you are reporting to see if there is not an information that is registered multiple times in the database and guarantee that it is not a one to many relationship between the data.

This is an expected behavior.

See Also

2104500 - Duplicates in Ad-hoc - Recruiting Management

Keywords

Reporting, multiple records, duplicates, unique key , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors Recruiting all versions ; SAP SuccessFactors Workforce Analytics all versions