-
-
-
Configuration – Value set to get Grade Steps based on Worker Grade
Assignment DFF supports a number of parameters which can be used to get dynamic values based on Worker assignment. List of supported parameters for a DFF can be found using below link: In this example, we will create a value set to display list of Grade steps based on Worker’s assigned grade. Create a Table…
-
BIP – Query to get Active Users for terminated employees
Once a worker is terminated in Oracle HCM Cloud, one would expect that associated User account to be inactive as well. For this to happen automatically, autoprovisioning rules should be setup which will remove the associated roles to the terminated worker’s user. In case, there is even a single role attached to the user, the…
-
HDL – Loading Classroom Resources in Bulk
HCM Data Loader object ClassroomResource can be used to bulk upload classroom resources in Oracle Learning Cloud. Existing locations created as part of Global HR can also be designated as classroom resources. Below is a sample file to upload classroom resources using HDL: Once the data is loaded successfully, you can verify the results from…
-
-
HDL – Sample File to DELETE documents of Record
Use the below query to extract document of record data which should be deleted. You can add additional filters by adding person numbers. Query for Person Number and Document Type: Sample HDL File:
-
-
-
-
-
HDL – Update Goal Weight
Goal Weightage can be updated using GoalMeasurement metadata in Goal business object. First, we need to extract the uploaded measurements. Use the below query to extract the details: Save the data in Goal.dat HDL file. Update the target value as required. Save the .dat file and upload. Sample HDL:
-
BIP – Providing Link of BIP report on Self Service
There is one common requirement where Employees should access reports directly from self-service instead of navigating to analytics. In such cases, a report link can be created and added as a static link on Navigator. This will enable the employee to access report directly. The report can be then viewed in different views using different…
-
BIP – My Public Info Extract
Each person can publish public info in HCM Cloud by navigating to Me -> Quick Actions -> Public Info. There are various sections under Public Info like Public Message, Contact Info, About Me etc. You can use the below SQL queries to extract the data for relevant sections. Public Message: SQL Query: About Me: SQL…
-
BIP – Query to find attachment details
There are multiple objects in Oracle HCM Cloud which support attachments. Often, there is a need to extract the attachment details stored at the object level. All the uploaded attachments are stored in fnd_attached_documents table. Below query is used to extract the attachment details stored at Service Request level in HR Helpdesk. You can replace…
-
Configuration – Value set to get Employee Category list
Employee category (EMPLOYEE_CATG) is a delivered user type lookup in Oracle HCM which can be extended. However, in few cases, there is a requirement to populate employee category at DFF attribute(s), in this case, we need to create a table defined value set. FROM Clause fnd_lookup_values Value Attributes Table Alias *Value Column Name substr(meaning,1,80)…
-
-
Extract – Loopback Inbound Extract
Often in Cloud HCM, we encounter situation(s) where we need to update some information at worker assignment, post worker creation as this information was not available at the time of hiring an worker. One such example could be Employee category. Let’s take a hypothetical example, employee category should be auto populated based on worker Job….
-
BIP – Query to Extract Position FTE values
When position hierarchy is enabled in Cloud HCM, Manage Positions UI shows some dynamically populated fields along with Parent position. For example: Use the below query to extract above details:
-
BIP – Query to extract fast formula details
Below query will extract all the custom fast formulas along with the name of formula and formula type. To extract list of fast formulas used in HCM Extracts, run below query: