SAP Knowledge Base Article - Public

3729212 - Picklist Error: "XXXX is an invalid picklist value in import file or database for XXX" - Integration Center

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

  1. Execute the Integration Center job.
  2. Ensure that the picklist field only contains Chinese labels.
  3. Set the job executor's system language to English, then the locale of executor was changed to en_US automatically.
  4. 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

  1. Ensure that the picklist field includes both English and Chinese labels.
  2. 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

Product

SAP SuccessFactors Platform all versions