Symptom
When do executive review export, there is a data discrepancy, which is missing employees on the exported Excel file
(such as there are 1000 employees shown on the executive review page, but only 900 employees are exported)
Images and data taken from SAP internal systems, sample data, or demo environments. Any resemblance to real-world data is purely coincidental.
Environment
SAP SuccessFactors Compensation
- SAP SuccessFactors Variable Pay
Reproducing the Issue
1. Go to compensation tab - executive review
2. Choose the target template, open and click on the export button at the bottom
3. The number of employees in the exported file is not matching with the number of employees on the executive review page
Cause
There are some employees missing data in the fields, which could be caused by import history after form launch.
Since executive review export feature is aiming for data export, so those employees with no data will be ignored when export.
Resolution
Restore data before export the file.
First run bonus calculation job via provisioning, then update worksheet via Manage Worksheets -> Update Worksheet(s).
After that, check executive review again, the data will be restored and all employees could be exported.
See Also
2085304 - Executive Review - Overview - Compensation - SAP for Me
2084853 - Offline Edit via Executive Review Export to Excel in Compensation/Variable Pay - SAP for Me
Keywords
executive review export, missing employees, sf, success factors, CMP, VRP, export, executive, review, compensation, excel, offline, edit, variable, pay, Exr review export, Successfactors , KBA , LOD-SF-VRP-EXR , Executive Review , Problem