2261877 - Duplicate Records and Canceled Positions shown in Position / Job family table - Advanced Reporting and Story Reports

• Duplicate Record showing in Position Table for each position code or to some of the position codes.
• A query is created with Position table to report all active positions and a canceled position is shown in the report.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HCM Suite

1. Create a query in Advanced Reporting or Story Reports;
2. Drag and drop the Position table;
3. See multiple rows per Position or for some Positions;
4. Add a filter by effectiveStatus in 'Active';
5. Preview the query;
6. There are still multiple rows for each Position.

The status field that we have to look is the "mdfSystemRecordStatus" for Advanced Reporting and "Record Status" for Story reports.

The positions have the status of PH. "PH" is the record’s history before workflow got approved, it’s again a status specific to workflow records.

Let's assume record has a value "A" and you created a workflow to change the record value to "B", once workflow is approved the record value will become "B".

To keep the history a record with "PH" is created with value as "A". Which causes the duplicates to appear in the reports.

1. To fix this please, edit the report under concern and then edit the Position Table;
2. Add a filter for the mdfSystemRecordStatus (Advance Reporting) / Record Status (Story Reporting) to match only the records with value 'N' (which refers to 'normal record');

You can find the below values in above mentioned field.

• N - normal record
• P - pending record
• C - correction
• D - soft deleted record
• PH - Is the record’s history before workflow got approved 

Please note if Position related fields (or any Foundation object fields) are selected from Job Information object in Story reporting and if there are duplicates when we preview Query, please add the objects directly to the query and filter for the desired record status (usually 'N').

2613024 - How to Filter only certain tables using Edit Restrictions in Advanced Reporting tables?

Canceled, Position, multiple, duplicate, rows, mdfsystemrecordstatus, report, Advanced, Reporting, Online, Designer, Canvas, Center, issue, sync, issue, Story position report, duplicate positions in story, PARS duplicate position records, Position story query, PAQueryDesigner , query filters , datasource   , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To