Reporting Tools in Oracle Fusion/Cloud

Fusion Financials provides various types of reporting methods that work off the same standard and multi-dimensional balances. Now because all of the reporting and analytic tools leverage the same source of truth, it ensures that all the roles in your company regardless of the type of report they need will be on the same page.

• Financial Reporting Studio
• OTBI (Oracle Transactional BI)
• BI Publisher
• Smartview
• Account Monitor
• Account Inspector

Financial Reporting Studio

Financial Reporting Studio is the report designer tool or a report repository. It is Oracle’s best client based report authoring tool. It enables users to create customize and view income statements and balance sheet reports.

Business users do not have to run the report, all they got to do is open it and real-time balances are shown automatically. Users can then drilldown from reports to subledger transactions, as well as publish reports in a variety of formats (MS Excel, PDF, MS Word, MS Powerpoint, etc.).

Oracle Transactional Business Intelligence

OTBI is a fusion specific reporting tool , used by top level managements of organizations without the need for any technical knowledge. It is a flexible and easy to use analysis tool that helps gain real time insight into transactional data.

• It is a real-time online reporting tool querying directly from Fusion Application data.
• This is an ad hoc analysis tool based on transactional data focused on operational and transactional reporting.
• Business users can easily create reports and dashboards through personalization.
• It focuses on transactional and operational data such as invoices, payments and assets.
• In OTBI, instead of constructing a SQL query, you can simply drag and drop selected data from subject areas and use different graphical views.
• Users can create out of the box reports (e.g reconciliation reports).
• The more commonly used reconciliation reports are receivables to GL recon report and payables to GL recon report.

Oracle BI Publisher

BI Publisher is a reporting tool which requires technical knowledge(SQL) to develop the report. Through BI Reports definition process only we have an option of writing SQL queries to fetch the data from database otherwise the BI Reports creation is completely a technical task where we have to write a program to develop the report.

• It helps to author, manage and deliver document reports
• The reports created here are out of the box operational reports
• BI Publisher provides high fidelity, pixel-perfect documents
• They generate high volume transactional and operational printed reports
• It has flexible and customizable output formats: excel, pdf, doc and html

 Smartview

Most business users are proficient in Excel and hence Smart View, an excel based utility enables the user to analyse real time GL balances in Excel sheets. These sheets are connected to the Essbase cube directly. Smartview is an ideal tool for financial analysts or power users to pivot across any dimension to perform ad-hoc analysis, add calculations and create graphs using Excel’s built-in functionalities.

With Smartview what we can do is whatever analysis you want to do against accounts or you want to prepare some reports or if you want to do some analysis which you can directly from the spreadsheet instead of doing it from the system.By using FRS,within the system there is a framework from where you can do but by using Smartview functionality we can do this in spreadsheet where we can do all analysis and get the real time data.

 Account Monitor

The Account Monitor is itself designed to create active searches. The good news is that Account Monitor has Embedded Intelligence built-in to help you assess the impact of balance changes (favorable vs unfavorable). This in turn makes it a powerful tool for real time, multidimensional account analysis.

·        This solves the issues most accountants face, by adopting a Proactive method of monitoring critical balances.

• It has user friendly and user-configurable rules and thresholds
• It gives users timely alerts when account balances exceed thresholds
• It provides year over year or actual vs budget comparisons
• It provides the facility to drill down to view break down of balances for each child value that rolls up to the parent value
• It drills down to the subledger level and you can even check the receipts created
• For visual understanding it makes use of graphs and pie charts

Account Inspector

This tool is best for users to perform ad-hoc balance queries. It enables them to perform multi-dimensional analysis, slicing and dicing of information, and pivoting– all within a web page. How it works is , after you specify your query criteria, such as your ledger and chart of accounts dimensions, you can expand on any parent value to get a breakdown by each child value that rolls up to the parent value. Again, because this query is working off of the same live, pre-aggregated data, you can change query criteria and instantly refresh results, which is what every business user wants.