Use the TalentProfile.dat HDL file to load Talent Profile content like Performance Rating, Career Potential, Risk of Loss, and Impact of Loss into Oracle HCM. The ProfileCode is derived via SQL, and you must use the appropriate ContentTypeId, SectionId, and unique SourceSystemId for each profile item.
Use the GoalPlanAssignment HDL Delete Template to remove existing goal plan assignments for employees in Oracle HCM. Required fields include GoalPlanAssignmentId, AssignmentId, and GoalPlanId. A supporting SQL query helps extract the necessary data to prepare the HDL file. After deletion, you can update or recreate new goal plans with eligibility criteria.
This SQL query is designed to generate HDL-compliant assignment data lines for Oracle HCM Data Loader. It fetches assignment details for active employees and formats the data in HDL .dat file structure using the MERGE action for the Assignment business object.
To identify if an employee’s Profile ID is missing in Oracle Fusion HCM, you can cross-check profile migration records, validate Talent zip file contents, and analyze HDL profile loads. This ensures the profile was properly migrated and processed without errors.
This SQL query retrieves all Security Profiles (Person, Organization, Position, Country, LDG, Payroll, etc.) assigned to specific Data Roles in Oracle HCM. It helps in understanding how access control is structured based on roles and which security profiles are mapped for each role.
This document provides the HDL template and SQL query for extracting and loading Content Items related to Certifications in Oracle HCM Cloud. It maps fields such as ContentItemCode, ItemDescription, ContextName, and ContentTypeId from HRT_CONTENT_ITEMS_B, HRT_CONTENT_ITEMS_TL, and HRT_CONTENT_TYPES_B to the ContentItem.dat HDL format used for data migration or integration.
This SQL query generates HDL-formatted data to update Assignments and Work Terms in Oracle HCM. It retrieves key assignment attributes like job, grade, position, location, business unit, and legal employer for specified Person Numbers. The output includes METADATA and MERGE lines for HDL .dat file generation, supporting both Work Terms (ET) and Assignment (E) types.