Reports
Discussion List
-
Excessive delays generating XLS output files from Report books starting mid-March 2025Summary: Excessive delays generating XLS output files from Report books Content (please ensure you mask any confidential information): Starting on March 24, 2025, our re…Sean L. Lydon 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Tax Audit Trail Report export to excel not working properlySummary: Tax Audit Trail Report export to excel not working properly. This started happening in Feb25 after patch. HTML looks ok but when you export to excel it is messe… -
fdi first valueIn FDI what is the formula to get the first value (or last) for a field that may have multiple values. Instead of displaying multiple rows that show each of the values I… -
Our customer needs to identify the report path in OTBI related to an Infolet.Our customer needs to identify the report path in OTBI related to an Infolet. Please see the attached document (Infolet-OTBI.docx and HELP-OTBI-PATH.docx) attached here.…Oscar Chahestian-Oracle 4 views 0 comments 0 points Started by Oscar Chahestian-Oracle Reporting and Analytics for ERP -
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…User_2025-02-06-06-16-56-136 231 views 4 comments 5 points Most recent by BillM Reporting and Analytics for ERP -
How can we see the Reports which are there in My folder of Other UsersSummary: We want to see the reports which are there in My Folder of all other Users. Is there any other way we can do this without logging into each individual user and …Shrikrushna 67 views 15 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP -
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co… -
Are there any roles to provide read-only access to a data model in oracle fusion?Summary: Hi, I want to provide read-only access to one data model to one of our users. Is there any roles or configurations that will help in providing read-only access …NagarajuKunchala 20 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP -
Are there available audit reports to track master data changes?Summary: Client wants a report to track master data changes - customer, supplier, system configurations. Are there available seeded reports to cater to this requirement?…len.baetiong-Oracle 23 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Cash Flow Statement Generation - FRS or Other Reporting ToolsSummary: Cash Flow Statement Generation - FRS or Other Reporting Tools Content (please ensure you mask any confidential information): Hi Experts, Please advise as to whe…Nicole Deleon 19 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Customization of Standard Contract Preview ReportSummary: Hi Team, I am writing to request guidance on a customization for the Standard Contract Preview Report(Enterprise Contracts --> Contract Printing --> Contract Pr…Saumya Mani Tripathi-Oracle 67 views 2 comments 0 points Most recent by Saumya Mani Tripathi-Oracle Reporting and Analytics for ERP -
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 472 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Request for audit report for the changes done on BPM Worklist - FinGlJournalApprovalSummary: I am looking for a audit report for the changes done on BPM Worklist FinGlJournalApproval. We noticed some of the rules has been disabled by some user and we ne…VAS-475620 17 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP -
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.… -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 66 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP -
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 139 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Need guidance on Malaysia specific localizationWe are looking for information regarding Malaysia localization changes that have been implemented from reporting perspective. What are the possible changes we need to ca…Harshal Kailas Desale 38 views 5 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Unwanted Linefeed characters getting returned in eText outputSummary: Linefeed characters getting returned in eText output Content (please ensure you mask any confidential information): I am having an issue where there is both Lin… -
Is it possible to implement a parameter refresh function when the parameter is in date format at BIPSummary: Is it possible to implement a parameter refresh function when the parameter is in date format, like a text parameter? Content: Hi, In the SQL for the parameter …M Watanabe 14 views 1 comment 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management -
Need help : Looking for table with 'Alternate Account Owner Name'Hello, I'm currently working on a report related to customer bank accounts, and I would appreciate your support. Does anyone know which table and column store the "Alter… -
How to hide parameters in scheduled process ?Hi, we want to hide some parameters that we don't populate in a scheduled process. For example, we want to hide source locator and destination locator from "Print moveme…Daniele Landinetti 5 views 0 comments 1 point Started by Daniele Landinetti Reporting and Analytics for ERP -
Please advise how to create a scheduled report of all administrators of the oracle application?Summary: IT would like a monthly report of all administrators of the oracle fusion application. The Scheduled Process report, User Role Membership Report, contains data … -
Values exported from Financial Reporting Studio to Excel with the wrong sign!We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values present in the system (e.g. in the system the …Michele Ferro-Oracle 15 views 2 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany -
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 150 views 6 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View… -
What is the usage of ROW[#Ref] function in the Financial Reporting StudioSummary: There is a Function called ROW[#Ref] in the formula for FRS. What is the usage of it. Content (please ensure you mask any confidential information): Version (in…SuniChacko 4 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Is it possible to change the output language of the log of scheduled process?I logged into the ERP with the default language set to "Spanish." However, when I download the log file from the "Scheduled Processes" UI, the output shows information i…