Reports
Discussion List
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo… -
How to exclude few ICP entities while running Inter company matching ReportSummary: How to exclude few ICP entities while running Inter company matching Report Content (please ensure you mask any confidential information): Hi team, While runnin…DISHIL SHAH 32 views 6 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.4K views 84 comments 9 points Most recent by Sean Rogers Reporting and Analytics for ERP -
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …Helen Tilling 137 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 71 views 10 comments 0 points Most recent by RajuKumarOracle-Oracle Reporting and Analytics for HCM -
Report Location syntax not producing in book outputsWhen using ReportLocation() in Header Body or Footer it will render in a report using HTML preview, PDF or Excel as expected. Outputs When added to a book, PDF or Excel … -
ASO Cube OptimizationSummary: We are experiencing performance impact in ASO Cube for Custom Workforce application. Content (please ensure you mask any confidential information): We have a Pl… -
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo…
-
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 45 views 0 comments 1 point Started by Dave Roberts_-Oracle Narrative Reporting -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…Yaniv 761 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM
-
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 63 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…