Reporting Tools in Oracle Fusion

Reporting Tools in Oracle Fusion

As companies grow the amount of data handled by their system escalates, resulting in a wider number of users requiring access to this data through management reporting systems. This in hand increases the complexity of reporting and analysis and the need to get access to up-to-the-minute information to support critical business decisions. Employees, auditors and stakeholders need accurate, up to date and real time information to understand the health and productivity of the business.

This is where fusion financials come into the picture, not only does it provide the best features to efficiently manage all financial transactions but also has its revolutionary reporting tools which is its stand out feature! Each reporting tool has been tailored to deliver data in a way that’s most appropriate for its given target audience. Whether for management reports, financial analysis, transactional intelligence or statutory reporting.

Fusion delivers various types of reporting tools to meet different reporting needs for different roles. It ensures that all the roles in your company, regardless of the type of report they need, will all be on the same platform.

How does Fusion choose tools according to your users reporting needs?

Fusion Financials provides various types of reporting methods that work off the same standard and multi-dimensional balances.

Here you can see three different categories of reporting needs:

  • Fixed-Format and High-Fidelity reports – Financial Reporting solution can be used to produce boardroom ready financial reports.
  • Local Statutory reports – BI Publisher reports can be used.
  • Everyday Ad-Hoc analysis – Users can either use Smart View, Account Inspector or Transactional Business Intelligence Reports.

Reporting and Analysis Tools to fit your needs

Reporting and Analysis Tools to fit your needs
  1. Smart View

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.

It is a very powerful product for EBS customers who can make use of this cloud product without changing their business process.

The best part about Smart view is that it enables you to interactively analyze your balances and define reports using the familiar spreadsheet environment.

  • Smart View allows you to move dimensions from page level to row or column, to obtain different views of data, supporting interactive analysis.
  • Ad-hoc multi-dimensional pivot analysis combined with full Excel functionality support the following functionalities:
    • Facility to drag and drop dimensions to row, column or page
  • Perform multi-dimensional analysis, pivot, drill
  • Drill from any parent to the next parent level
  • Drill down to detail balances, journal lines, and subledger transactions
  • Business users can utilize Excel’s built-in features (calculations, graphs, etc)
  • Users can save reports and queries offline, then later-on reconnect to the live data by opening the spreadsheet.
  • Users can email the spreadsheet in order to distribute reports among each other.
  • The good news is that, Smart View is compatible with Microsoft Excel, PowerPoint and Word.

2. 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 customized 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.)

3. 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 (favourable vs unfavourable). This in turn makes it a powerful tool for real time, multidimensional account analysis.

Let’s take a look at its awesome features!

  • 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

4. 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. Why this tool is awesome is because it works off the same analytic cube with pre-aggregated  balances at every level so all queries are lightning fast.

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.

5. 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 .These features make it extremely valuable to the top management.

Key Features of OTBI

  • 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.
  • This tool requires no separate data warehouse as  it uses Fusions database, which explains no ETL process needs to be run to populate any data warehouse.
  • 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.
  • In OTBI, instead of constructing a query, you can simply drag and drop selected data from subject areas using different graphical views.
  • This brings us to the good news that even end users can use this tool. No technical knowledge is required.

6. Oracle BI Publisher

BI Publisher has the following features:
  • 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

What are the Key differences between various reporting tools?

Financial Reporting/Smart View/Account Monitor/Account Inspector

  • Focused on financial reporting and analysis
  • Based on GL balances
  • Focused on operational and transactional reporting
  • Based on transactional tables (AP, AR, PO, SLA)
BI Publisher
  • Focused on report documents – high fidelity, customizable, and printed
  • Based on transactional tables (AP, AR, PO, SLA)
BI Publisher

Therefore, we clearly see that the reporting tools in Oracle fusion are tailor made to fit the various reporting needs of various roles and user responsibilities. All these tools are available under the same umbrella for all the different roles but keeping in mind the security concerns of these reports. These interactive and user-friendly tools is the outcome of Oracle’s huge experience and feedback from its wide ranges of customers throughout the globe & across the industries.

Leave a Reply

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info