-
-
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….