SAP Knowledge Base Article - Public

2342301 - Unable to Import Address Information with invalid Picklist format

Symptom

While importing user Address Information an error messsage occured.

Errror message: DEU is an invalid picklist value in import file or database for country

Environment

Employee Central

Reproducing the Issue

 

  1. Login to the EC Instance
  2. Go Import Employee Data
  3. Select the "Addresses" option and then Incremental Upload option.
  4. Upload csv file for Addresses.
  5. Click on Validate import File Data
  6. An error message occurred

Result: DEU is an invalid picklist value in import file or database for country

 

 

1country.png

 

Cause

  1. Go to Provisioning
  2. Export Country Specific XML for Succession Data Model
  3. In this case Select Germany or DEU
  4. Scroll down to field country for Germany or DEU 

 XML Country Specific XML for Succession Data Model:

 <hris-field max-length="256" id="country" visibility="both" required="true">

        <label>Country</label>

 <picklist id="country"/>

      </hris-field>

    </hris-element>

 

Issue: The list of values comes from the predefined picklist country. So do not add  Picklist to country

Resolution

Correct  and Import XML Country Specific XML for Succession Data Model as showing below:

 

 <hris-field max-length="256" id="country" visibility="both" required="true">

        <label>Country</label>

      </hris-field>

    </hris-element>

 

 

 

Keywords

Country Picklist an invalid picklist value in import file or database for country Country Specific XML for Succession Data Model Address   , KBA , LOD-SF-EC , Employee Central , Problem

Product

SAP SuccessFactors HCM Core 1605