OTBI
Discussion List
-
Termination Report using Workforce Management - Work Relationship Real TimeSummary Termination Report using Workforce Management - Work Relationship Real TimeContent Hello - we have been using the archived report attached for a while now, but i…Shanna Oppenheim 59 views 17 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Female ManagersContent Hi All, Looking to Female Managers metric I can see the following logic: IFNULL(((FILTER(FILTER("Worker Assignment"."Head Count" USING (DE…Alvaro Couto 58 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
20D Known issue with OSHA Reporting?Summary 20D Known issue with OSHA Reporting?Content Is there a known issue with the "Environment Health and Safety - Incidents Real Time" Subject Area? Adding these colu…Andrew_Schmitz 33 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Number of Subordinates ReportSummary To show how many subordinates the person hasContent Hi All, I'm not sure if anyone is able to but I have been trying to figure a way to count how many subordinat…Eric.C 40 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I report on top 5 reasons for short term sicknessSummary Want to adapt the seeded report to show absence reasons for duration limitContent Hi How can I show the top 5 reasons for an absence of less than 28 days duratio…LTalbott2 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Vacant Position ReportSummary How to include position of an inactive employee in vacant position reportContent Hi, I created a report to extract vacant positions from HCM. However, the positi…User_2025-02-11-02-55-52-410 146 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Part Time logicContent Hi All, I've created a custom version of the Line Manager Dashboard in order to fix a few metrics. One of them is the Part Time metric ava…Alvaro Couto 58 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
Report for Scheduled jobs and AgentsSummary Report for Scheduled Jobs and AgentsContent Hi All, I went through the topics but couldn't find an answer to the question about a report being created that shows…User_2025-02-04-08-51-08-912 44 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
User access OTBI to view info on OTBI onlyContent Hello Experts. We are in dire need to create a Custom Role that gives access to 1 employee only to OTBI. This user must not be able to view talent document ratin…Pedro Teixeira 101 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Embedding Dashboard on context UIContent Dear All, I have embedded dashboard on Hiring page by creating another tab as shown in attached screenshot. I don't want to show all the catalog options with das…User_2025-02-06-14-37-05-233 67 views 8 comments 0 points Most recent by User_2025-01-30-00-32-10-452 Reporting and Analytics for HCM
-
OTBI Chart - Choose Legend OrderSummary Sorting the legend on a chart in a specific orderContent On the OTBI charts, is there a way to put the legend values in a specific order? For example, on of our …Shelly Feyerherm 46 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Embeded Action Link in DashboardSummary I am quite new to the use of Action links and I was wondering if somebody meight be able to help?Content Hi, I am currently trying to understand the new "Service…Mitch_123456 22 views 3 comments 0 points Most recent by Mitch_123456 Reporting and Analytics for HCM
-
Hire actions and termination actions at the same rowSummary Can't unified the hire reason and the termination reason to a one recordContent Hi, We want to create terminations report. In this report we want to include thei…
-
Can I rename the person level 1.00 in Assignment List when referring to this in a prompt?Summary The person level is 1.00. Can this be renamed as a reference in the prompt to Direct Reports?Content Hi Is this possible to rename the 1.00 person level to Direc…LTalbott2 16 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Formula for Sum of aggregate salary change percent by person number?Content Hi Everyone, I am trying to determine the best way to write a formula to show the sum of salary change percent by person number. For example, I have an employee …User_2025-02-07-16-42-37-187 66 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Employees with Cumulative Salary Increase of >20% over a fiscal year reportSummary Employees with Cumulative Salary Increase of >20% over a fiscal year report for audit purposesContent Hi Oracle Team, We were just asked by our audit team to pro…User_2025-02-07-16-42-37-187 21 views 3 comments 0 points Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM
-
Printing a Dashboard page in A4 mode, font size too smallSummary Printing a Dashboard page in A4 mode, font size too smallContent Hi, I have one dashboard which includes 2 OTBI reports, While am giving print am getting font is…User_MC37Q 33 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
In the performance document review, if Manager reflection is not there, choose Employee reflection.Summary In the performance document review, if Manager reflection is not there, choose Employee reflection.Content Hello, In the performance document review, check Manag…User_2025-02-10-16-28-01-402 19 views 1 comment 0 points Most recent by Amrit Reporting and Analytics for HCM
-
Need year calc with decimalSummary Need year calc with decimalContent I am trying to write a formula to capture job tenure and I tried this but I only get whole numbers and I need 2 decimal places…User_2025-01-28-04-05-14-166 78 views 9 comments 0 points Most recent by Mahendra Reporting and Analytics for HCM
-
How to add parameter value when scheduling AnalysisSummary How to add parameter value when scheduling AnalysisContent Hi, When I try to schedule Analysis using Agent, I can't find parameters which are available when it i…
-
Subject areas not displaying the correct Hire DateSummary Enterprise Hire Date is displaying when the employee first started with company - not his latest start dateContent I am using two subject areas Workforce Managem…User_2025-02-04-08-51-08-912 42 views 5 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Cannot find Effective Start Date and Effective End Date in Workforce Management - Worker AssignmentSummary Cannot find Effective Start Date and Effective End Date in Workforce Management - Worker Assignment Real TimeContent Hi, I am unable to find Effective Start Date…User_MC37Q 27 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI subject areas does not give a reference of Birth Name or Maiden Name on mapping spreadsheetSummary OTBI subject areas does not give a reference of Birth Name or Maiden Name on mapping spreadsheetContent OTBI subject areas does not give a reference of Birth Nam… -
Report to show employees that have over contributed to CPPSummary CPP over contribuionsContent Hi all, Can someone please point me in the direction of where I could pull out the current CPP Contribution limit? I need to compare…User_2025-02-04-08-51-08-912 28 views 5 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Re-arrange/Customize the coulmns in OTBI Analysis reportSummary Re-arrange/Customize the coulmns in OTBI Analysis reportContent Hello, I have the requirement to get performance document review. but the output in the dashboard…User_2025-02-10-16-28-01-402 18 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Area to determine the Minority/Non Minority Status of a personContent Hi , I want to use a Subject Area which determines the Minority/Non Minority Status of a person. Can anyone please suggest. Thanks, - ManishaManisha Chakraborty 24 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' DetailsSummary Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' DetailsContent Hello, Can anyone please help? I have an OTBI report around Learning …SantoshKumarBhairi 84 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
OTBI: Need to display ratio between 2 analysis in a dashboard page.Summary OTBI: Need to display ratio between 2 analysis in a dashboard page.Content Hi, We have analysis 1: All Employees Head Count Analysis 2: HR Employees Head Count W…User_MC37Q 77 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859 Reporting and Analytics for HCM
-
OTBI: Report with more than 50,000 rowsSummary New customer joining with large number of employees - more rows requiredContent HI all, We currently use many OTBI reports for our standard reports. However, we …User_2025-02-05-05-51-12-049 232 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Percentage of Employees with Performance Feedback Received OTBISummary Percentage of Employees with Performance Feedback Received OTBIContent I've requirement to create an Analysis report along with drill down mechanism to show data…Santanu Roy 75 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM