Symptom
Application Error occurred when generating Person and Employment (as of Date) report with column 'Employee Status'
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
2. Click on New then Select Report-Table > Click on Select
3. Choose Single Domain > Select the domain: Person and Employment (as of Date) report
4. Enter report details on the General Info > then Select the People that you want to be included on the report.
5. Select Columns : Choose Employee Status as one of your column under Job Information.
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