Reports
Discussion List
-
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 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
user with predefined Viewer role cannot access FRS reportsSummary: Hello everyone, I have seen in the past that Viewer could access reports if I remember correctly. Is this an expected behaviour from recent updates? The user in…
-
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 31 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 152 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 11 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… -
Display the FCCS_Consol Method as numbers in ReportsSummary: Display the FCCS_Consol Method in Reports Content (required): I have a requirement to display the FCCS_Consol Method in the Report columns for each entity. When…
-
Revenue Generation: How to ignore all migrated dataSummary: We are now live with Fusion ERP. Old projects and transactions have been migrated. Transactions are non-billable. Revenue is migrated using events. For new tran…
-
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…
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.06What’s New in EPM Cloud Narrative Reporting and Reports Release 22.06 Please refer to the June 2022 What's New Guide to understand the new features included in EPM Cloud…Dave Roberts_-Oracle 11 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
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 51 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.9K 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 79 views 18 comments 0 points Most recent by Natalie A. 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 11 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 41 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 136 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 101 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Rehire Recommendation Details Isn't Coming in ReportSummary Rehire Recommendation Details BlankContent Hello All, This is Harmender, hope everything is fine at your side. I have created one subject area report for rehire …User_LO0GO 35 views 4 comments 0 points Most recent by Poorani Gibson Reporting and Analytics for HCM
-
BI Publisher Style Templates vs Online Layout BuilderSummary: How to deliver a consistent look and feel in BI Publisher reports Content: I'm trying to improve my skills with writing BI Publisher reports and learn about Sty…
-
No Data in OTBI when Department Name is addedSummary: Content (required): We are using Subject Area "Workforce Goals - Goal Plan Assignments Real Time". When we add Worker.PersonNumber then we are getting all the 1…Vinay Gharge 23 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s…Rona Jeongco 83 views 2 comments 0 points Most recent by Rona Jeongco Reporting and Analytics for ERP
-
Logical SQL is not recommended?Summary If Logical SQL isn't the answer what is the recommended approach?Content Hello Everyone, I've been told through a recent Technical SR that Logical SQL is not a r…Rob F 66 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM