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 55 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 148 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 … -
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 68 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 173 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 91 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 39 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 150 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM -
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 63 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 62 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 66 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 42 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 60 views 5 comments 0 points Most recent by User_2025-01-30-20-17-38-289 Reporting and Analytics for HCM -
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 81 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 253 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 54 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 136 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 35 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 77 views 4 comments 0 points Most recent by User_2025-01-28-20-24-47-566 Reporting and Analytics for HCM -
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 51 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 40 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
BI Publisher : Edit button on the Search windowSummary How to enable the Edit button on the Search box in BI Publisher reportsContent Hello, Has anyone Know how to enable the edit button on the search dialog in a BI …Eduardo Nava 65 views 2 comments 0 points Most recent by Eduardo Nava Reporting and Analytics for HCM -
Toggle to include/exclude a column on reportContent I have an analysis that I want to prompt the user to include or exclude the SSN. I would rather do this than to maintain two reports. How would I create a prompt…Annette M 35 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Oracle capability in HRIS teamContent Hi Experts group, Today i have a generic question and not technological. My current organisation installed Oracle HCM Cloud in 2017 October and since then I am w…User_2025-01-30-00-14-06-021 60 views 5 comments 2 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 182 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
How can we exclude the login user from the Headcount in the OTBI AnalysisContent How can we exclude the login user from the Headcount in the OTBI Analysis. We have are requirement, If a manager logs in and execute the report to see the headco… -
Only able to see Line Mangers in Worker Assignment subject areaSummary When reporting manager's information, I can only see records of Line MangersContent Hi I'm doing a report where I need to pull all the different managers that an…Rogelio H 71 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create QR code in RTF template for OTBISummary Create QR code in RTF template for OTBIContent I am trying to implement a QR code for the employee number I have followed the documentation: https://docs.oracle.…Cesar Tepetla Corte 102 views 6 comments 0 points Most recent by Ognjen Pavlovic, HCM Product Management-Oracle Reporting and Analytics for HCM -
Fields added to custom RTF don't show and fields removed still showContent Hello All, I have customized a seeded RTF where I added DFFs to the RTF template and removed unwanted fields from the RTF. However, when I print the document fro…PriyaPenugonda-SC 47 views 9 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM