SAP Knowledge Base Article - Public

2811891 - Error trying to import hourly leaves for the same employee in the same date

Symptom

You are trying to import multiple leaved for the same employee on the same date as per Importing Existing Leave Requests into Time Off.

Also, according to the KBA 2332567 this should be possible however you are facing an error saying:  You cannot request time off from XX:XX to XX:XX because absences already exist between these times.

Environment

SAP SuccessFactors Employee Central (EC) - Time Off

Reproducing the Issue

  1. Go to Import and Export Data;
  2. Select Download Template and Employee Time;
  3. Fill the Template;
  4. Now Select Import Data and Employee Time;
  5. Select and File and click in Validate;
  6. Go to Monitor Jobs;
  7. See that the Import has Failed with the log "You cannot request time off from XX:XX to XX:XX because absences already exist between these times"

Cause

When importing multiple absences on the same day for the same employee there are some details you need to consider.

  1. Both leaves are of the same type (hours or Days);
  2. In Hourly leaves, you must fill all the relevant fields;

Resolution

Make sure that both leaves are hourly and that you are filling the following fields:

  • startTime: format must be 00:00:00;
  • endTime: format must be 00:00:00;
  • deductionQuantity: format is decimal so for example 1:30 hours are 1.5;
  • quantityInHours: format is decimal so for example 1:30 hours are 1.5;

See below example for these fields:

userId undeterminedEndDate startTime endTime deductionQuantity timeType.externalCode startDate endDate approvalStatus quantityInHours externalCode
Employee FALSE 08:00:00 12:00:00 3.75 YOURTIMETYPE1 07/04/2019 07/04/2019 APPROVED 3.75 YOURCODE
Employee FALSE 13:00:00 17:00:00 3.75 YOURTIMETYPE2 07/04/2019 07/04/2019 APPROVED 3.75 YOURCODE

Keywords

import multiple leaves import hourly leaves , KBA , LOD-SF-EC-TIM , Time-Off , Problem

Product

SUCCESSFACTORS BIZX CORE 1905