Symptom
When investigating a picklist export file in notepad++ you notice some records have no option IDs.
"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 HCM Suite
Reproducing the Issue
Sometimes records without option IDs can appear in the picklist export file. They cannot be deleted by setting status to 'Delete' and importing.
Cause
For the records without any option ID the preceding record is missing a quotation mark (") at the end of the line in notepad++.
Resolution
1. In my example you need to add the missing quotation mark in notepad++ for the record with option ID 9687. This record precedes the record with no option ID. Once you add the quotation, save and import the file. Please see screenshot for reference.
2. After adding the missing quotation mark and importing, you will then be able to delete the records that have no option IDs through the normal process.
Keywords
Blank option ID, Picklist file. , KBA , LOD-SF-PLT-PCK , Picklist Management Issue , Problem