Fusion Financial reporting
Discussion List
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…Shannon Short 162 views 4 comments 0 points Most recent by Akash Verma Reporting and Analytics for ERP -
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 202 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
report otbi general balances real time with hierarchieshow can i create a report balances with hierarchies in subject area? i can t see hierarchy
-
Need a sql query to fetch approver history for contract managementSummary: Need a sql query to fetch approver history for contract management Content (please ensure you mask any confidential information): Version (include the version y…Dilip.Murugan-Oracle 14 views 1 comment 0 points Most recent by Akanksha Srivastava-Oracle Enterprise Contracts
-
Extract Report OutputSummary: Extract Report Output and populate standard attachment table for Payables Invoices Content (please ensure you mask any confidential information): I'd like to kn…
-
BIACM data models not returning any valueSummary: We are building a data warehouse and needs to utilize the default models provided by Oracle via BIACM to extract values needed for this project. When started wi…
-
Track usage of Account InspectorSummary: Customer (Old Mutual Limited) asked if any options exist to track the usage of Account Inspector (Financial Reporting Center). They want to have a view of users…AVorster-Oracle 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Which table contains future budget period amount details?Summary: Hi Experts, We need to retrieve budget amount, actual amount and commitment amount for future budget periods for a report, these are the fields we see in the be…Aman Mishra 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create View Image in AP invoice pageSummary: How to create View Image in AP invoice page Content (please ensure you mask any confidential information): Hi All, We got a requirement to create one button and…Venkatesan 11 views 1 comment 1 point Most recent by Venkatesan Payables, Payments & Cash Management
-
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …Vipul_vipul 7.7K views 12 comments 1 point Most recent by Alexandru Dicu-Oracle Reporting and Analytics for ERP
-
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 135 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… -
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 154 views 3 comments 0 points Most recent by User_ZLZWZ 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
-
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 51 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 45 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 527 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 21 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
-
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 254 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…