OTBI
Discussion List
-
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 28 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 23 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 130 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 202 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 37 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 17 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 191 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 15 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 38 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 8 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 37 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 36 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 47 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 156 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 19 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 26 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 29 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 41 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 79 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…
-
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex…Rebekah Gilday 99 views 9 comments 0 points Most recent by Diane G123 Reporting and Analytics for HCM -
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will …
-
We have a requirement to fetch salary component calculation columns in OTBI and a stat graph.Summary: We have a requirement to fetch all these calculation columns in OTBI as we have partially developed the solution in BIP, but client want this in OTBI so can we …Kumar Rajgeet 46 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM