OTBI
Discussion List
-
Performance Tile - create a measure of maxium distance from CEOSummary How to create a measure of max of levelContent Hi, we need to create a measure that is the maximum distance from CEO. Level is calculated by the following formul…Nicola Petri 25 views 4 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM -
Performance Tile - create a measure #managers/#employeeSummary How to create a measure #managers/#employeeContent Hi, we need to create a measure that is the ratio within the number of managers and the numbers of employees. …Nicola Petri 29 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filled Requisition ReportSummary Need help troubleshooting a few things on a filled requisition reportContent Hello! Looking for some help troubleshooting the attached filled requisition report.…Jennifer Eichholz 46 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI job history report with previous/current values?Summary I'd like to report with previous and current valuesContent Any one have examples or advice on developing an OTBI which will display both the previous and current…User_2025-01-28-08-47-04-905 207 views 3 comments 0 points Most recent by RamaKrishna Vemula Reporting and Analytics for HCM -
Pending Workflow Notifications DashboardSummary Dashboard to be created for pending workflow notiifcationsContent Hi all, We are trying to create a dashboard which will display the number of pending workflow n…User_U7T4G 115 views 11 comments 0 points Most recent by Ankush Rode Reporting and Analytics for HCM
-
Assignment Overview with effective date (Report)Summary This report gives an overview over changes to assignments within your organizationContent The main purpose of this report is to give a manager or HR an overview …Even Kjorsvik-Oracle 74 views 0 comments 8 points Most recent by Even Kjorsvik-Oracle Reporting and Analytics for HCM -
Slow Performance when Department tree columns are includedContent We have built a simple report using ‘Goal Alignments Real Time’ subject area. The report runs in few seconds if we do not include Department tree columns. Howeve…User_2025-02-05-23-59-37-171 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Aligned Goal information missing in report outputContent We are setting up Goal Alignment report using the "Workforce Goals - Goal Alignments Real Time". Subject Area. The report works fine when running with a HR View …User_2025-02-05-23-59-37-171 58 views 4 comments 0 points Most recent by User_2025-02-05-23-59-37-171 Reporting and Analytics for HCM
-
Benefit Eligible - Working Hours ChangesContent Hi all - we have requirements for our benefit eligible population: Person Type = Regular Employee, Limited Term Employee, Casual/Seasonal Employee Assignment Cat… -
Workforce Trend Headcount by User Person TypeSummary We have a requirement to trend headcount by person type. It appears the workforce trend real time subject area only returns the latest person type and not the pe…Ryan_Sullivan 59 views 5 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin…User_2025-01-28-05-39-23-766 124 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Revoking User Access to the Shipped OTBI Content in Fusion HCM 19CSummary This white paper documents the steps to revoke access to the seeded OTBI content for all users in 19C.Content In 19C, OTBI introduced a new set of BI reporting r…User720640-Oracle 173 views 6 comments 11 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM -
Requisition Filled Date and Time to fill on ORC reportContent I am looking for a way to pull in the requisition filled date into a filled requisition report for ORC. I cannot find that field in the subject areas. In additio…Jennifer Eichholz 96 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Combining Multiple Question RowsContent I have an ORC report that is pulling our filled reqs and the candidates' information that have been hired into those reqs. We want to see on the report their ans…Jennifer Eichholz 45 views 2 comments 0 points Most recent by Jennifer Eichholz Reporting and Analytics for HCM
-
Manager Detail ReportSummary My report doesn't show changes of managerContent Hi, Please see attached XML file. I have copied the output of an old report (I don't have the sql or xml for the…User_2025-02-05-22-44-35-842 56 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Absence Report with Between DatesSummary Report not workingContent Hi, I have attached the XML for this absence report, can anyone work out why it won't run? I've tried different combinations in the cri…User_2025-02-05-22-44-35-842 32 views 10 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Getting month and year into one column while maintaining date date type - EVALUATE NQSCOnfig.INI errSummary Getting month and year into one column while maintaining date date type EVALUATE NQSCOnfig.INI errorContent Hi - We are trying to graph an analysis that would sh…Roy Paolo Paunlagui 40 views 7 comments 1 point Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM
-
Dependent Change Audit ReportSummary Need to create a report showing dependent option changesContent Hi...I am trying to find out how to create a report/analysis that will show me any employees whos…Denise Haas 50 views 4 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Achive 'My Folders'Summary Archive from Production to Development environmentContent Hi, Yesterday I lost all of my work that was stored in My Folders in the production 'Live' environment …User_2025-02-05-22-44-35-842 19 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
BI report or OTBI report to list out ALL Pending vacation requests for a managerSummary BI report or OTBI report to list out ALL Pending vacation requests for a managerContent Hi Experts, My manager would like to know if there’s a way to view all th…
-
Security Report In OTBISummary We need to Create Security Report in OTBI with details of Roles assigned Date and also the previous role which was deleted.Content Need to Create OTBI reports fo…
-
2019 Leavers with salarySummary OTBI report needed showing 2019 leavers & salariesContent Hi, I have been looking through the shared reports centre and previous posts and haven't really found a…User_2025-02-05-22-44-35-842 53 views 14 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Work MissingSummary My Folders is emptyContent Hi, I've had issues logging into OTBI over the last hour, eventually after clearing my caches, browsing history etc and a reboot of th…User_2025-02-05-22-44-35-842 20 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Graph to show current monthContent Hi I have attached a very simple graph but I would like it only to display the current months data . I am having difficulties achieving this. Regards MelissaUser_2025-02-06-11-18-47-896 23 views 2 comments 1 point Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
Termination Reason ActionContent Hi Guys, I have to extract the information about the termination reason. I used this field in my report: "Workforce Management - Worker Assignment Event Real Tim…Giuseppe Iacono 93 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need Help with Date Sorting on Advanced XML ReportSummary Date Sorting on Graph not working properlyContent Hi Experts, I tried reusing an Assignment Change in last 1 year report from the repository over here. The entir…Meet Bhavsar. 39 views 3 comments 0 points Most recent by Meet Bhavsar. Reporting and Analytics for HCM -
How to extract Cost Center with OTBISummary How to extract Cost Center with OTBIContent Hi, We would like to export the cost center structure and corresponding values in OTBI. We are using the functionalit…Hakim Slimani - AXA 357 views 13 comments 3 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Changing the Default value in a column selectorSummary Have Column Selector, want to duplicate and change the orderContent Hello, I'm trying to use the Column selector view and am looking for a way to either set or c… -
Report on appraisal status and tasksSummary I need a report with the specs as stated below in the content. Can anybody see what I am doing wrong here?Content Fields needed: * - Performance document name * …Inge Marinus 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis showing 2 Record for manager update for employees.Summary How can we remove duplicate record for line manager change.Content HI, I have created the analysis in the subject area "Workforce Management - Worker Assignment …Farooq Syed, CPA, PMP, CISA 54 views 2 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM