Reports
Discussion List
-
Limit what data users can see in OTBISummary We want to limit certain data that the users can see in OTBIContent We have a requirement to limit data on the UI and in OTBI that the user can see. For example,…User_2025-02-04-19-36-53-958 51 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BIP report issueSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi Team, As an Admin, I can run a report and it completes sucessfully for me. Users can't…Alvaro Couto 150 views 8 comments 1 point Most recent by Sergio Arizmendi Reporting and Analytics for HCM -
We are not able see the BIP report jobs scheduled by othersSummary We are not able see the BIP report jobs scheduled by othersContent Hi All, We are not able see the BIP report jobs scheduled by others in Manage Jobs screen. We … -
Enable Allow Expansion option in Excel output-FRSContent Hi All, Our client needs to build their set of report in FRS and view output in EXCEL as they are more familiar with excel. additionally they prefer to have enab…User_2025-02-01-07-41-50-723 46 views 4 comments 1 point Most recent by Irina Feldesh, CPA, CGA Planning
-
ERP PTD is tallying with FCCS_YTD for the Feb-19Content Hi Experts, Our client started loading data from Sep-18 to Dec-18 as a YTD and from Jan-19 onwards loading will be on periodic basis. Up to Jan-19 we don't have …User_2025-02-01-07-41-50-723 41 views 8 comments 0 points Most recent by User_2025-02-01-07-41-50-723 Financial Consolidation and Close
-
Report for Absences are going into auto denial statusSummary Report for Absences are going into auto denial statusContent Report for Absences are going into auto denial status We have Absence going into Denial status, not …Mansur Khalil 62 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Workforce Trend Real Time - Calculate Weekly TurnoverSummary Trying to use Workforce Trend Real Time and Worker Assignment Event Real Time to calculate weekly turnover ratesContent Hi! I'm trying to create a report showing…User_2025-01-28-04-09-16-818 166 views 4 comments 1 point Most recent by Lauren Owen Reporting and Analytics for HCM
-
Analyses showing list of users with a specific RoleSummary Analyses showing list of users with a specific RoleContent Hi, Can I create Analyses (not data model based BIP report) showing a list of users with a specific Ro…Manoj.Gupta 87 views 16 comments 7 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Performance Rating Level Name for Section and ItemsSummary Show Rating Level Name for both section and item when they use the same rating modelContent Hi, I kindly need to know if there is a way to display section rating… -
Export Pivot Table with >75k rows (Data Model)Summary Trying to export Pivot but keep hitting row limitContent Hi, I have a pivot view on a report that I need to export out in to Excel. Unfortunately, the list canno…User_2025-02-05-15-09-04-091 34 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Audit Log on reportsContent Hi Experts, We are having multiple BI publisher and OBIEE reports set up in UAT and production environments. What is the most efficient way to run audit on the r…User_2025-01-30-00-14-06-021 144 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
What's New in 19.09?Summary ...getting this in under the wire!Content Yes, I know I’m posting this a little later than normal as 19.09 is set to hit Test pods in a few hours but rest easy a… -
Fiscal Year ReportingSummary Reporting from 1st date of fiscal year up until today, and from tomorrow up until last date of fiscal yearContent Hi, I am still very new to OTBI and SQL. What I…User_2025-02-05-10-44-58-756 62 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Benefits Service DateSummary Where do we find the field for benefits service date in OTBI. We are needing to pull that field into many reports but only find other seniority dates.Sarita Schumacher 57 views 6 comments 0 points Most recent by Maria VanderMolen Reporting and Analytics for HCM
-
If we can track if the BI report last modified by which userContent Hi, We need to find last modified by on DM and Reports , if we can track if the BI report last modified by which user Regards NidhiNidhi Chhajed 61 views 6 comments 1 point Most recent by Nidhi Chhajed Reporting and Analytics for HCM
-
Oracle Learning Cloud (OLC) OTBI Reports not pulling employee dataSummary Using OLC Subject AreaContent Hi all, I'm trying to create a report in the OLC Subject area. I've been able to pull in the Learning information, but I can't pull…User_2025-01-31-00-25-12-234 37 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extracting a field effective to specific dateContent Hi all. i'm creating an internal mobility and promotions OTBI report based on Assignment Event subject area. i'm filtering all "internal mobility" and "promotion…User_2025-01-30-20-17-38-289 51 views 5 comments 0 points Most recent by User_2025-01-30-20-17-38-289 Reporting and Analytics for HCM
-
FR report with 2 gridsSummary Need to create a FR Report with 2 grids from 2 databaseContent Hi everyone,I'm in a move to cloud and I have some reports from financial reporting that have one …Mayela de la Vega Duque-143698 37 views 3 comments 0 points Most recent by Mayela de la Vega Duque-143698 Planning
-
BI Publisher Handle No Data in RTF TemplateSummary BI Publisher Handle No Data in RTF TemplateContent How to handle no Data in RTF template to show a message in RTF instead to generate the report. The XML has 2 l…Misael Gutiérrez-Oracle 84 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
OTBI Report formattingSummary Trying to move data around to get everything in one row.Content I am trying to make each of the phone types its own column so that everything will appear in one …Brittany Lewis 248 views 29 comments 2 points Most recent by Renuka Nuguru-Oracle Reporting and Analytics for HCM
-
OTBI reporting on expired approvals/transactions not workingSummary The delivered subject areas do not allow for 'expired' status to be reported upon.Content We have recently configured our approvals to expire after 21 days if th…Denise Rae 50 views 7 comments 0 points Most recent by Manivannan Ramar Reporting and Analytics for HCM
-
Goal Status Report - Capture Associates With and Without Goals CreatedContent We are attempting to create a performance goal tracking report that captures associates who have created goals as well as associates who have not created a goal …User_2025-01-23-23-27-03-729 132 views 6 comments 1 point Most recent by User_2025-01-28-05-32-59-092 Reporting and Analytics for HCM
-
Optionally display analysis filter at bottom of reportContent I have the filter appear at the bottom of my analysis. Is there a way for this to optionally show? For example, it appears on the bottom of the report but the us…Annette M 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to count by hierarchy level only the managersSummary Need to create an OTBI analytic which will count from level to level only the manager not the ICsContent Hi all, I was able to create an analytic which shows alr…User_2025-01-23-22-38-50-675 73 views 4 comments 0 points Most recent by User_2025-01-28-20-24-47-566 Reporting and Analytics for HCM
-
Typing members into formula bar returns error (in Reporting Web Studio)Summary Sometimes, entering a member into the formula bar directly returns an "invalid member" error messageContent Sometimes, but not all the times, and I have yet to u…
-
Count FunctionContent Hi Guys, I need to realize a report that bring me the number of course assignment characterized by a specific status, But if i use a simple count on name of empl…Giuseppe Iacono 47 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display condition based counts in OTBI pivot reports?Summary How to display condition based counts in OTBI pivot reports?Content Hello All - Looking for your inputs on this pivot report. I have a condition like this (CASE …User_2025-01-25-04-02-13-126 37 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM