2766444 - Unable to Delete Work Schedule via Import

Error "Delete Operator is only supported for a base entity template" is encountered during deletion of work schedule via import

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 Employee Central
• SAP SuccessFactors Employee Central Time Off

1. Go to Admin Center>Import and Export Data then export all work schedules excluding dependencies then download the export file in Admin Center > Monitor Job.

2. Enter Delete under Operator column for each work schedule record to be deleted.

3. Reimport the work schedule file in Admin Center>Import and Export Data then check the results from Admin Center > Monitor Job. Error is received and work schedule records cannot be deleted.

Import file contains one or more association columns below, which are not part of the Work Schedule base object/entity:

• workScheduleDayModels.day
• workScheduleDayModels.category
• workScheduleDayModels.dayWorkingHours
• workScheduleDayModels.hoursAndMinutes
• workScheduleDayModels.dayModel.externalCode
• workScheduleDays.day
• workScheduleDays.hoursAndMinutes
• workScheduleDays.workingHours
• workScheduleDayModels.segments.externalCode
• workScheduleDayModels.segments.startTime
• workScheduleDayModels.segments.endTime
• workScheduleDayModels.segments.duration
• workScheduleDayModels.segments.category

As 'Delete' operator can only be used for base entity objects, validation error message will be received when trying to delete association/child records together with the records of base entity, Work Schedule in this specific case.

Remove the association columns from the work schedule import file. By deleting the base object work schedule record, corresponding association records for the work schedule are also deleted accordingly.

Note: Base columns may vary depending on the model used for the work schedule which needs to be deleted. Below are the only columns which should be present in the work schedule import file based on model of the work schedule:

Simple

• externalName (External Name)
• searchString (Search Field)
• individualWorkSchedule (Is Individual Work Schedule)
• modelCategory (Model)
• averageHoursPerDay (Average Hours Per Day)
• averageHoursPerWeek (Average Hours Per Week)
• averageHoursPerMonth (Average Hours Per Month)
• averageHoursPerYear (Average Hours Per Year)
• averageWorkingDaysPerWeek (Average Working Days Per Week)
• flexibleRequestingAllowed (Flexible Requesting Allowed)
• startingDate (Starting Date)
• country (Country)
• externalCode (External Code)

Period

• externalName (External Name)
• searchString (Search Field)
• individualWorkSchedule (Is Individual Work Schedule)
• modelCategory (Model)
• timeRecordingVariant (Time Recording Variant)
• shiftClassification (Shift Classification)
• userId (User)
• averageHoursPerDay (Average Hours Per Day)
• averageHoursPerWeek (Average Hours Per Week)
• averageHoursPerMonth (Average Hours Per Month)
• averageHoursPerYear (Average Hours Per Year)
• averageWorkingDaysPerWeek (Average Working Days Per Week)
• startingDate (Starting Date)
• country (Country)
• externalCode (External Code)

Schedule

• externalName (External Name)
• searchString (Search Field)
• individualWorkSchedule (Individual Work Schedule)
• modelCategory (Model Category)
• periodModel  (Period Model)
• startingDate (Starting Date)
• country (Country)
• externalCode (External Code)

KBA 2236017 - Mass Deletion of MDF Data via Import

KBA 2315354 - Work Schedule Import Template Error

Employee Central Time Off Implementation Guide: Importing Work Schedules

Mass Delete, Work Schedule, Delete Operator, work schedule import error , KBA , LOD-SF-EC-TIM , Time Off , Problem