Reports
Discussion List
-
when I open the PDF format output of Bi publisher report its not downloaded automaticallySummary: Hi Team, when I open the PDF format output of Bi publisher report its not downloaded automatically. any option to set the download the automatically when i open…AjayKumar Maddipati 60 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Job Agent Sending to Removed RecipientSummary: Job Agent Sending to Removed Recipient Content (required): I had an OTBI report job agent and needed to change the recipient list, however, after saving the new… -
Narrow Chart Down to Top 10Summary: We are trying to create a bar graph of the top 10 jobs that termed for the year. Is there a way to only show the top 10 rather than all the jobs?Rebekah Gilday 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add New Column Based on Days Between Two Dates ResultI'm using the Subject Area Workforce Management - Work Relationship Real Time. Below is a formula that calculates the number of days between Termination Notification Dat…
-
Termination Bar Chart by MonthSummary: We are trying to make a Bar Chart to show # of term by Calendar Month but the format of the month looks strange. Is there a way to list Calendar month with name…Rebekah Gilday 2 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 22 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
TemplateSummary: Hi all, Problem statement: I created the attached template in RTF-> linked to the report -> export the output in pdf but now client wants to have the output in … -
Combine 2 Analysis Outputs in on AnalysisSummary: Content (required): I have requirement to report on the number of starters by user person type and leavers by user person type in the previous month and email t… -
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…Anita 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to use Crystal Reports with Oracle HCM data?Summary: Is it possible to use Crystal Reports with Oracle HCM data? Content (required): I have had many years of experience with Crystal Reports in multiple HCM systems…Donna Valentine 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How do I set an OTBI agent to only Email if there is data returned in analysis?Summary: How do I set an OTBI agent to only Email if there is data returned in analysis? Content (required): Hello I am trying to set up an agent but I only want to it t…Helen Thomas 22 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 52 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
RTF TemplateSummary: Hi Team, I am working on a report where the template used is RTF template. This report captures data both for pensioner and employee. Requirement is like if per…
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 131 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Leavers not showing now on manager dashboardsSummary: Leavers show very small numbers or nothing Content (required): My dashboard reports have been working fine but now I'm getting reports from managers that they c… -
Talent Score - deep link in BIPSummary: Does anyone know if you can deep link from BIP to the Talent Score screen? I think it is here: My Team > Career and Performance path, page titled “Goals and Per…Andrew_Schmitz 12 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for HCM -
Links with BI Publisher when using With ClauseSummary: Data sets using the With Clause lose the ability to create links between datasets Content (required): I'm trying to leverage the powerful WITH clause in a bi pu… -
HCM Field VS Subject AreaSummary Trying to find a document that tells me which field on the front end maps to which subject area and fieldContent Hi, I am trying to figure out the best way to fi…
-
Need help to build the sql logicSummary: Hi Team, I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record …Mohan Murali 43 views 3 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…Mohan Murali 1.7K views 6 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Performance Rating History OTBISummary Looking for an OTBI report with Annual Performance Ratings for the last 3 yearsContent Hello I am looking for an OTBI report with Annual Performance Ratings for …User_2025-02-10-08-27-16-805 70 views 18 comments 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM -
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da…Gerardo Peluso 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Logical SQL Dashboard Not Working After 22BSummary: Hi - we have a report that pulls payroll information and salary information. It is run weekly by our compensation team. It was working fine through last week an…Kyle Norris 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Line Manager can't see Time cards in OTBISummary: Content (required): Hi The Line Manager role can't access time card reports (standard Oracle Time Cards). The reports are standard and delivered by Oracle. The …Nicolas Vahman 45 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER…
-
Folder Level Security (Idea/Feasibility)At our organization, the staff is used to our discoverer reports where one report will pull from multiple tables/views, after asking around and looking at OTBI security …Praveen Kadiyala 41 views 5 comments 0 points Most recent by Praveen Kadiyala Reporting and Analytics for HCM
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…User_2025-02-05-07-43-29-505 138 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…Rob Stahly 92 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM