Fusion Financial reporting
Discussion List
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…Krishan_Palihakkara 107 views 1 comment 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for ERP -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 276 views 5 comments 0 points Most recent by Bhagchandani Nayan Reporting and Analytics for ERP
-
Is it possible to edit and add column in Manage Invoice report on Fusion screen?Summary: Is it possible to edit and add column in Manage Invoice report on Fusion screen? User want to add one column in the output report from Manage Invoice. Content (…
-
Deep link for Journals to view Journal Entry ScreenSummary: Hi Team, Need some details about the Deep link for Journals to view the Journal. In BIP report on Journal Batch Name column , respective journals can be opened …
-
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
Need Information on Parameters for AP_TRIAL_BAL_REPORT_PKG.BEFORE_REPORTWe are using a customized version of the Payables Trial Balance Report to pull one specific account via custom parameter on the data model. We would like to add another …User_2025-07-18-08-13-53-790 112 views 3 comments 0 points Most recent by User_ZLZWZ Reporting and Analytics for ERP
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 1.2K views 6 comments 1 point Most recent by RKSharma Reporting and Analytics for ERP -
Which table has Journal Transaction details?Hi, Does anyone know where the details below can be found in the Oracle Fusion? This is inside of a Journal Transaction
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 937 views 7 comments 7 points Most recent by Marwa Reporting and Analytics for ERP -
Facing issue with FRS report after migrating to another instance.Facing issue with FRS report after migrating to another instance. Getting "Unknown Member Issue" even when the hierarchy and account existsLakshmiVanarasi 31 views 10 comments 0 points Most recent by LakshmiVanarasi Reporting and Analytics for ERP
-
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…Jahnavi Konduru 23 views 2 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 221 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Please provide join logic for tables within the pvo SubledgerJournalDistributionPVOSummary: As part of our project we are extracting data from the underlying tables inside PVO. Could you please provide the join logic across the below set of tables GL_L…
-
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS reportLakshmiVanarasi 12 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Grouping in FRS based on parameters passedCompany Cost Center 1111 11111 2222 22222 3333 33333 If user selects the above combination in the parameters in an FRS report, the data should be fetched for the sum of …PrerakKhandelwal 41 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
FRS report for particular ledger and Period not returning Data. What may be the reasonSummary: FRS report for particular ledger and Period not returning Data Content (please ensure you mask any confidential information): Summary: FRS report for particular…
-
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…User_F2YWU 11 views 4 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…OsvaldoFI 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 164 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r…bobby.hussey 94 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias…Suriaraj.Krishnamurthy 2 views 3 comments 0 points Most recent by Suriaraj.Krishnamurthy Reporting and Analytics for ERP -
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
Construction Industry Scheme (CIS)Summary:Construction Industry Scheme (CIS) Under the Construction Industry Scheme (CIS), contractors deduct money from a subcontractor’s payments and pass it to HM Reven…Sofia Chen 55 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can I apply a Receivables Credit Memo while referencing the Invoice Transaction number in FBDI?Summary: While uploading Receivable credit memos via FBDI, I aim to automatically apply open invoices by providing references in the sheet. I'm aware of using the Refere…
-
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 106 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP