OTBI
Discussion List
-
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 22 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 77 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 30 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 31 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 21 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 25 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 86 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 66 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 224 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
-
Future Direction of SOAP on OTBISummary What is the future/strategic direction of SOAP on OTBIContent Hi, We've developed an automated deployment tool for OTBI using SOAP calls and we've invested signi…Syaifuddin 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get the manager's manager name in OTBIContent Hi, I got the employee manager name in OTBI subject area's and we need manager's manager name in OTBI. Please let me know the presentation table and column for t…Janardhana K 114 views 7 comments 2 points Most recent by James Hoffmann Reporting and Analytics for HCM -
OTBI Chart Legend TotalsSummary Totals to be included on the chart's legendContent Is there a way to include the totals on the charts? We are creating a dashboard with several pie and bar chart…Shelly Feyerherm 17 views 5 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Employee Unable to Pull Offering Primary Instructor - Oracle Learning CloudSummary Employee can pull their complete transcript in OTBI, but Offering Primary Instructor is BlankContent We have a requirement for an employee to pull their Learning…User_2025-01-31-00-25-12-234 49 views 3 comments 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Bank Holiday Time Element EntrySummary Bank Holiday Time Element EntryContent Hi, We are trying to report on Employees who are looking to get their Personal Contribution for Bank Holiday Time worked a…Tim Hopkins 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker ****Summary What are the roles and permissions required to be given to a userID so that he can use "Workforce Management - Worker Assignment Real Time" subject area and extr…Dharmendra Shukla 51 views 12 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?Walid Hamdy 37 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI Report that References Results of another OTBISummary Is there a way to have one OTBI report reference the results from another OTBI report?Content Hi All, Our use case: We need an OTBI Contractor report that also i…Denise Izzi 118 views 15 comments 2 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Data Security when creating HCM OTBI reports for non-HR usersContent We want to create a few reports that need to be available to either Finance or Office Managers which get the data from the Oracle HCM module. Some examples, but … -
New DFF Segment Not Appearing in OTBIContent Hello, I've added some new segments to the Document Record DFF. I ticked the box labelled "BI Enabled" for each segment, and both verified/deployed the DFF. Its …User_2025-02-07-03-52-39-913 397 views 16 comments 2 points Most recent by Akshay Aiyer Reporting and Analytics for HCM
-
Is there a Subject Area to View all Address Attributes?Summary I am migrating international employees into our system and want to report on their addresses however, I cannot find some of the fields within the subject area to…HROps17 169 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Average Time in JobSummary Creating a graph of average time in JobContent Hi all, I am working on a couple of reports where I am looking for the Average time a person has stayed in a Job, …User_2025-02-05-05-51-12-049 19 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Link between Pending Worker and an Employee in OTBISummary Link between Pending Worker and an Employee in OTBIContent Hi All, I have a requirement where I need to build a performance tile which needs to report the count …User_MC37Q 55 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
HCM – Product Office Hour: OTBI November 2020Content Submit your questions for the HCM – Product Office Hour: OTBI November 2020 session to have them answered during the live event. Post your questions by posting a…Heather Hagedorn- Cloud HCM-Oracle 52 views 10 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Error in Report - Date not filtering properly with other variables in Oracle ReportSummary dates not filtering correctly with other variableContent I am trying to filter dates with step increases in a custom Oracle Report; the objective is to show how …User_2025-02-06-20-46-18-602 13 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Adding Row # and Row Count to a report?Summary Looking for a way to include a row count in a reportContent We have recently moved to HCM Cloud after using Peoplesoft. Peoplesoft Query provided a row count in …User_2025-02-07-16-42-37-187 303 views 5 comments 1 point Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM