Reports
Discussion List
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 443 views 6 comments 0 points Most recent by User_HSKEJ Reporting and Analytics for HCM -
What’s New in EPM Cloud Narrative Reporting and Reports Release 26.04What’s New in EPM Cloud Narrative Reporting and Reports Release 26.04 Please refer to the April 2026 What's New Guide to understand the new features included in Cloud EP…Dave Roberts_-Oracle 77 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
BIP report layout hyperlink works with hard-coded parameter, but not with dynamic field valueSummary: I am trying to create a drill-through from one BIP report to another. The source report is a report created with the Layout Editor, and the layout file ends in …Sherie Ross 21 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Rest API or CLI command scripts to export and import of HCM extracts from one instance to another.Summary: Any Rest API or CLI command scripts to export and import of HCM extracts from one instance to another. Any documentation for the same or for other technical obj… -
avoid divide by zero errorSummary: I'm trying to avoid a divide by zero error, but even when I use a formula to do so it still seems to manifest - any ideas? Content (please ensure you mask any c… -
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 194 views 10 comments 0 points Most recent by Rosita Santosuosso Reporting and Analytics for ERP -
Set different alias tables for different columns/rows.Suppose in my report i have selected alias table A, which is what I want for my Accounts which are present in rows. Now for the Entities present in columns, i want to us… -
Concatenate Cell Text or Value within ReportsHello, I'm trying to build a report within the Reports section of Planning that will concatenate a Member Name with the Cell Text or Value from the output of the report.… -
Can I use Copilot in narrative reportingSummary: I want to integrate Microsoft CoPilot into Narrative Reporting reports with Gen AI to utilized summary of the comments with Gen AI and Comments submitted by the… -
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera… -
User is unable to enter the comments in Narrative ReportingSummary: The users have below access, but still they are unable to enter the comments in Narrative Reporting (Can view the comments entered by Admins, though) Power User… -
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a… -
Query to get Languages in ORCSummary: Based on the screenshot I provided, What table in HCM can I get the list of values for the Languages in ORC. Content (please ensure you mask any confidential in… -
Is there a way to change the default export format to xlsx in ERP?Summary: We use Excel 2024. When exporting reports out of ERP, they default to Excel 2007. Is there a way to change the export format to xlsx? Content (please ensure you… -
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which …Sara Suleiman 21 views 3 comments 0 points Most recent by Sara Suleiman Reporting and Analytics for HCM -
EPBCS Reports vs EPCRS Narrative Reporting reports: what tool to choose?Summary: I need to build simple tabular reports with the possibility of creating books from these reports. No complex formatting or commentaries are required. The report… -
Dynamic Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question… -
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …Shirlene Chan 61 views 7 comments 0 points Most recent by Ravi Shinde Reporting and Analytics for ERP -
Financial Reporting Studio Issue: 2026 Data Not Appearing (current Year)Dear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2026 data in our reports. Pervious year data showi… -
Can Reports in the Navigation Flow be configured to open in a new browser tab?Can cards in the Navigation Flow be configured to open a report in a new browser tab (similar to how drill to content links within reports will open new browser tabs)? I… -
Is it possible to preserve report prompts?Summary: Here is a screenshot from a PowerBI dashboard. I selected two members (highlighted in the green box). The report shows me details for the selected members and t… -
We tried to use Reflect Changes from Edited Reports Sooner solution in fusion but it is not workingSummary: Hi team we have made the changes in the PR PO Approval Pages as per our requirement. We need to test the output. As a standard functionality system will take 24… -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 382 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM -
How to create a report that includes employee information and the date of the last system access.?I'm trying to create an analysis with the last access information of employees to Oracle Fusion Cloud and I'm having trouble. Could you help me retrieve this date in the…Fernando A Nascimento 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…Opkey PA 2 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 8 comments 0 points Most recent by Chiranjeevi Boya Reporting and Analytics for HCM -
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 11 views 7 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM