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.