Fusion Financial reporting
Discussion List
-
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 177 views 9 comments 0 points Most recent by User_O1LQ5 Reporting and Analytics for ERP -
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…
-
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…
-
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 2.8K views 77 comments 9 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
To fetch all the approval group details for a journal.Hi, I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal. Plea…Chitti Damoder 7 views 0 comments 0 points Started by Chitti Damoder Reporting and Analytics for ERP
-
How to add filter to obtain prior financial period transactions?How do we create a filter on an OTBI analysis to return the prior financial period's transactions based on current date? Requirement: We need to schedule a report to del…Elaine Hendry 20 views 3 comments 0 points Most recent by Elaine Hendry Reporting and Analytics for ERP
-
We are having an issue with reports showing with trial balance for mexico report for occasional userSummary: When running the trial balance report for Mexico from the RFC, it does not display any data. This happens with a specific user. What could be the cause? The use…arin innovation 7 views 0 comments 0 points Started by arin innovation Reporting and Analytics for ERP
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…
-
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…
-
looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre ManagerHi All, I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both: The Notifications table…
-
FRS Report not displaying any output (Blank screen on execution)Summary: While executing the FRS report for a specific accounting period, the output page appears blank despite correct parameter selection and confirmed data availabili…
-
Intercompany Payable and Receivable representation in FRS reportsHi, Currently we are maintaining only one natural account for Intercompany Receivable and Payable. In other terms, if the account has a positive balance, it will be cons…
-
FRS Report is opening in multiple tabs for some users and not for others. Is there a specific setup?Hello, We have created a consolidated FRS report for one of our clients and when the user downloads the report, it opens in multiple tabs in excel for one users. For oth…Shriya Srinivasan 7 views 0 comments 0 points Started by Shriya Srinivasan Reporting and Analytics for ERP
-
Assistance required to create Requisition Bucket with Bar graphHello, I am seeking assistance in developing a Requisition Aging Bucket in OTBI. The goal is to create a bar graph to present summarized requisition data on a dashboard.…
-
Can we populate currency based on the ledger currency in FRS Report in Oracle FusionHi, We are currently building a financial report using Financial Reporting Studio (FRS) in Oracle Fusion/ERPCS, and we are exploring options to dynamically populate the …Varalakshmi Guduru 28 views 2 comments 0 points Most recent by Varalakshmi Guduru Reporting and Analytics for ERP
-
Getting an error when trying to add another column in OTBI Rep for a DFFSummary: There is a custom field (DFF) on the Customer Sites (Receivables) which we are trying to add to an existing OTBI Report. After adding it to the report, getting …
-
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_BUser_2025-03-07-18-57-57-349 412 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Sql to reconcile Receivable Invoices' balances with their applied receiptsSo, I have constructed a sql query to look at Receivables balances using ra_customer_trx_all and ar_payment_schedules_all. I have another query which I tried to summaris…Robert of STAU 1.2K views 5 comments 0 points Most recent by gkulkarni Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 73 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…Rama Mohan ReddyB 11 views 0 comments 0 points Started by Rama Mohan ReddyB Reporting and Analytics for ERP
-
How to control or restrict OTBI access?Summary: We need to control OTBI access from accidental deletion of a folder/report and moving reports from one folder to another from business users? Content (please en…
-
What are the Best practices when implementing Fusion Cloud HCM Succession Management and TalentSummary: What are the Best practices when implementing Fusion Cloud HCM Succession Management and Talent Please share the What are the Best practices when implementing F…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 34.2K views 94 comments 55 points Most recent by JayanthP Reporting and Analytics for ERP
-
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single RowRama Mohan ReddyB 13 views 2 comments 0 points Most recent by Rama Mohan ReddyB Reporting and Analytics for ERP
-
Report Rendering Failure – IO Exception "19 >= 19"Summary: Hi, We're encountering a rendering issue with a BI Publisher report in our Oracle Fusion environment. Upon execution, the report fails with the following error:…