Symptom
In filtering table report, there are certain fields that appears duplicate.
Picklist field appears several times when filtering the report
Environment
SAP SuccessFactors Recruiting Management
Cause
2 or more picklists are using same labels
id | effectiveStartDate | values.externalCode | values.nonUniqueExternalCode | values.parentPickListValue.externalCode | values.label.defaultValue | values.optionId |
custlocation | 01/01/1900 | location_a | location_a | Alpha | 123 | |
custlocation | 01/01/1900 | location_b | location_b | Bravo | 124 | |
custlocation | 01/02/1900 | location_c | location_c | Charlie | 125 | |
custlocation | 01/02/1900 | location_ax | location_ax | Alpha | 126 |
.
Resolution
When filtering the report, the system uses the unique value assigned in the field. For text and number field, the value is saved as it is. In picklist field, the system saved the option ID of the selected picklist. It might appear that they are duplicate but they have unique assigned option ID.
Keywords
KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem