Symptom
- An error occurs when updating an existing FOEventReason via OData API.
- Error message: "XXX is an invalid picklist value in import file or database for Event., XXX is an invalid picklist value in import file or database for Employee Status."
- The same error can occur when importing Event Reason via the Import Foundation Objects tool if the Event and Employee Status fields are omitted.
Environment
- Product: SAP SuccessFactors Employee Central
- Foundation Objects (Organisation, Pay and Job Structures)
Reproducing the Issue
- Prepare an OData API upsert to update an existing FOEventReason, providing only externalCode, startDate, name, and status, while omitting the Event and Employee Status fields.
- Execute the upsert request.
- Observe the error: "invalid picklist value in import file or database for Event/Employee Status" and an httpCode 500.
- Optional replication via UI: Use Import Foundation Objects > Event Reason > Incremental Import with a file that omits the Event and Employee Status columns and validate/import to see the same error.
Cause
Resolution
The solution of this issue is currently under investigation. Please follow this KBA for updates.
- As a temporary workaround, include both Event and Employee Status in the OData upsert payload or import file when updating FOEventReason.
- Provide the picklist label values (not picklist option IDs) for Event and Employee Status.
- If using OData, ensure the Event and Employee Status properties are present with valid labels mapped to active picklist options.
- Refresh the OData metadata in the client/integration tool and retry the operation.
- If issues persist after applying the workaround, validate the same data via the Import Foundation Objects tool to confirm behavior and adjust values accordingly.
See Also
Keywords
KI1H2026, INC27554332, odata api, foeventreason, event reason, invalid picklist value, picklist label, employee status, event, import foundation objects, upsert, mdf, httpcode 500, odata metadata, option id, picklist validation, incremental import , KBA , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , Known Error
Product
SAP SuccessFactors Employee Central all versions
SAP Knowledge Base Article - Public