OTBI
Discussion List
-
Effective Date of Latest Job CodeSummary Pulling Effective Date of Latest Job Code in an analysisContent I have created an analysis using the subject area ‘Compensation – Salary Details Real Time’. I ha…Shelly Feyerherm 109 views 9 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
OTBI - HCM Manager dashboard Session 01 - 11/March/2021Summary OTBI Reporting overviewContent This OTBI working session conducted on March-11-2021 had an overwhelming response of 277 attendees. I hereby attach the resources …Raghavendra Raghunath-Oracle 70 views 0 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o…Lauren Owen 31 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a …User_2025-01-28-08-47-04-905 427 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn…Rajeev Nayan 76 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
Managing privileges for AgentSummary Schedule an AgentContent Hello Everyone, Does anyone know which privilege from the list below removes the access from users to Schedule Agents? Thank you, Alvaro…Alvaro Couto 54 views 6 comments 2 points Most recent by Laura Meine Reporting and Analytics for HCM -
BIP Report Scheduling IssueContent Hi all, I'm currently in the process of scheduling the reports we've built using BIP data models, but we've noticed that all schedules that I've created only sho… -
OTBI analysis for Performance rating #Content Hello, We have a requirement to develop an OTBI analysis that gives the count of employees for each rating in a particular department. I am using the subject are…Praneeth K-261878 49 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Restrict to run reports for delivered Employee RoleSummary How to restrict with delivered Employee Role to run reports from BIContent Hi Experts, We have noticed that general Employees have access to run reports (like Pa…Rakesh Ankusham 58 views 6 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM -
OTBI layout performance tile how can i make the square border thicker?Summary OTBI layout performance tile how can i make the square border thicker?Content Hello We have an OTBI with layout of a sum displayed in a ‘performance tile ‘. The …Revital Mefano 36 views 4 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM -
Pivot Report - Have a heading and change value sequenceSummary How to change value sequence and have a label in pivot report?Content I have created an OTBI report with pivot output. On left side is the desired output and on …User_2025-01-25-04-02-13-126 57 views 4 comments 0 points Most recent by E McDonald Reporting and Analytics for HCM -
OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics, 23 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics session to have them answered during the live event. Post you…mauricio -Oracle 37 views 0 comments 1 point Most recent by mauricio -Oracle Reporting and Analytics for HCM -
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 480 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 23 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 42 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 577 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 32 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 134 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 71 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 66 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 47 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 41 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 17 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 26 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 467 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 56 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 34 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 29 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 35 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 35 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM