Fusion HCM Data Loader: Work Schedule Assignment Load Error - "You can select only 1 schedule as primary for a specific date range." (Doc ID 2945340.1)

Last updated on JULY 23, 2024

Applies to:

Symptoms

Employee Work Schedule is being updated using - ScheduleAssignment Business Object to cater to the use case below-
1. Updating the existing work schedule(WorkSchedule1 - that was effective for the period 01-01-2022 to 31-12-4712) with the new end date from as one day prior to new work schedule start date(i.e. 31-01-2023 considering the new schedule starts effective from 01-02-2023)
2. Creating the new work schedule with effective new start and end date(WorkSchedule2-effective from 01-02-2023 till 28-02-2023)
3. Any future work schedule as applicable(WorkSchedule1 - for any future date for period effective from 01-03-2023 till 31-03-2023)).

Sample HDL failing - 

My Client Groups> Data Exchange > Import and Load Data > ScheduleAssignment.dat 

METADATA|ScheduleAssignment|AssignmentNumber|StartDate|EndDate|ResourceType|PrimaryFlag|ScheduleName|SourceSystemOwner|SourceSystemId|ScheduleAssignmentId

MERGE|ScheduleAssignment|E****|2022/01/01|2023/01/31|ASSIGN|Y|WorkSchedule1|||300000********

MERGE|ScheduleAssignment|E****|2023/02/01|2023/02/28|ASSIGN|Y|WorkSchedule2|ZZ_SOURCE_OWNER|SCHED1|

MERGE|ScheduleAssignment|E****|2023/03/01|2023/03/31|ASSIGN|Y|WorkSchedule1|ZZ_SOURCE_OWNER|SCHED2|

LOAD failed with Error Message - "You can select only 1 schedule as primary for a specific date range."

Changes

 NA

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.