SAP Knowledge Base Article - Public

3283017 - The value 12345 for field xyz is not formatted correctly and cannot be displayed - Integration Center Error

Symptom

You are inserting data into the fields associated with a picklist from a Background entity using Integration Center and the errors below are returning:

UPSERT failed for the row with key: . Reason: The value 12345 for field school is not formatted correctly and cannot be displayed.. The row will not be processed for subsequent entities

If you try inserting the data via UI, you do not receive errors

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

Environment

SAP SuccessFactors HXM Suite

Cause

When upserting picklists, depending on it's type, you must either upsert the externalCode or the OptionID. Upserting the incorrect value, e.g. upserting externalCode instead of OptionID will make Integration Center through this error.

Resolution

If the current value that is being upserted in the picklist is externalCode, change it to OptionID and vice versa. To be able to do so, edit the mapping in Integration Center.

See Also

3006179 - Error when inserting data into startDate or endDate fields from a Background entity - Integration Center

Keywords

ic, integration center, background, reserved name, picklist, externalCode, optionid, string, vfld, api, odata, case sensitive
, KBA , LOD-SF-INT-INC , Integration Center , How To

Product

SAP SuccessFactors HXM Suite all versions