SAP Knowledge Base Article - Public

2712000 - Application Error when selecting Employee Status Column in Adhoc Report

Symptom

Application Error occurred when generating Person and Employment (as of Date) report with column 'Employee Status'

report.png

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 Employee Central

Reproducing the Issue

1. Navigate to Reporting

reporting.png

2. Click on New then Select Report-Table > Click on Select

table.png

3. Choose Single Domain > Select the domain: Person and Employment (as of Date) report

domain.png

4. Enter report details on the General Info > then Select the People that you want to be included on the report.

general info.png

peoplr.png

5. Select Columns : Choose Employee Status as one of your column under Job Information.

columns.png

6. Save the report then Click on Preview.

Cause

The "emplStatus" field is enabled or visible in Succession Data Model under Job Information.

Resolution

Remove or change the visibility of the "emplStatus" field to "none" in Success Data Model under Job Information. This field should not be visible on the instance for it is causing duplicate columns to be formed in the query and ambiguity error which will occur if you select any column from Job Information.

Keywords

ECT-78016, fingerprint=31cd4951e3e522a63c3fe88f4e6648e9f5e5c405, adhoc report error, person and employment (as of date) report, error in adhoc report, report, error in report, application error in adhoc report , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors Employee Central all versions