SAP Knowledge Base Article - Public

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

Symptom

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.

Import_Error.PNG

Environment

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.

Cause

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.

Resolution

Delete the comp-rating column and import the excel file and the issue would be resolved.

Keywords

Executive review Import, Executive review Offline Edit Error, Offline edit. , KBA , LOD-SF-CMP-EXR , Executive Review , Problem

Product

SAP SuccessFactors HXM Suite all versions