SAP Knowledge Base Article - Public

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

Symptom

You are inserting data into the fields startDate or endDate from a Background entity using Integration Center and the errors below are returning:

Mandatory value is missing for endDate for record userId:123

Reason: COE0027-Please add required properties in payload. Required properties startDate, endDate are missing. You can check which properties are required for an entity in Admin Center > OData API Data Dictionary or the entity metadata.. The row will not be processed for subsequent entities

If you try inserting the data via UI, this other error occurs:

The value 2020-12-01 for field startDate is not formatted correctly and cannot be displayed.

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
    • Integration Center

Cause

The system will expect the fields with name "startDate" or "endDate" to have a value with an exact date format, as these names are reserved to date type values. If you try to insert an incorrect date, the error will occur.

Resolution

You can change the name of your fields to something different than the reserved names, like "startdate" (all in lowercase) or just "start". This will make the field be able to receive any string values and the errors in Integration Center and UI will stop occurring.

Keywords

ic, integration center, background, reserved name, startDate, endDate, date type, string, vfld, api, odata, case sensitive , KBA , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HCM Core all versions