OTBI
Discussion List
-
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 124 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 201 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 11 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 186 views 11 comments 2 points Most recent by BrittaniR Reporting and Analytics for HCM -
How to create a custom Infolet using a query example?Summary: Hi, we need to create a custom infolet by a query example Content (please ensure you mask any confidential information): There is a away to create a custom info…Alex Pagliarini - Ninecon 21 views 4 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management -
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 42 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM -
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 11 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 31 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 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
We have to create an Custom field in sales order page.Summary: We need to create a custom column in Sales Order, That can be updatable at any point of time. Content (please ensure you mask any confidential information): Ver…KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Sandeep Kurur-Oracle SCM Product Management-Oracle Order Management -
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 31 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 41 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 155 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 11 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 -
User should have Inquire access for one Bu and Transactional access for other BuSummary: User should have both Inquiry and Transactional role for one business unit but they should have only inquiry access for another business unit. For example user … -
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 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Stock Value AgingSummary: Stock Value Aging Content (please ensure you mask any confidential information): Hi, Can someone please inform me the query or tables/fields involve in calculat… -
Advice on Printed Transaction in OTBI subject areaSummary: OTBI Receivables subject area is there a field which is a result of 'DELIVERY_METHOD_CODE' from ra_customer_trx_all data table as "Receivables - Transactions Re…Jesús Vega-Oracle 2 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections -
Supplier Analysis Prompt not displaying from ReportsSummary: I created Supplier ACH Verification Analysis with prompt for user to select Supplier Name prior to displaying results, however when user opens analysis from Rep…Eybrown 1 view 1 comment 0 points Most recent by Veronique Gagnon Payables, Payments & Cash Management -
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