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…
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…
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…
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…
List of all job families not associated with a Job:
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…
Use below SQL to get benefits relationship name and status for a worker:
In order to load person profile items, a person should have a profile code. There are two ways to create the profile code for a person record. It is advisable to load profile codes in bulk as part of data migration using HDL. But there are cases where a user will click on Talent Profile…
All recurring element entires are loaded/ created with an effective end date of 31-Dec-4712. But I have seen scenarios, where the business have requirements to end date an element entry as of a certain date. To achieve this in Bulk, one can use ElementEntry.dat HDL business object. Let us take an example, where an employee…
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…
There are many scenarios where the users don’t want to have Approve/ Reject buttons on the Bell Notifications or the notification received over email. This can be achieved quite easily using simple settings in BPM. To remove the Approve/Reject buttons from email:- Disable the “Make Notifications Actionable” option under the appropriate task. To remove the…
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…
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…
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…
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:
For requirements to add List of values to a DFF segments, one can create independent value set or a table based value set. For example, if you want LOV as your existing departments, then you can use a table based value set. But sometimes, you need to display one hard coded value “All” along with…
While defining absences, schedule hierarchy start point can be defined to tell the system from where to pick the working days for a person. Once the values are defined, you can use below query to validate if setup has been defined correctly:
Once a worker record is terminated, it is expected that the associated user account will get inactive. However, it depends upon the configuration on Enterprise Level and auto provisioning rules setup. If there is even on role assigned to user name, the user account will not get terminated in HCM. To help the business to…
There are scenarios when we want to delete a future dated row from an object. Please note that for objects like Positions/Locations etc which are date tracked, one can make use of HDL with SET command to delete the future dated row. Let us take an example, where we have below data on Position: Position…
Starting 22A, Oracle introduced a new field called “Employee Location”. https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/ghr/releases/22A/22A-hr-wn.htm#F21144 Any locations for which the value of the field will be selected as “Yes”, will be only available to be used in Manage Employment screen. This is a great feature to segregate locations which can be used on employee assignments vs locations which are…
