SAP Knowledge Base Article - Public

2956919 - EmpJobRelationships cannot be upserted via OData

Symptom

During EmpJobRelationships full purge mode upsert, an error is being encountered "The Effective Start Date cannot be before Hire Date: Jan 10, 2018"

Environment

  • SAP SuccessFactors Employee Central
  • SAP SuccessFactors Integration OData

Cause

  • The current validation of Job Relationship are against start date field value in Employment Info and not Original start date.
  • If Start Date across Employee Central contains the true 'Hire Date' then that should be the user's initial 'Hire' record effective start date in all portlets like Job Relationship, Job Information, Addresses, Personal Information, etc.
  • No other user-based data should exist prior to this Start Date.

Resolution

  • The current validation of Job Relationship are against start date field value in Employment Info.

Employment Info is not effective dated, and the Start Date field is overwritten with each rehire on the same user ID. So, a rehired user has a start date in Employment Info which is after the date of his first hire - and a validation against this field would prevent you from creating e.g. Job Relationships for the first employment even though this is a valid use case.

  • Please use start date of the job relationship (or other effected portlet) record equal to or greater than current hired/rehired profile'e Employment Info Start Date value.
  • Engineering team are discussing about the current validations against the Employment Info date fields via an enhancement ticket.

Keywords

ECT-142220, EmpJobRelationships  upsert, "The Effective Start Date cannot be before Hire Date", EMPFILE_HRIS_EFFECTIVE_START_DATE_ERROR , KBA , LOD-SF-EC-JOB , Job Information , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Core 2005