HDL – Sample HDL to Update User Table value
SQL Query to extract data for a particular value of a user table: Sample HDL:
-
-
BIP – HDL to update Grade Rate values
SQL to extract data in HDL Format: Sample HDL:
-
-
-
HDL – Query to generate worker email in HDL format
Sample HDL File:
-
HDL – Sample file to cancel Pending Worker Work Relationship
In case, you want to cancel work relationship of a Pending worker, below HDL can be used. Make sure to pass CancelWorkRelationshipFlag as Y. Sample HDL: You can extract the relevant Ids using below SQL:
-
BIP – Extract Absence Entry data in HDL Format
The below query extracts the minimum required attributes for absence entry update. In the current example, the absence status is updated to Withdrawn. You can make the changes as per your need: Sample HDL File:
-
-
HDL – Sample HDL to load rehire Workers
Below is the sample file (tested on an older version) to load rehire worker records but the structure should remain same. Few attributes may be deprecated now, so you may get an error. Please remove those and it should work fine.
-
HDL – Sample HDL file to update Organization DFF
Use any of the below formats of Organization HDL to update descriptive flexfield attribute: Using Surrogate IDs: Using User Keys: Version Validated :- 21D
-
-
HDL – Sample file to delete element eligibility
HDL supports deletion of element eligibilities. You can make use of PayrollElementDefinition business object. Child object ElementEligibility supports create, update and delete operations. You can create a simple BIP query to extract the requisite data and create an HDL file out of it: Sample HDL file: Sometime you may get an error that You can’t delete…
-
HDL – Sample HDL to load Performance Rating
Historical performance ratings can be loaded into Worker Talent Profile using TalentProfile.dat business object. Below is the sample HDL (enhanced profiles (v2)), to load performance rating data: In order to make the loaded performance rating visible in UI, Source Type and Qualifier ID should be passed. Values of source type and qualifier Id depend upon…
-
HDL – UCM Connection Error (HRC – 1035375)
In rare cases, while uploading the HDL file from Data exchange results in HRC-1035375 – A connection to the WebCenter Content Server Couldn’t be established. Resolution to this error is to raise an SR with Oracle support and ask them for OID services bounce.
-
BIP – Query to extract Actions.dat data
Many a time there is a requirement to update/change the existing actions and actions reasons usages. Doing this manually in UI will become a cumbersome process for multiple actions and may lead to human errors as well. For this, HCM Data Loader can used to update the changes using Actions.dat file. Use the below SQL…
-
HDL – Loading Classroom Resources in Bulk
HCM Data Loader object ClassroomResource can be used to bulk upload classroom resources in Oracle Learning Cloud. Existing locations created as part of Global HR can also be designated as classroom resources. Below is a sample file to upload classroom resources using HDL: Once the data is loaded successfully, you can verify the results from…
-
HDL – Sample File to DELETE documents of Record
Use the below query to extract document of record data which should be deleted. You can add additional filters by adding person numbers. Query for Person Number and Document Type: Sample HDL File:
-
HDL – Update Goal Weight
Goal Weightage can be updated using GoalMeasurement metadata in Goal business object. First, we need to extract the uploaded measurements. Use the below query to extract the details: Save the data in Goal.dat HDL file. Update the target value as required. Save the .dat file and upload. Sample HDL:
-
Extract – Loopback Inbound Extract
Often in Cloud HCM, we encounter situation(s) where we need to update some information at worker assignment, post worker creation as this information was not available at the time of hiring an worker. One such example could be Employee category. Let’s take a hypothetical example, employee category should be auto populated based on worker Job….
-
HDL – Delete custom Action Reason Usages using HDL
Actions and Action Reasons are very important part of any Cloud HCM implementation. Oracle provides a large number of actions and action reasons out of the box. But if needed additional actions and action reasons can be created from UI as well as using HDL. Each action is tied with an action type. Please note…