Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor… -
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use… -
Custom BI Publisher reports takes a long time to completeSummary: I created a custom BI Report. When I run the report it takes about 23 seconds to complete. When my client runs the report it takes almost 10 minutes to complete… -
-
-
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
-
-
HR Dashboard - Compensation Tab - Where to find where data is coming from and how to hide data?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know where this data is being pulled and if there can be an extract of the data? Th…
-
HR Dashboard - Headcount Tab - Where to find data, how to change colors, and how to change filters?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know the reason the colors are different for the same categories and if they can be…
-
-
unable to access data from Compensation- Salary Details Real time with custom roleWe have created an OTBI report using Compensation - Salary Details Real Time. We have created a custom Role for Human Resource Analyst. With this role we are unable to a…
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …
-
-
-
-
-
-
How can we apply Redwood design to the analytics page on Oracle fusion HCM?We have a requirement to implement Redwood on the analytics page in Oracle Fusion Cloud HCM. We have certain dashboards that are build and we believe that they would ren…
-
Adjusted FTE Table and Views for BI Publisher ReportsHi, I have a couple reports in my system that require the addiction of the Adjusted FTE field as a replacement to the standard FTE field, and I've had a look at the HCM …
-
Is there a way to bring UNION_ID for an employee in FAW? Please suggest a suitable PVO for UNION_ID.How to get UNION_ID for an employee in FAW? It is not present in assignment table: dw_wrkfrc_asg_f.
-
Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance.
-
Compensation Salary History Details Real Time not showing data for leaversSummary: Hi all I have built a report in OTBI using the Compensation - Salary History Details Real Time. I noticed I am missing data for employees who have left the orga…
-
Do release updates affect the seetings in the Custom BI Webcat Reporting Duty Role?Summary: We want to limit the access to seeded reports as described here How to Revoke User Access to Seeded OTBI Content in Oracle HCM Cloud | by Manoj Gupta | Medium, …
-
Workforce Structures > Job Detail Screen - Can You Report a History of Changes?Summary: Is there a way to write an OTBI report that shows old and new values, field name and date of change entered on the Job Detail screen (Workforce Structures/Job D…
-
How to extract LEGAL_ENTITY_IDENTIFIER?I need a SQL query for a BI report to extract the LEGAL_ENTITY_IDENTIFIER, starting from a department.
-
expedited element entries querySummary: Hi, We have a report about the expedited element entries but not for HCM Extracts. Do you have any sample query about how to get this report?
-
OTBI Termination Date Filter Syntax QuerySummary: Hiya, I am trying to filter out any records where the Termination Date is before the current date. If the termination date is after the current date then the re…
-
How do I create a severance report using payroll run result real time subject area ?I am trying to build a severance report for codes - SVR, RTN, SVK, SVL, WRN. I am looking to get the earnings in the below format but I am struggling to find the fields …