Position Update on the employee assignment page using HDL

An employee's role was updated to a full-time, remote position within a business unit. The change, prompted by a positional shift, allows for remote work and follows a standard weekly schedule. The update adjusts long-standing work terms and assignment details, reflecting a significant, ongoing modification to employment conditions.


How to Upload Person Address with Custom Address Type using HDL

If you're facing issues while loading Person Address data via HDL, especially with custom address types—ensure that you're using unique Source Keys or a unique combination of Source System Owner and Source System ID.


Troubleshooting Errors in "Process HR Checklist" and Using HDL to Re-initiate Tasks

When the "Process HR Checklist" fails to allocate tasks due to an error, it is essential to check the log for error messages and fix the root cause. As a workaround, If you want to assign the checklist manually, like using HDL, please follow the mentioned steps.


Changing Person Number Using HCM Data Loader (HDL)

If you're unable to change the Person Number through the UI, you can use HCM Data Loader (HDL) to update the person number.


Updating the Work at Home Flag and Assignment Category HDL Template

This HDL template demonstrates how to update the WorkAtHomeFlag and AssignmentCategory in Oracle Fusion HCM Cloud using the Assignment and WorkTerms sections of Worker.dat. The structure supports assignment change actions, ensuring accurate classification of remote work setups and assignment attributes for employee records.


Creating Job and Job Legislative Data HDL Template

This HDL template outlines how to load Job and JobLegislative data into Oracle Fusion HCM Cloud. It includes fields like JobCode, Name, Job Family, Effective Dates, EEO Category, and Job Group. The structure ensures compliance with legislative requirements and accurate classification of job roles across the organization.


Creating Areas of Responsibility HDL Template

This HDL template defines Areas of Responsibility (AoR) in Oracle Fusion HCM Cloud. It captures details such as Responsibility Name, Type, Status, PersonNumber, AssignmentId, and Location. The structure enables accurate assignment of responsibilities like HR Representative roles, ensuring proper organizational mapping and role-based access in the HCM system.


Updating Rehire Recommendation Flag to N HDL Template

This HDL template illustrates how to load WorkRelationship data into Oracle Fusion HCM Cloud. It includes key fields such as PersonNumber, LegalEmployerName, WorkerType, Termination Dates, ActionCode, and ReasonCode. The template supports accurate termination processing and ensures smooth handling of employee lifecycle events within the HCM system.


Updating Assignment and WorkTerms Assignment HDL Template

This HDL template showcases how to load Assignment and WorkTerms Assignment data in Oracle Fusion HCM Cloud using Worker.dat. It includes a resignation action, capturing key fields like AssignmentId, WorkTermsAssignmentId, ActionCode, Effective Dates, and Status. This structured format ensures accurate data uploads, simplifies resignation processing, and maintains consistency in HCM records.


How to load the date of birth of an employee using HDL

File Name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth|CountryOfBirth|WaiveDataProtectFlag|CategoryCode MERGE|Worker|Vision|Test_123456789|01-08-2022||0140870390|NEW HIRE_EMP|01-08-2022|06-05-1992|LK|N|PER_EIT


Load Metadata File for Job Creation using HDL

Dat File Name: Job.dat METADATA|Job|JobCode|ActiveStatus|FullPartTime|EffectiveStartDate|Name|SetCode|JobFamilyName|SourceSystemOwner|SourceSystemId MERGE|Job|ABC-JB-010-2D|A||1951/01/01|Systems Administrator|ABCSUS|Security Systems Service, Maintenance & Repair|ABC_SS_US|ABC-JB-010-2D


Load metadata file for an Area of responsibility (AOR) using HDL

Dat File Name:  METADATA|AreasOfResponsibility|AsgResponsibilityId|ResponsibilityName|ResponsibilityType|StartDate|EndDate|Status|PersonId|PersonNumber|AssignmentId|AssignmentNumber|LocationCode|LocationSetCode


Load the metadata file for terminate an employee using HDL

Dat File Name: Worker.dat METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId


Load metadata file for Department using HDL

METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode MERGE|Organization|1951/01/01||ABC-AT-SS|ABC_SS_AT|ORG_AT_DPT_001|DEPARTMENT


Load the metadata file for created dff in the document of record

METADATA|DocumentsOfRecord|DocumentType|DocumentTypeId|PersonNumber|FLEX:PER_DOCUMENTS_OF_RECORD_DFF|dateOfAmendedDutiesNote(PER_DOCUMENTS_OF_RECORD_DFF=GB_MEDICAL___AMENDED_DUTIES_NOTE)|SourceSystemOwner|SourceSystemId MERGE|DocumentsOfRecord|Medical - Amended Duties Note|300000000000000|1000|US_MEDICAL_AMENDED_DUTIES_NOTE|2021/12/31|HDL|Medical1


Terminating or Inactivating User Accounts after Terminations HDL

Once a user has been terminated, however, the user accounts are still active then follow the steps below to inactivate their user account using HDL. Step 1 – Get a list of all terminated employees Step 2 – Prepare the .dat file METADATA|User|PersonNumber|Suspended


Load metadata File for Job Level using HDL

METADATA|Job|Name|JobId|JobCode|ActiveStatus|ApprovalAuthority|EffectiveStartDate|SourceSystemOwner|SourceSystemId|GUID MERGE|Job|HR Specialist|0101010|ABC-KB-0799-51B|A|0|1951/01/01|ABC_SSES_US|12121212|


Load Metadata File for update employee Job and Position using HDL

Dat File Name - Worker.dat METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|ActionCode


HDL or Metadata File for Worker

Dat File Name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonNumber|EffectiveStartDate|EffectiveEndDate|StartDate|DateOfBirth|ActionCode


Loading Department and Department Tree using HDL or metadata file

METADATA|DepartmentTreeNode|TreeStructureCode|TreeCode|TreeVersionName|DepartmentName|ParentDepartmentName MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|XYZ Department Tree|XYZ Tree of Departments|XYZ-IND-GG-NorthRegion|XYZ-IND-GG-NorthRegion-A&B-North