HDL · Payroll · Oracle Fusion HCM How to Bulk End-Date Element Entries Using HDL Using the ElementEntry.dat business object and the ReplaceLastEffectiveEndDate attribute to close out or clean up recurring element entries across your employee population — without triggering an unwanted date split. By default, every recurring element entry in Oracle Fusion HCM is…
-
-
HDL – Query to Extract Business Object Attributes List
HDL – Query to Extract Business Object Attributes List If you’ve ever worked with HCM Data Loader (HDL), you’ll know how useful the Business Objects reference page is in the UI — it shows you the Name, METADATA Attribute, Data Type, Key Type, Required, Lookup, and Description for every attribute of a business object (see…
-
HDL – Mass DELETE Document Record Attachments
Post refresh, the attachments from source environment gets copied to target environment. For data security, it is highly recommended to purge the attachments in lower environments. Oracle’s standard data masking feature doesn’t remove any attachments from the UCM. In order to overcome this problem, I have created a BIP report which will pull details of…
-
HDL – HDL to Load US EEO Information against location
There are many legislative required attributes defined against location object in HCM. These attributes are setup as EFF in Oracle fusion. These EFF attributes are protected against any updates. One of the requirements is to bulk upload data against these EFF attributes and HDL can be used for this. Below is a sample HDL to…
-
HDL – Loading and Extracting ‘Reporting Information’ calculation card
For US legislation, Reporting Information calculation card is mandatory calculation card. CalculationCard.dat HDL is used to upload the Calculation Component Details: In this example, we will prepare a sample HDL file to upload “Corporate Officer” component value and set it to “Not a Corporate Officer”. To create a calculation component details, below three Metadata’s should…
-
HDL – Send notifications when loading participants in performance document
Whenever doing mass upload of participants in a performance document, there may be a need to send a notification message to the participants. To load participants, you need to use PerfDocComplete -> Participant business object. However, if the data is loaded without using “Message” attribute in Participant business object, no message will be sent to…
-
HDL – Convert Contingent Workers to Workers
There are scenario’s where customers want to convert their non permanent staff to permanent staff in bulk or vice versa. In HCM terminology, this causes changes in system person type of a person. Let us take an example where a customer wants to hire all the contingent workers working in the company as permanent staff….
-
HDL – Sample file to upload Department DFF attributes
Sample file to upload/update/correct DFF values on department using User Keys:
-
HDL – Update Assignment Attributes with User Keys
Below is an example of updating assignment category using only user keys: If you want to use surrogate IDs/ integration keys, then you can check the below post:
-
HDL – Sample file to load Licenses and Certifications to employee profile
Sample file to load licenses and certifications to employee profile: Sample useful queries: Query to get source system ID and owner details for existing profiles: Query to get profile id for a worker:
-
Security – Deactivating Users in Bulk
With the security concerns regarding access to Oracle HCM applications, I have seen many customers asking for a way to restrict access to a particular DEV/TEST environment having unmasked data. One option in such scenario’s is to keep only the admin user accounts active in the particular environment and deactivate all other user accounts. This…
-
BIP – Extract Address Style Format Information
You use “Manage Address Formats” task from Setup and Maintenance to define the address style for a particular country. Oracle provides a lot of address format for various countries out of the box. You have the capaibility to customize the address formats as per customer requirement. For example, you can search for all available address…
-
HDL – Sample file to update Grade name and Grade Step Name
File for Grade Name change: File for Grade Step Name change: Save the files as Grade.dat and upload them.
-
HDL – Sample HDL file to End Date Position Valid Grades
There can multiple grades assigned as Valid grade at Position level or Job level. However, there is no direct way to end date the valid grades in bulk. You can end date a valid grade from responsive UI. But it will be a lot of manual effort. You can search for Position and then navigate…
-
HDL – Sample HDL files load Content Items
To bulk upload items catalogs in HCM profiles, you can use ContentItem.dat. Each of the template have certain mandatory attributes like Context Name, Value Set Name or Value Set Id: S0, before you start preparing the file, you need to have below information handy: The values 3000122xxxxx aren’t valid for ContentItemValueSetId. You can get the…
-
HDL – SET PURGE_FUTURE_CHANGES Command
In this article, I will talk about affect of using SET PURGE_FUTURE_CHANGES in HCM Data Loader file. HCM use date tracked functionality for most of the objects in HCM, be it work structures, worker or payroll related objects. I have seen many scenarios, where I had to go in past and make an update on…
-
HDL – Sample file to load absence reason
Absence reasons can be loaded in BULK using AbsenceReason.dat. BaseName is a mandatory attribute in the file. If BaseName is not passed, user get below error: BaseName has to be provided in UPPER CASE concatenated with an underscore (_) and legislation code. Example: TEST ABSENCE REASON_US If the above format is not followed, HDL throws…
-
HDL – Sample HDL to Load Agents information in ORC
HCM Data Loader supports bulk uploading for Agents for Oracle recruiting cloud. Currently, there is no HDL support for loading Agencies. And idea is already submitted for same: https://community.oracle.com/customerconnect/discussion/666039/hcm-data-loader-support-for-loading-agencies-in-recruiting-cloud#latest Coming to Agents bulk upload, you can used below HDL:
-
-
BIP – Query to find attachment details for related materials
Learning admin can attachments on offering level for different roles – Admin/ Employee etc. In case, you need to extract the attachment details for an offering, below BIP can be used: Output: