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:
-
-
-
BIP – Extract Job details with Job Family and Job Function details
List of all job families not associated with a Job:
-
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 – Query to get Benefits Relationship details
Use below SQL to get benefits relationship name and status for a worker:
-
BIP – Error Exception happened when delivery document to wcc
Many a times when the reports are delivering the content to UCM server, we get below error: In this case look at the password for account used to connect to UCM server. If the password is reset make sure it is updated at the UCM connection as well.
-
HDL – Loading Person Profile Items
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…
-
HDL – Sample file to end date element entry value
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…
-
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.
-
Approvals – Remove Approve/ Reject buttons from Notifications
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…
-
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…
-
BIP – Query to extract adjustment reasons attached on accrual Plan level
You can attach multiple adjustment reasons on accrual plan level. You can create any new custom adjustment reasons and add them in a lookup – ANC_ABS_PLAN_OTHER_REASONS. Once the reason is added in the lookup, you can navigate to Absence Plans. You can choose the newly added lookup code under “Enteries and Balances” tab. Once the…
-
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:
-
-
Configuration – Using UNION in a value set
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…