SAP Knowledge Base Article - Public

3302823 - Duplicate data in PM reports

Symptom

In Ad-hoc reports duplicated rows of data is visible for the same subject, when the rating columns are included even with Enable Distinct option enabled 

Environment

  • SAP SuccessFactors Performance Management
  • SAP SuccessFactors Calibration
  • Ad Hoc reporting

Reproducing the Issue

  1. Go to Report Center
  2. Create a new table report
  3. For this example add Subject Username, Current Route Step name, Status, Overall Objective Rating, Overall Competency Rating, Overall Performance rating fields to the column
  4. Tick the 
  5. The report will return several rows although you expect to have only one
Subject UsernameCurrent Route Step NameStatusOverall Objective RatingOverall Competency RatingOverall Performance Rating
User1CalibrationModify Stage2UnratedUnrated
User1CalibrationModify Stage2Unrated5
User1CalibrationModify Stage22Unrated
User1CalibrationModify Stage225
User1CalibrationModify StageUnratedUnratedUnrated
User1CalibrationModify StageUnratedUnrated5
User1CalibrationModify StageUnrated2Unrated
User1CalibrationModify StageUnrated25

Cause

  • Issue occurs when HR (or Calibration administrator) is sending the form to the next step at the same time, when the employee is editing the form
  • Two operations occurring at same time: form force routing operation and form auto-save operation
  • This results in dirty data in feedback table

Resolution

Resolution: report issue to Product Support

Workaround: duplicate records will disappear, after the form is routed to the next step, then back to the original step

Keywords

sf, success factors, ad hoc, center, duplicate, Performance Management, pm , KBA , LOD-SF-PM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HXM Core 2211