SAP Knowledge Base Article - Public

2744830 - Picklist file contains blank option IDs

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.

Missing quotation mark.png

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

Product

SAP SuccessFactors HCM Suite all versions