SAP Knowledge Base Article - Public

2659695 - Picklist Center Import Error - duplicate external code

Symptom

Failed to import or insert Picklist-Values with below error message.

"Found more than 1 internal code for same external code (upper). The same externalCode record has been already created: [Picklist.Code]"

Environment

SuccessFactors HCM suite

MDF Picklist

Picklist Center

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 that 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.

MDF External Code.png

See Also

https://help.sap.com/doc/84e9c4c5762f4655999ab2dd3d6e6563/1805/en-US/SF_PLT_Managing_Picklists_Admin.pdf

Keywords

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

Product

SAP SuccessFactors HCM Core 1805