OTBI
Discussion List
-
Dashboards graph PropertiesContent Hello! I added some pie charts in a Dashboard but they are displaying misaligned even if they have the same graph properties. In attachment a screen showing the …Chiara Arcidiacono 30 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 32 views 1 comment 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Anniversary ReportSummary Anniversary ReportContent Hi ALL, Need help in creating a report which populate employee who will complete there 1 year anniversary with company tomorrow. ex. Em…User_2025-02-07-19-03-14-525 105 views 16 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
How to Report available working hours of all Employees in a department excluding Absence HoursSummary OTBI Report for Available Working Hours of All Employees using either FTE or Normal Working Hours from Employee Assignment by excluding the Absence Hours during … -
Custom Columns with field from different Subject AreasContent Hello, I am working on a report that has 2 subject areas (SA). I am trying to include a column with a formula (CASE WHEN statement) using fields from the 2 subje…User_2025-02-05-06-26-19-951 57 views 5 comments 1 point Most recent by user5070067 Reporting and Analytics for HCM
-
recruitment facts/metricsContent Is there a way to pull # of applicants submitted to Manager, how many of those were rejected - or each phase how many touchpoint did recruiter make with applican…Riti Malhotra 48 views 2 comments 0 points Most recent by Dhiraj Hadkar Reporting and Analytics for HCM
-
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in…
-
End date for scheduled processSummary Need to be able to report on end date used when process scheduledContent Hi, I need to create a report that will show the end date of the schedule created for a …
-
Analysis failing with error: Exceeded configured maximum number of allowed output prompts, sections,Content Hello Experts, I had built a dashboard using the Absence Calendar Details Real Time subject area having two sections - Summary and Detail Analysis reports. I had…Akash Kiran Jana 28 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Report for overtime hours and regular hoursContent We have a requirement to develop a SQL report based on Over Time hours and Regular hours capturing from a third party device. Suppose we are not creating any pay…User_2025-01-28-21-18-43-496 204 views 3 comments 0 points Most recent by Sudakar Babu Sunkesula Reporting and Analytics for HCM
-
Last person who have made changeSummary Hi I need ton know who's the last person made change on a person's role or privilege.Content Hi I need to know who's the last person made change on a person's ro…sasamimi 47 views 1 comment 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Proper Case Function in OTBIContent Is there a function in OTBI that transforms character strings from their current state into PROPER case format? For example: 'JOHN SMITH' or 'John SMITH' to 'Joh…Dustin Dominic 44 views 2 comments 2 points Most recent by Dustin Dominic Reporting and Analytics for HCM -
Percentage split cost centres in OTBISummary Unable to find percentage split cost centres in OTBI on payroll relationship levelContent Hi, I am trying to create an OTBI report which displays employees who h…User_2025-01-30-03-54-32-528 117 views 12 comments 2 points Most recent by Urvashi Jain-261257 Reporting and Analytics for HCM
-
Dynamic printing of column labels in OTBI or BI PublisherSummary Dynamic printing of column labels in OTBI or BI PublisherContent Hi All Kindly share your experiences on how you have been dynamically creating reports with titl…User_2025-02-08-03-05-58-849 19 views 1 comment 2 points Most recent by User_VLBBP Reporting and Analytics for HCM
-
Document Records Details and Corresponding ApprovalsSummary Document Records Details and Corresponding ApprovalsContent Hi, Are we able to produce a report which details the Document Records and the corresponding Approval… -
BIP report leveraging the OTBI dashboard promptSummary This post contains a brief synopsis describing the technique to leverage the OTBI dashboard prompt in the BIP reportRaghavendra Raghunath-Oracle 259 views 12 comments 12 points Most recent by Sujay Bandyopadhyay-Oracle Reporting and Analytics for HCM -
Model Profile - Employee Level - FUSION OTBISummary Model Profile - Employee Level - FUSION OTBIContent Hello We have the attached Model Profile Information report that details all the Role Profiles, as well as th…Andrew Braid 116 views 4 comments 2 points Most recent by Aman Malik Reporting and Analytics for HCM -
Manage Job Offers - Approvals HistorySummary Manage Job Offers - Approvals HistoryContent Hi All Could you please help me with the OTBI / BI Report which helps to get the history of all transactions related…Mansur Khalil 69 views 2 comments 3 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Payroll ReportContent Hi, I am using two subject areas Workforce Management - Person Real TIme, and Payroll - Personal Payment Detais real time When I add any of the column Target Ban…Mohammed Rafi 63 views 5 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Subject Area to determine Reviewee Start Performance Rating, Reviewee End Performance Rating ,ReviewContent Hi, I need the subject area that provides the below information. Can anyone please suggest, a. Initial performance rating of the candidate b. End performance rat…Manisha Chakraborty 29 views 2 comments 0 points Most recent by Manisha Chakraborty Reporting and Analytics for HCM
-
Reporting mulitple Types of Managers in OTBI or BISummary Reporting mulitple Types of Managers in OTBI or BIContent Hello, We have three 'TYPES' of managers defined. I need to create a report for all employees showing a…User_2025-02-04-15-06-22-759 255 views 21 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Annualized Salary is not populating on a OTBI reportContent When running an OTBI report the Annualized Salary value is not populating. The user has AoR's and when they view the salary details via the HR forms the details …Rebecca L Smith 113 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Gauge chartSummary How to set maximum scale limit to a columnContent Hi I'm trying to build a simple gauge chart for infolet to show employee's accumulated learning hours. Each emp…Aslam Khuajah 21 views 4 comments 1 point Most recent by Aslam Khuajah Reporting and Analytics for HCM
-
20D - Employee only see his own records when running reportsContent I'm sure this will be an easy fix for someone, but I have recently been tasked with setting up security access to allow a few of our employees to run reports/ana…User_VYO5Y 299 views 4 comments 1 point Most recent by Karen Waddell Reporting and Analytics for HCM -
Including Matrix Manager pulls wrong SalaryContent Hello, Has anyone created a report where you have included fields from both Worker Assignment Real Time -> Matrix Manager and Compensation Salary Details Real Ti…User_2025-02-04-15-06-22-759 19 views 2 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
HCM: "Changed Attribute" dimension in OTBISummary HCM: "Changed Attribute" dimension in OTBIContent Hi , Can some please advise, if we have the "Changed Attributes" dimension available in OTBI? I want to create …Nikhil Bhandari 70 views 6 comments 0 points Most recent by Nikhil Bhandari Reporting and Analytics for HCM
-
Calculation on Pivot table resultsSummary Looking to perform calculation on pivot table results columnsContent Hi there, I'm looking to perform a calculation on a pivot table to insert a new column withi…Gary Miller-39965 37 views 9 comments 1 point Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
OTBI report to kno new employe each day or each weekSummary Hi I'm new with OTBI, I need a report's running each day or each week with only new employes with name and number ID.Content We need a report that only contains …sasamimi 31 views 7 comments 0 points Most recent by Rosetta Jasperson-153288 Reporting and Analytics for HCM
-
Creating new calculated measure using columns from multiple subject areasContent Good afternoon all, I've created an OTBI report that combines the following subject areas: * Workforce Management - Worker Assignment Event Real Time * Workforce…Robert Craske 26 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Roles Required to access Subject Areas related to HCM/Payroll/Compensation/BenefitsSummary Looking for a reliable document listing Subject Areas and the Roles Required to access the sameContent Many a times it happens that OTBI analysis shared by exper…Dharmendra Shukla 49 views 5 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM