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…
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…
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…
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…
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:
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…
There are cases where we need to use functions like days between to get difference between two dates. These functions can not be used from Transaction console. One has to login to BPM Worklist to access the functions. Follow the below steps: Open the worklist app: https://xxxx-saasfaprod1.fa.ocs.oraclecloud.com/integration/worklistapp/faces/home.jspx Click on your user name -> Administration and…
In HCM, you can define approval rules for different HCM tasks from Tools -> Transaction Console -> Approval Rules For example, you want to define an approval rule for Promote action. You can search Promo% in Find box and it will give you all matching approval rules: You can then click on ‘Configure Rules’ to…
Oracle HCM provides a functionality to store different kinds of worker documents in Document Records. Over a period of time, a large number of documents get accumulated for different workers. In such cases, there are requirements to know size of attachments in DORs. For, this I have developed a simple query which can be modified…
Below SQL query can be used to find part-timers in HCM. Any worker where FTE is less than 1 is normally considered as part-timer:
Recently, I faced a scenario for a customer where after go-live, where there was an issue found with absence plan configuration. The absence plan was incorrectly set up. The Balance Frequency Source wasn’t setup to “Repeating Period”, so the accrual was calculated incorrectly. In order to fix this, a new absence plan was created and…
There are times when we just need a quick query to count number of positions created in HCM against a department. Below is a sample SQL which can be handy in such situations:
Starting 23C, a new HDL object has been added to close any pending actions for benefits. The certification type is validated against a lookup called – BEN_ENRT_CTFN_TYP Below is a sample file to close any pending certification actions against “POC”:
Attributes like student status, tobacco consumption which impact worker benefits can be loaded using PersonHabits.dat. Sample File:
