Symptom
When running a integration center job to import picklist values, you get the following error: XXXX is an invalid picklist value in import file or database for XXX.
Environment
SAP SuccessFactors HXM Suite
- Integration Center
Reproducing the Issue
- Execute the Integration Center job.
- Ensure that the picklist field only contains Chinese labels.
- Set the job executor's system language to English, then the locale of executor was changed to en_US automatically.
- After importing picklist, observed the error message: "XXXX is an invalid picklist value in import file or database for XXX".
Cause
The absence of English labels for the picklist field causes the issue.
The job executor's system language was previously set to English, as a result, the locale was changed to en_US, but there is no English label existing for the picklist, so the error occurred.
And when the system language is changed back to Chinese, the error gone. Because the Chinese label is already existing.
Resolution
- Ensure that the picklist field includes both English and Chinese labels.
- When running jobs, verify that there is matched label for executor's locale.
Keywords
integration center, picklist, relationshipType, invalid picklist value, import file, database error, cascading picklist, system language, English labels, Chinese labels, job execution error, locale, en_US, zh_CN , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , How To
SAP Knowledge Base Article - Public