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…
-
-
Configuration – Disabling MFA Oracle Fusion OCI Console
Multi-Factor Authentication (MFA) is enabled by default for Oracle Fusion Applications and is enforced through the sign-on policy of your Identity Domain in Oracle Cloud Infrastructure (OCI). While MFA is strongly recommended for production environments, there are scenarios — such as sandbox or test environments, break-glass access, or troubleshooting — where you may need to…
-
BIP – Query to find legal entity registration number
BIP – Query to find legal entity registration number in fusion – MSPL Home › Fusion HCM › Reports › Overview In Oracle Fusion HCM, each Legal Entity is assigned a registration number that uniquely identifies it within a Payroll Statutory Unit. This registration number is stored at the establishment level and linked via the…
-
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…
-
Step-by-step guide: Customizing the sign-on page after an Oracle IAM upgrade
S Configuration Guide Mandeep Gupta · 17 June 2026 · Oracle Fusion HCM After an IAM upgrade in Oracle Cloud, your sign-on page branding (logo, identity provider) may need to be reconfigured. Follow these steps to restore or update your custom sign-on experience. 1 Log in to Oracle Cloud Console. 2 Navigate to Applications and…
-
Configuration – Updating Legal Entity Addresses in Oracle Fusion
This article explains how to export, modify, and re‑import legal entity address data using the Manage Legal Addresses task in Oracle Fusion. Overview Oracle Fusion allows administrators to update legal entity addresses by exporting the existing address records, editing them in a CSV file, and importing the updated data back into the system. This process…
-
BIP – List of departments associated with a specific business unit
In Oracle Fusion HCM, a business unit can be linked to either a common reference data set or a specific one. When associated with a specific reference data set, the business unit gains access to departments defined within that set, as well as those available in the common reference data set. The SQL query provided…
-
BIP – Extract Grade Ladder, Grade and Step details
Below query can be used to extract grade ladder, grades in ladder and step details of a grade.
-
BIP – Report to extract BIP scheduled jobs
I have designed below query to extract the schedule of a BIP submitted jobs which is not available directly. Replace the job name attribute with your job name or run it for all:
-
-
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…
-
BIP – Deliver an encrypted file on UCM server
There is a common requirement to send encrypted output files to UCM server as part of outbound integrations in Fusion HCM. By default, FA_UCM_PROVISIONED is delivered as ‘Content Server’. But the delivered content server, doesn’t have the encryption enabled and there is no option to enable encryption on the delivered content server. So, the solution…
-
BIP – Query to extract worker manager job name
Below SQL query below shows how a job name can be pulled for a worker’s manager. The SQL can be easily modified to include further employment related attributes for worker’s line manager.
-
BIP – Find list of message sent from Oracle Alert
Alert composer a very powerful and useful tool to configure and sent notifications to the users. However, it is very important for business to know the list of receipients for each message. I have tried to built a query to get these details. From alert history, one can find the emails triggered but it doesn’t…
-
HDL – How to encrypt a file locally
gpg –import fusion-key_pub.asc gpg –cipher-algo AES-256 -r fusion-key –encrypt JobFamily_userKeys.zip ** You can use any other folder as well. Just you need to point to the right directory. Encrypted File Name – JobFamily_userKeys.zip.gpg
-
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:
