OTBI
Discussion List
-
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 122 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
procurement work confirmatSummary: Subject Area for Purchase Order Work Confirmation Please i need to know if there's a subject area in OTBI which stores the data for work confirmation for procur…Mona_ahmed 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report Hours Worked/Processed by PayrollSummary: I need to be able to report hours processed by payroll from beginning of the year to current. I cannot use the timecards. I thought it would be in the payroll r…Jessica D 22 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Does anyone have a EEO-4 that meets the layout specifications they would be willing to shareSummary: We are required to submit an EEO-4 report by December 5, 2023. Content (required): The EEO-4 report is a mandatory biennial data collection that requires all st…Emily Wilde 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Learning - Reporting on Penetration RateSummary: We would like to be able to report on the penetration rate of our learning module. I think the idea is to report the percentage of people assigned to a learning… -
Person Real Time Subject Area and Future Hire DateSummary: I have a simple report/analysis using the subject area Workforce Management - Person Real Time. This report is used to extract 2 custom Extra Information fields…
-
Report Usage Metrics OTBIContent Does anyone know how I can pull usage metrics of reports run by users in OTBI. I've searched for some time on this online, both here and Google. I see there was …User_2025-02-01-05-53-06-489 125 views 7 comments 0 points Most recent by erpexpert03 Reporting and Analytics for HCM -
OTBI Formatted and Data Export LimitWe are exporting OTBI reports that has more than 300k rows. We're able to export 75k rows in Formatted Excel and 300k rows in Data format options. Anyone has specific nu…CAMIL_Q 169 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
Is it feasible to Print an Entire Dashboard (with multiple pages)?Summary: Is it feasible to Print an Entire Dashboard (with multiple pages)? Content (please ensure you mask any confidential information): I would like to print an Entir…Harish Malik 31 views 4 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Headcount as of date - security scopeContent (required): I am working on a headcount dashboard for HR employees, so that they can see the headcount as of date (number of employees, FTE etc). I am facing an …Jacqueline GRANDIN 12 views 5 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM
-
Areas of Responsibility data security not being pulled through to OTBISummary Areas of Responsibility data security not being pulled through to OTBIContent Hi all We are currently testing R12 and redefined our data security profiles using …User_2025-01-23-21-25-57-924 192 views 11 comments 2 points Most recent by BrittaniR Reporting and Analytics for HCM
-
How can we enable visibility on OTBI Absences for a user?Summary: Hi all, We have a user who as per their profile can access Absence Records, but cannot view Absence reports in OTBI - any idea how to get round that? Any privil…Cora_Stanciu 13 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative …Mirza_Adeel 33 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Measuring the Completeness of Onboarding Task by EmployeeSummary: Measuring the Completeness of Onboarding Task by Employee Content (please ensure you mask any confidential information): In the Onboarding report use the Checkl…Thulasi Ram 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to get the list of employees with change in payroll groupSummary: Report to get the list of employees with change in payroll group Content (required): Hi Team, Greetings! The change in payroll group, especially from weekly to …Parag Hiremath 31 views 5 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Subject area changesSummary: Advanced notice of SA Changes. Content (please ensure you mask any confidential information): Document 2431130.1 provides guidance on subject areas that can be …Ms_Oracle 32 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Returning information from the middle of the valueSummary: Hi our work location fields are in the format "UK-[city]-[street address]", but when I run an analysis I only want to return the city name. Is this possible? Is… -
Subject area joinsHello all, I am trying to create an analytic using two different subject areas. I found this; USER GUIDE: How to join data from different subject areas using union — Clo…Peter Downer 42 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manager Name not updating in AnalysisContent Hi, I have an OTBI analysis that display incorrect information from regional and resource managers. For some reason a manager change is not coming through despit…Javier Quiñones 147 views 6 comments 1 point Most recent by Mirza_Adeel Reporting and Analytics for HCM -
Create an OTBI Analysis with information about all transactionsSummary: Hi all, I'm trying to extract information from the transactions subject area "Human Capital Management - Transaction Administration Real Time". The customer wou…teresa.marciano 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 21 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Adding two person types into one OTBI analysisSummary: According to our current practice when employees are retiring we change their person type into "retiree" in the system. I need to create an analysis to capture …Ayesha Iroshani 24 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
how to enable https://www.google.com/jsapi'></script> at otbiSummary: I took from sharing center report for org char it is not working because I don't know how to enable the sceipt Content (required): window.onload = function(){…Yechiel 42 views 16 comments 0 points Most recent by Charles Egegbara Reporting and Analytics for HCM
-
Supervisor Hierarchy (Top/Down) Managed departmentsSummary: Supervisor Hierarchy (Top/Down) spanning multiple departments Content (required): We are trying to develop an OTBI report displaying reportees spanning multiple…Manoj.Gupta 71 views 3 comments 6 points Most recent by Gloria Brewster Reporting and Analytics for HCM -
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val…
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
OTBI subject area for Job responsibilitiesSummary: Looking for the subject area to report on job responsibilities and weights associated. From the job profile Content (please ensure you mask any confidential inf…