2255189 - Unable to import the excel file in compensation executive review offline editing - Compensation Management

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 :

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