Reports
Discussion List
-
Publishing reports created in Data Visualizer to Cloud HCMSummary Not able publish the reports created using Data Visualizer to Cloud HCMContent When I try to publish the report/project created in Data Visualizer to our instanc…Radhika Thiagarajan 45 views 3 comments 0 points Most recent by Radhika Thiagarajan Reporting and Analytics for HCM -
Why can't salary be pulled into a terminated report?Summary Need to pull salary in for inactive employeesContent This has been an issue since we implemented HCM. I don't understand why Oracle wipes out an employee's salar…User_2025-01-28-20-43-56-568 121 views 6 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM -
Manager Hierarchy Drill Down ReportSummary Need an OTBI Report to Drill down based on the Manager Selection. The detailed table should be dynamic to increase the columns data based on selection promt mana…User_2025-01-23-22-36-48-692 367 views 24 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher Date PromptContent Hi All I'm struggling to get a Date prompt working in BI Publisher. I can get the prompt to show but it doesn't work (seems more complex than the easy prompts in…Aaron Leggett 86 views 3 comments 0 points Most recent by User_2025-01-28-20-47-34-889 Reporting and Analytics for HCM -
A solution for exporting reports from one environment to another when versions are differentContent Hi, I've been trying to transfer reports and dashboards across environments recently, but have come into this error: Incompatible version when reading object "Ca…Billy Dix 35 views 5 comments 0 points Most recent by User_2025-01-23-22-38-50-675 Reporting and Analytics for HCM
-
As of Date Presentation VariableContent Hi Is it possible to create a presentation variable for a date to get a report from the past? For instance, I need a report to show what the data was on the 1st …Aaron Leggett 143 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Unable to view OTBI Report Parameters/Prompts from CWB PlanContent Hi All, I have created custom Compensation OTBI Report as per the requirement. I uploaded report in "/Custom/Human Capital Management/Compensation" folder and at…Visu 66 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Employment History Report - Manager, Job, Business UnitContent Does anyone have an example of an employment history report that shows what the values for manager, job and business unit for old and new values? There is a samp…User_2025-01-22-19-19-56-324 114 views 1 comment 0 points Most recent by David Kim-19310 Reporting and Analytics for HCM
-
Report to Run with Lookback PeriodContent I'm trying to create a report with a filter (not a prompt) that looks back a specific number of days from the current run date. I'm using the SQL Expression of C…User_2025-01-22-19-19-56-324 51 views 4 comments 0 points Most recent by User_2025-01-22-19-19-56-324 Reporting and Analytics for HCM
-
Common Alignment for both RTF and PDF not working in LettersSummary Common Alignment for both RTF and PDF not working in LettersContent Hi, I have developed one appointment letter, when i run this report the alignment of RTF Temp…User_2025-01-28-00-11-59-141 53 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
SQL Function to allow more than 4000 charactersSummary Need SQL Function to allow more than 4000 charactersContent Hi, I have built sql custom report and my requirement is to bring employee overall comments using BI …User_2025-01-28-00-11-59-141 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Pivot Table Issues with Position NamesContent Hi all, We have a position in an organisation analysis which works perfectly but when we try and pivot the table to show a higher level view, the position names …User_2025-01-28-07-12-45-467 75 views 7 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
Showing Percentages in a Bar PivotSummary Is there a trick to show percentages on a scroll over of a bar pivot with actual values?Content Hello all, I am using OTBI to develop some reports and the user p…Nicolas Trojack-24006 92 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add Trimestre prompt in BI publisher depending on assingment tableSummary I want to add a prompt in bi publisher report which is Trimestre and depends on per_all_assignments_m (effective_start_date)Content Hello, How can i define on sq… -
Goals - Not Assigned/Tasked to EmployeesContent Good Day, Is there a way we can pull a list back within an analysis to show all employees that have 'NOT' been given a goal for mid/end of year review from the P…User_2025-01-28-07-12-45-467 71 views 10 comments 0 points Most recent by User_2025-01-29-01-27-20-754 Reporting and Analytics for HCM
-
Translate Bi Publisher and OTBI report ?Summary Columns , title and values can be translated in OTBI and BI Publisher reports?Content Hello, Is it possible to translate columns in reports and title and values …User_I6AXL 56 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
looking for HCM fusion reporting expertSummary HCM fusion reporting expertContent We went live with HCM fusion payroll, core, time, absence, and employee self service. We are looking for some short term repor…Molly O'Gorman Billings 131 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Two rows for one employeeSummary Two rows for one employeeContent I have a report that I run that lists all active employees, plus the employees that were terminated in the last 45 days. We had …User_2025-01-25-03-12-46-792 99 views 9 comments 0 points Most recent by User_2025-01-25-03-12-46-792 Reporting and Analytics for HCM
-
What is the significance of Role Type = ManagerSummary Need to understand why almost every Performance and Goals related subject area uses Role Type = ManagerContent In every Subject Area associated to Performance or…Sivakumaran Muthusamy-Oracle 51 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Slow performance in OTBI AnalysisSummary Slow performance in OTBI AnalysisContent Hello, I have created some Analysis in OTBI. I see that are very slow or they go in time out. The reports have 4 attribu…Giuseppe 1234 221 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM
-
how can i get individual PDRs onto my PDR report?Summary PDRsContent Hi I have created a PDR report which brings back the lines for the last 3 years of every employees PDR (personal development review) using Workforce …User_2025-01-29-02-09-34-137 10 views 0 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
I am having trouble creating a report, please helpSummary Trouble with reportContent Hi, I am having trouble with creating a report to show Headcount on one line and FTE on another line and salary costs by year in a tab…User_2025-01-29-02-09-34-137 54 views 7 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
Dashboards with No Data Analysis ReportsContent GoodDay, i have created numerous amounts of dashboards and analysis reports in R11 and R12. My only query/issue is when you use the prompts to filter down on sai…User_2025-01-28-07-12-45-467 88 views 3 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
Generating An Output File with .CSV Extension In Oracle HCM Cloud ApplicationSummary Generating An Output File with .CSV Extension In Oracle HCM Cloud ApplicationContent One of the most common requirement faced whenever one tries to transfer data…AshishERPCloud 114 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to include the name of the logged-in user generating the report in the header?Content Hi, I need to create the user field that executes the report in the header of these, in what area of the report does it allow me to include this value? Header Ex…Mirtha Antequera Borges 68 views 2 comments 0 points Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM -
Custom Report Line managerSummary The line manager don't see any data in custom report with person and department ot job dataContent Hello, We have created a few custom analisys for the line mana…Giuseppe 1234 107 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM
-
Recruiting Perf Tiles - % calc helpSummary Recruiting Perf Tiles - % calc helpContent HI I used the sample performance tiles and they are great. However when I do the math for the % the sample formula doe…User_2025-01-28-04-05-14-166 18 views 0 comments 0 points Most recent by User_2025-01-28-04-05-14-166 Reporting and Analytics for HCM
-
Having trouble with creating calculated items within a reportSummary Grouping by Count is not calculating correctlyContent Hi. I am trying to create groups of employee ages (i.e. 18-24, 25-34, etc.) by creating a new calculated it…User_2025-01-28-20-43-56-568 101 views 10 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM
-
Introducing the BI and Reporting Idea LabSummary Have an idea that could take Oracle Business Intelligence from good to great?Content We are pleased to announce the launch of the Idea Lab for Business Intellige…Bernice Lam - Inactive 50 views 1 comment 0 points Most recent by User_2025-01-25-01-46-39-933 Reporting and Analytics for HCM -
Need to pull last perf review scoreSummary Need to pull last perf review scoreContent Am needing to pull the latest performance score..so wrote this formula but am getting multiple lines of data per emplo…User_2025-01-28-04-05-14-166 42 views 2 comments 0 points Most recent by User_2025-01-23-21-28-55-898 Reporting and Analytics for HCM