OTBI
Discussion List
-
OTBI how to round up a number with decimal points to be without the points?Summary OTBI how to round up a number with decimal points to be without the points?Content Hello, In OTBI report, there is a field based on sum of FTE , which may includ…Revital Mefano 470 views 10 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM -
HEX values for seeded pie chart colorsSummary HEX values for seeded pie chart colorsContent I have built a pie chart for Performance ratings for a Dashboard. The systems default to 3 colors - Yellow, Blue an…User_2025-02-10-08-27-16-805 20 views 2 comments 2 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
OTBI layout tile how can we replace the performance tile in the middle of the dashboard?Summary OTBI layout tile how can we replace the performance tile in the middle of the dashboard?Content Hello , We have an OTBI with layout of a sun displayed in a ‘perf…Revital Mefano 32 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Transaction Console ReportContent Hi All, Need your help in which we can extract the below data fields. This is a kind of requirement from the internal Audit. Resignation Submission Date ---- Not…Kiran Kancherla 550 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Line Manager OTBI Security - global and line manager org specific analysis accessContent Hi Experts, Per the note below, I understand that we can build different security for OTBI and HCM Cloud: https://cloudcustomerconnect.oracle.com/posts/7465f7e09…User_2025-02-10-17-54-52-878 27 views 2 comments 0 points Most recent by User_2025-02-10-17-54-52-878 Reporting and Analytics for HCM
-
Wrap Text in OTBI ReportsContent Hi All I unchecked wrap text checkbox in Table content properties to wrap all the columns in the report. In the view it shows the columns are wrapped. However, w…Ridma Karunanathan 133 views 5 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HR Help Desk Affected PartyContent Hi all, We are currently rolling out the affected party field in HR Helpdesk and I'm having issues with finding the field in OTBI. Has anyone successfully report…User_2025-01-31-00-25-12-234 64 views 3 comments 1 point Most recent by Josh Vincent Reporting and Analytics for HCM
-
Primary Ethnicity is not the only one returnedSummary In Workforce Management - Worker Assignment Real Time, there is a "Person Ethnicity" in the Worker Folder.Content When we include this field in an Analysis, the …Aaron Hager Associated Bank 59 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM -
View Headcount by Selected LeaderContent Hello everyone, I created a dashboard for HR business partners covering basic worker and person assignment information e.g. headcount, gender breakout. I would l…User_2025-02-11-03-07-51-707 41 views 4 comments 1 point Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM
-
Detailed report for pie charts does not work with dashboard promptsContent We are building a dashboard for Talent Profiles and have successfully built a chart that accurately pulls data from Talent Profiles. The chart works well with th…User_2025-02-10-08-27-16-805 36 views 2 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
adding recruiter's assignment name from work assignment real timeContent How can i pull the recruiter 's title (recruiter full name- hiring team) from their core hr record. anytime I join recruiting real time to workforce assignment r…Riti Malhotra 12 views 2 comments 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
can we group the output using any templateSummary my report is displaying 300 rows but user needs to display the output in grouping ,example each 100 rows as one group ,is it possible to using templateContent Hi…User_VR8E0 20 views 1 comment 1 point Most recent by Pradeep Sharma-14802 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 454 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Headcount Measure shows blankSummary Headcount Measure shows blank from workforce Management - Worker Assignment real time subject area where as we can see the values from applicationContent Hi, Hea…Rekha Putikam-16910 59 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Disappearing images in OTBI DashboardSummary Disappearing images in OTBI DashboardContent I built a dashboard for users to look up Jobs and print out the corresponding Job Profile in a PDF format I am using…User_2025-01-23-21-24-21-434 30 views 2 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM
-
Workforce Compensation Report -Acttion Required,Hierarchy Level,Manager statusContent In Workforce Compensation not able to find these columns Acttion Required,Hierarchy Level,Manager status Fields in OTBI (Compensation - Workforce Compensation Re…User_VR8E0 25 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI vs BIP filtering clarificationSummary HOw OTBI handles filtering verse BIPContent Hi, Seeking clarification/advice on the following scenario. We have an OTBI report that pulls in a person's work exte…Denise Izzi 30 views 12 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
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 33 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 103 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 44 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 29 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 219 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 44 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 114 views 12 comments 2 points Most recent by Urvashi Jain-261257 Reporting and Analytics for HCM