Fusion Financial reporting
Discussion List
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.1K views 19 comments 22 points Most recent by Gaurav Kumar-100036 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…Andy Gough 4.5K views 30 comments 31 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF Reporting and Analytics for ERP
-
Balance Sheet SQL query requirement in BIPHi everyone, I need to build a custom balance sheet report in Oracle Fusion Cloud Financials using BI Publisher**,** and I’m completely stuck at the starting point. I ha…Pravesh Koonjal 1 view 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 482 views 6 comments 0 points Most recent by Raunak Kumar Singh Reporting and Analytics for ERP -
Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS ReportThe business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods …
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 12 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Asset Rollforward Report ExamplesSummary: Looking for any fixed asset rollforward report examples or suggestions. Content (please ensure you mask any confidential information): We were hoping to create … -
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 3.6K views 13 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Drill down on balances in SA General Ledger - Transactional Balances Real TimeSummary: We have created a an OTBI analysis using SA General Ledger - Transactional Balances Real Time. The purpose of the report is to show balances per natural account…ERP & EPM Cloud 2 views 0 comments 0 points Started by ERP & EPM Cloud Reporting and Analytics for ERP
-
Need Support for Missing Notifications in Fusion Expenses: Manager Reject and Audit Complete EmailSummary: Hi, We identified two missing email notifications in Fusion Expenses and need clarification on whether these events are supported as standard functionality: Man…
-
Extract the customer credit limit detailsSummary: We have requiremnet to extract the customer credit limit details. Content (please ensure you mask any confidential information): We need a report or query to ex…Mamdouh Ahmed 22 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for ERP
-
Grouping sections in a report created in Financial Reporting Web StudioPlease let us know if it's possible to collapse and expand the report information by section. For example, in this report, we need the accounts listed below the COST OF …David Hilario Padilla 1 view 0 comments 0 points Started by David Hilario Padilla Reporting and Analytics for ERP -
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…Vinay Gharge 247 views 3 comments 0 points Most recent by Yahya Khan Reporting and Analytics for ERP -
Form Personalization Column HideWe have a form personalization requirement to hide the Distribution combination field if the Invoice type is 'Prepayment' from the AP invoice lines in create Invoice pag…Arkaprabha Pal 2 views 0 comments 0 points Most recent by Arkaprabha Pal Reporting and Analytics for ERP
-
Deeplink for AR_TRANSACTION in REVIEW modeSummary: Need to view a transaction detail in Review mode Content (please ensure you mask any confidential information): Hi everyone, I noticed that when I open a comple…MCAUK 561 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Receivables & Collections
-
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 597 views 19 comments 2 points Most recent by cylim Reporting and Analytics for ERP -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
Roles that can create and update, or only view Financial Reporting reports connected to GL EssbaseThis concerns roles that can create and update, or only view Financial Reporting reports connected to GL Essbase. We need to understand two types of roles: one that only…
-
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work…Patricia Gonzalez 56 views 5 comments 0 points Most recent by Sean Rogers Reporting and Analytics for ERP -
Which FUSION tables OTHER than per_email_addresses per_ldap_users hz_parties store user emailSummary: I need to find the table(s) where user email addresses exist in Fusion. I've checked per_email_addresses,per_ldap_users and hz_parties tables but none of them c…
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…Bo Tøpgaard 91 views 4 comments 0 points Most recent by Santhosh_Krishnan123 Reporting and Analytics for ERP
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr… -
How to find number of days for a month in FRSHow to find number of days for a month in FRSLakshmiVanarasi 21 views 2 comments 0 points Most recent by LakshmiVanarasi General Ledger & Intercompany
-
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in…Pranat Damani 1 view 0 comments 0 points Most recent by Pranat Damani Reporting and Analytics for ERP
-
Merging 12 Business Units into 6 new Business Units. What is the correct setups and proceduresSummary: We have 12 business units that need to be merged into 6 new business units. We are currently utilising AR,AP, GL, CM, EPM and need to understand what is the pro…Chris Pandaram 2 views 2 comments 0 points Most recent by Nathan CCC 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 (…
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 41 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Income Statement and Balance Sheet reportsSummary Are there a Balance Sheet and/or Income Statement reports available in ERP Cloud?Content I'm surprised there isn't an out of the box version for an Income Statem…User_2025-01-25-00-55-11-011 360 views 8 comments 2 points Most recent by Christine_Inoapps Reporting and Analytics for ERP
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…