In this article, we will go through steps to create and manage work schedule assignments using HDL
Goal
HDL files to create work schedule assignments for employees
Solution
ScheduleAssignment.dat file to be generated as per below guidelines:
METADATA|ScheduleAssignment|ScheduleName|StartDate|EndDate|ResourceType|PrimaryFlag|DepartmentName|InternalLocationCode|BusinessUnitName|JobCode|LegalEmployerName|AssignmentNumber|WorkTermsAssignmentNumber|SourceSystemOwner|SourceSystemId
MERGE|ScheduleAssignment|Work_Time|2017/12/10|2019/01/01|ASSIGN|Y||||||E1000|ET1000|HRC_SQLLOADER|ScheduleAssignment_E1000
Schedule Names can be fetched from “Define Work Schedules” page or by using the below SQL:
select zsstl.schedule_name,
zssb.effective_from_date,
zssb.effective_to_date
from
ZMM_SR_SCHEDULES_TL zsstl,
ZMM_SR_SCHEDULES_B zssb
where language =’US’
and source_lang = ‘US’
and zsstl.schedule_id = zssb.schedule_id
and trunc(sysdate) between effective_from_date and effective_to_date
Works for Oracle Cloud Versions
Oracle Fusion Global Human Resources Cloud Service – Version 11.12.1.0.0 and later