2638140 - Unable to Import Personal Information When Native Preferred Language Field Enable

You would receive an application error when Importing Personal Information.

The application error id would be accompanied by: Unknown is an invalid picklist value in import file or database for Native Preferred Language.

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

• Employee Central - Import Employee Central Data
• Employee Central- Personal Information

• Go To Import Employee Data
• Validate or Import Personal Information
• Result:In case use the attached file (20000 records), it failed with the following errors
• Error:  Unknown is an invalid picklist value in import file or database for Native Preferred Language.

Step 1: Review field Native Preferred Language

• View Field Native Preferred Language in Succession Data Model

<hris-field max-length="256" id="native-preferred-lang" visibility="Both">
  <label>Native Preferred Language</label>

<label xml:lang="en-US">Native Preferred Language</label>

<picklist id="language"/>

</hris-field

• View Field In Manage Business Configuration or BCUI:

Step 2: View Import threadpool size

Go to Admin tool- Company System and Logo Settings

Maximum threadpool size for Employee Central and Foundation data imports(maximum allowed is 5) = 10

Batch size for Employee Central and Foundation data imports(maximum allowed is 2000) = 500

Result: Wrong threadpool size

Step 3: EXport Legacy Picklist file

• Go to Admin Tool- Picklists Management
• select Export all picklist(s)
• Submit
• Download Export
• Filter Picklist: language

Result: Missing language picklist translations for language enable (Language Pack) in this system

Example  UK English: en_GB, Japanesse: ja_JP

Step 1: Maintain translations For all Language Picklist Enable in this system.

• See: 2254305 - How to modify an existing Picklist 
• Example SAP Master Picklist:

 

Special Note: 

• For Picklist Translation Best Practice Click: Here
• Base on Your Language Pack, Please Maintain The Translations For all Legacy Picklist Enable in this system

Step 2: View Import threadpool size

• Go to Admin tool- Company System and Logo Settings
• Set: Maximum threadpool size for Employee Central and Foundation data imports(maximum allowed is 5) = 5
• Set: Batch size for Employee Central and Foundation data imports(maximum allowed is 2000) = 50
• Please see EC Import Handbook:Employee Central Imports

Step 3: Validate or Import Personal Information record

• Go To Import Employee Data
• Validate or Import Personal Information

• 
  2618303 - Native Preferred Language field shows in Personal Information portal but not in Data Model
• 2315276 - Employee Central Implementation - Data Imports FAQ
• 2537488 - Best Practice for Setting a Picklist Value to Deleted
• 2254305 - How to modify an existing Picklist
• 2210202 - Is there any options available to Delete the old unused Picklist Values from the system

Native preferred language, Import data, Personal information, missing Picklist, Language, Language pack, Maximum threadpool size for Employee Central and Foundation data imports, Batch size for Employee Central and Foundation data imports , KBA , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC-PER , Person Data (All Person Data Types) , Problem

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core all versions