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…
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…
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:
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:
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…
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…
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…
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)…
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….
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:
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:
Actions and Action Reasons are very important part of any Cloud HCM implementation. Oracle provides a large number of actions and action reasons out of the box. But if needed additional actions and action reasons can be created from UI as well as using HDL. Each action is tied with an action type. Please note…
While extending the DFF attributes for additional functionality, one of the common requirements is to get the list of workers in the system. For this purpose a table based value set can be defined and attached to the DFF attribute. FROM Clause per_all_people_f papf, per_person_names_f ppnf Value Attributes Table Alias *Value Column Name papf.person_number…
