Symptom
After import the overall score based on the KBA 2076116, system notification indicated the import job failed, or find that the overscore is not updated accordantly after the import.
"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 Performance and Goals Management
Reproducing the Issue
- Go to Admin Center > Search Box > Import Overall Scores:
- Update the Template based on information from KBA 2076116 - Import Manual Overall Scores Configuration Guide - Performance Management
- Import the csv file:
- Get the notification indicating that the import failed.
Sample notification:
Subject: Import Overall Scores results
This is a system-generated mail regarding the status of the import of overall scores.
Import File Name: templatename.csv
Successful Imports: 0
Failed Imports: 1
Error encountered on these forms:
DOCUMENT_ID: 10001
- Unsupported rating score: for OBJECTIVE defined in CSV file for document Id 10001
Successful imports:
Cause
The import template may not contain all the necessary data.
This template is for uploading all the information, so it is necessary to fill the columns: DOCUMENT_ID, PERFORMANCE, POTENTIAL, COMPETENCY, OBJECTIVE, USER_ID.
Resolution
If only partial data must be imported, it is necessary to exclude the columns that do not have values populated.
For example, to import only Performance Rating, the file must be filled as below:
Keywords
Import Overall Scores, Import ratings, import score, import, csv, file, column, columns , KBA , csg_q , LOD-SF-PM-REP , Reporting & Analytics, Data Imports & Exports , Problem