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
- Login to the EC Instance
- Go Import Employee Data
- Select the "Addresses" option and then Incremental Upload option.
- Upload csv file for Addresses.
- Click on Validate import File Data
- An error message occurred
Result: DEU is an invalid picklist value in import file or database for country
Cause
- Go to Provisioning
- Export Country Specific XML for Succession Data Model
- In this case Select Germany or DEU
- 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