SAP Knowledge Base Article - Public

2609563 - Event Name value is missing in Termination Reason table - Advanced Reporting

Symptom

  • The Event Name field from Termination Reason table is not pulling data for few terminated employees
  • Termination reason is blank for some terminated users
  • For most of the terminated employees the Event Name is showing data properly

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Cause

The reason why some users do not show up in Termination Reason table is because the view has custom logic, where a user's Termination Date (Employment Details) should be one day less than the Effective Start Date (Global Job Information). If the "start-date" of Job Information Termination record is on the exact same date as the Termination Date in the Termination Details, then this issue will occur.

termination.png

Resolution

Advanced Reporting is working as expected. The root cause of the "Tarmination Reason > Event Reason Name" is due to a data issue between the Start Date of the Job Information Termination record and the Termination Date in Termination Details. The Start Date of the Job Information Termination record should be 1 day later than the Termination Date in Termination Details.

As this issue cannot occur if the Termination was created via the UI, most likely the data was created incorrectly via Import or API. This can be further checked using a Person and Employment Audit report (which captures the source of the change).

You can resolve this data issue via the Job Information > History UI (manual correction to the Start Date).

For further gudiance, please contact the SAP Cloud Product Support > Employee Central team for further assistance.

Keywords

Event Name field Termination Reason table is not pulling data empty blank no record showing appearing some few terminated employee user Advanced Reporting realms report, advanced reporting, Termination Reason, termination, employee central, ec, , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

Product

SAP SuccessFactors Workforce Analytics all versions