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:
There are requirements where customers want to display Honors in “Display Name” if First Name is blank. This where the conditional name formatting functionality of Oracle HCM helps to achieve desired results. Let us assume, we want display name in below format: NVL(First Name, Honors), Name Information 1 Follow below steps to achieve this requirement:…
When creating a new announcement (Tools -> Announcements) , user has an option to upload images from local directory or a link can be given to a file uploaded in content server. From local directory: For content server link: One needs to follow below steps in order to upload the image file to content server:…
Below sample queries can be used to extract count of workers (Active/ Inactive) in HCM: Query 1: Query 2: Find count workers not having basic assignment details:
On the responsive Position UI, the position screens shows the Pending Worker and Worker record as an incumbent and the FTE goes in negative. Below SQL can be used to identify such persons:
Below SQL can be used to extract list counties configured for GB in HCM:
Oracle HCM provides lots of pre-defined messages which are triggered/displayed in UI on various actions. For example, if you are trying to hire a new person on a position which doesn’t have the vacant FTE, system will throw below warning message: However, in this particular scenario, business wanted to see an Error message instead of…
There are different requirements where one wants to get number of active/inactive work relationships in a legal entity. Below SQL query can be run to get these counts:
Many a times, even after loading Person EFF information successfully, using HCM Data loader, the information is not available in UI. In such cases, please make sure that following fields are passed correctly: InformationType – Name of extra information type e.g. ‘XYZ Medical History’ EFF_CATEGORY_CODE – EFF Category Context. For example, for person EIT, the…
