BIP – Query to find list of positions against a department
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:
-
-
HDL – Sample file to close benefit certifications
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”:
-
HDL – Sample file to load Person Habits
Attributes like student status, tobacco consumption which impact worker benefits can be loaded using PersonHabits.dat. Sample File:
-
Configuration – Conditional Name Formatting
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:…
-
Configuration – Load Announcements file in content server
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:…
-
BIP – Queries to find count of workers in HCM
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:
-
BIP – Query to find list of same person having same position multiple times
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:
-
BIP – Extract list of counties for GB
Below SQL can be used to extract list counties configured for GB in HCM:
-
Configuration – Modify existing system messages
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…
-
BIP – Query to find number of work relations in a legal employer
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: