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

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.

SAP SuccessFactors HXM Suite

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.

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.

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