Symptom
While reporting on the field "Source of Record" in table report, field returns only the option ID of the picklist, and not the label.
Environment
SAP SuccessFactors Employee Central
Reproducing the Issue
- Configure the Field "sourceOfRecord" in employmentInfo under Manage Business Configuration
- Go to Reports Center
- Create a Table report, selecting, for example, type "Person and Employment Info(As of Date)"
- Select column "Employment Details Source of Record"
- Generate report and see that the value displayed is the option ID, not the label.
Cause
This is the designed behavior.
Resolution
Option ID is the only value available for this field in Table report. It is not planned to adjust this behavior and display the label.
Keywords
ECT-136974, adhoc, ad hoc, table report, source of record, employment details, employmentInfo, person and employment info, person and employment as of date, as of date , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC-EMP , Employment Information (Employment Details) , Problem