SAP Knowledge Base Article - Public

2642456 - Terminated Employee Shows as Incumbent in Vacant Position - Advanced Reporting

Symptom

A terminated employee is showing up as an incumbent within a vacant position

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

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Workforce Analytics
  • Advanced Reporting

Reproducing the Issue

  1. Go to Org Chart
  2. Position Org Chart
  3. Search for the Position
  4. Check that there is no Incumbent

    org.png

  5. Now go to Advanced Reporting and create a new Position report
  6. Filter by the position
  7. Add some fields from Incumbent(s) table, including the employee status
  8. Notice the employee status is terminated but it is still showing as incumbent for this position:

    query.png
  9. Go back to Position Org Chart and check the Incumbent History
  10. See the terminated employee is the last incumbent of this position:

    history.png

Cause

The incumbent table pulls information from the EC Job Information table, which just searches for users who have this position listed in their last record

Resolution

  • It is expected that a user who was the incumbent of a position and was then terminated, leave the position vacant
  • However, although terminated in Job Information, the user has the position maintained in the last record
  • Therefore, even if the position is vacant, the Incumbent information will be displayed

Possible Workarounds

  • Use the 'Vacant' / 'To be Hired' / 'To be recruited' field from the Position table

or

  • Add filters to one of the 'Incumbent Employee Status' fields to exclude terminated employees

See Also

KB article 2261877 - Duplicate Records and Canceled Position shown in Position table - Advanced Reporting

Keywords

SF, success factors, WFA, ANA, RPT, report, inactive, user, center, canvas, ORD, Online, Designer, sync, issue , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HCM suite all versions ; SAP SuccessFactors Workforce Analytics all versions