SAP Knowledge Base Article - Public

2659695 - Picklist Center Import Error - duplicate external code

Symptom

Failed to import or insert Picklist-Values with the error message: "Found more than 1 internal code for same external code (upper). The same externalCode record has been already created: [Picklist.Code]"

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SuccessFactors HCM Suite

Reproducing the Issue

  1. Import Picklist-Values via Picklist Center > Import/Export or Import or Export Data;
  2. Picklist value was not imported successfully;
  3. Download status report in Monitor Job;
  4. Below error message is shown in the report:
    • "1. Found more than 1 internal code for same external code (upper). The same externalCode record has been already created: [Picklist.Code]".

Cause

This error message means that duplicate external code is found in the import file or there is an existing external code already been used.

Resolution

Examine the “values.externalCode” column of the csv file to import to see whether same external code has been used more than once.

Or compare with the existing Picklist-Values to see if you are reusing an existing external code in the file you are trying to import.

NOTE: the External Code is a unique business key to identify the picklist value and it is case-insentitive, meaning that upper case "APPLE" will be regarded the same value as "apple" for example.

2019-07-04_16-05-14.png

See Also

Keywords

picklist center, picklist center import error, duplicate external code, MDF picklist , KBA , LOD-SF-PLT-PCK , Picklist Management Issue , Problem

Product

SAP SuccessFactors HXM Suite all versions