BIP – Extract Grade Ladder, Grade and Step details
Below query can be used to extract grade ladder, grades in ladder and step details of a grade.
-
-
BIP – Report to extract BIP scheduled jobs
I have designed below query to extract the schedule of a BIP submitted jobs which is not available directly. Replace the job name attribute with your job name or run it for all:
-
-
BIP – Query to extract worker manager job name
Below SQL query below shows how a job name can be pulled for a worker’s manager. The SQL can be easily modified to include further employment related attributes for worker’s line manager.
-
BIP – Find list of message sent from Oracle Alert
Alert composer a very powerful and useful tool to configure and sent notifications to the users. However, it is very important for business to know the list of receipients for each message. I have tried to built a query to get these details. From alert history, one can find the emails triggered but it doesn’t…
-
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 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…
-
-
BIP – Query to find attachment details for related materials
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:
-
BIP – Extract absence type schedule hierachy start point
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:
-
BIP – Query to find active user accounts post termination
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…
-
BIP – Query to find size of documents attached in DOR
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…
-
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:
-
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:
-
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:
-
Configuration | HDL | Reports
BIP – Extract Document Record File Link from Content Server
Below query can be used to extract the document record from content server.
-
BIP – Suppress special characters
Oracle HCM allows special characters to be used in fields like Person Names/ Department Names/ Jobs etc. But in reporting, there may be a requirement to change the special characters (like ý, ě, ž, ů etc) to normal English characters. CONVERT function can be used for such requirements. Output:
-
HDL – Sample HDL file to create Role Provisioning Rules
The rules can be verified from UI, once the HDL load is successful:
