Executive review offline edit is not working. Getting the below error message while uploading the file.
Unable to import file. This might due to one of the following:
1. File is not in Excel Format.
2. File was not saved in earlier versions of Excel (Excel 97 -2003).
3. Original file was not exported from the system.
Compensation Management :
Reproducing the Issue
Export the file as excel and re-import the same file still not able to import the off-line edit file.
This issue occurs if customer is importing comp rating with text value(that can be ideally entered with a dropdown list driven by a rating scale in Excel export file). By design this is known limitation we cannot import the comp-ratings if the values are text and as of now we only support numerics.
Delete the comp-rating column and import the excel file and the issue would be resolved.
Executive review Import, Executive review Offline Edit Error, Offline edit. , KBA , LOD-SF-CMP-EXR , Executive Review , Problem