Fusion Financial reporting
Discussion List
-
Lease Accounting - Generate Full Amortization Schedule on DemandHi ERP Reporting Gurus! I'm trying to build a report that effectively recreates the full lease detail report that is generated when you create the lease or make an amend…Patrick Northcraft 1 view 1 comment 0 points Most recent by Patrick Northcraft Reporting and Analytics for ERP -
Will the transition of FRS reports to Oracle Reports in June '25 impact ERP reports too?Since Web Reporting Studio and FR reports are going to be deprecated, will it impact existing ERP reports in FRC. Users are currently running GL Financial Reports from t… -
Copied/Renamed OTBI Report Not Showing in Scheduled Process ListI copied an out-of-the-box OTBI report to my custom folder and renamed it. However, when I try to run it from Scheduled Processes, the report doesn’t appear in the list …
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 151 views 7 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Can the Workflow Transactions Listing report show workflows other than related to invoices?Summary: There is a Scheduled Process called 'Workflow Transactions Listing' which shows pending and rejected transactions related to invoices. Is there something simila… -
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…Lavina Bansal 374 views 4 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 2K views 11 comments 3 points Most recent by Luke Quell Reporting and Analytics for ERP -
Is there anyway to extract Essbase cube data to connect with Powerbi beside smartview File?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to print prompted value as a header text in FRS report?In a custom FRS Balance Sheet report I have a requirement to print the prompted values as a selected parameter in the header section as a text value. Also I want to show… -
While creating FRS Report, I cannot find "Budget" choice when open Scenario DimensionHi All, Please we are creating a Financials Reporting Studio Report to compare between Actual Vs Budget. I have added "Scenario" as a column in the report, and when I ha…
-
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
Which table holds the error details for unsuccessful imports of Customer Credit hierarchy data?Summary: Hi Team, I am in the process of importing "Credit Hierarchy" data through "Import Management" (Object = Hierarchy & Hierarchy Member) and am working on a BIP re…Dhilip Kumar P. 1 view 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 547 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.User_DDXB9 72 views 11 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 6.6K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
Financial reporting studio books doesn't have an option to download in excelSummary: Any work around to this? Currently it allows only pdf and html. Users would like to download the whole book as an excel Content (please ensure you mask any conf…
-
Are XPath functions fn:tokenize, fn:matches, and fn:replace are not supported by Oraclee?Summary: Hi, I am new to XSLT development, As part for customer requirement I have used tokenize function for looping. But PPR formatting is failing because of this. Err…Tejeswar J E 13 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Configure audit rule in oracle expense 1. all cash expenses to be audited 2. personal expense on CCSummary: Configure audit rule in oracle expense with following condition- 1. all cash expenses to be audited 2. all personal expenses on Credit card to be audited 3. the…
-
For the customized Print receivable transaction report, the ess job fails with errorSummary: As part of the Run , our Print Receivable Transaction Report job is failing and the ESS log message provides us the below error message AR_ESS_PLSQL_WRAPPER_PKG…
-
Difference between Enabled for UI and Enabled for All of Smartview WebView2 RuntimeSummary: Customer uses both on-premise hyperion and Oracle Fusion ERP Cloud applications (Not user of EPM cloud). In hyperion, they faced an issue before, so the reply f…CS Yuen-Oracle 11 views 0 comments 0 points Started by CS Yuen-Oracle Reporting and Analytics for ERP
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…Patrick Chrabieh 54 views 6 comments 0 points Most recent by user10987169 Reporting and Analytics for ERP -
issue with the link between gl_code_combinations and ZX_ACCOUNTSSummary: I am creating a report to gather the taxes and all invoices related to this tax. Content (please ensure you mask any confidential information): I used the below…
-
Highlight Duplicate String ValuesSummary: Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible? We're u…
-
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
Need Cleared check report in Oracle fusion without reconciliation processSummary: Hi, The business is using check payment method and issuing checks and they are using cash account when they issue payments. So there is no reconciliation proces…
-
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…