This guide also applies to on-premises implementations

1Financial Reporting Introduction

This chapter contains the following:

Using Financial Analytics and Reports: Overview

Oracle Financials Cloud provides predefined analyses, dashboards, and reports that help you meet financial and business intelligence requirements. With the many reporting tools, you can run, view, and build custom or real-time analytics and reports.

The Oracle Financials Cloud: Using Analytics and Reports Guide covers using predefined analysis and reports for the following Oracle Fusion Financial Applications:

  • General Ledger

  • Intercompany

  • Budgetary Control

  • Tax

  • Subledger Accounting

  • Payables

  • Payments

  • Cash Management

  • Receivables

  • Advanced Collections

  • Revenue Management

  • Assets

  • Financial Localization Features for EMEA, Latin America, and Asia/Pacific

For more information, see: Oracle Financials Cloud: Using Analytics and Reports Guide.

Financial Reporting Solutions: Points to Consider

Different reporting requirements exist in a finance organization. The Chief Financial Officer needs professional-quality financial statements, financial analysts analyze ledger balances, and other users perform real-time transactional queries.

Oracle Fusion Financials delivers a state-of-the-art reporting platform that is built on top of an analytic data model. The reports work off the same data source and support drill-downs to real-time source transactions. The queries and reports are accurate and up to the minute, providing multidimensional analysis without the need for a separate data warehouse.

Reporting Tools

Oracle has many tools to meet these reporting needs. Some of your reporting needs and the tools used in the reporting solution are listed in the table below.

Reporting Needs Solution

Boardroom ready financial statements with drill-down to your source transactions that are GAAP-compliant.

Oracle Financial Reporting Studio is used to create financial reports based on the GL balances cube data. Then, use the Financial Reporting Center to view and drill into reports.

Exception-based account monitoring with multidimensional analysis and drill-down capability

Account Groups are created to monitor key accounts in General Ledger. From the account group, use the Sunburst visualization tool to interact with your account balances across business dimensions to view balances from different perspectives.

Spreadsheet financial reports with multidimensional analysis, pivoting, real-time analysis, and drill down capability.

Oracle Smart View enables you to interactively analyze your balances and define reports using a familiar spreadsheet environment.

High volume operational reporting with configurable templates for financial applications.

Oracle Business Intelligence Publisher (BI Publisher) reports are submitted to show the latest application transactional data using the Enterprise Scheduler System (ESS) from either the Scheduled Processes page or from an application-specific work area. BI Publisher has the ability to generate pixel perfect report output. BI Publisher is the tool of choice to generate fixed form reports such as W-2 and tax forms, invoices, purchase orders, or company checks,

Transactional reporting in real time to support daily decision making.

Oracle Transactional BI Analyses are built off of transactional tables using Subject Areas. Use BI Publisher if the need is for pixel perfect reporting.

Centralize location for performing application functions and reviewing data.

Oracle Transactional BI Dashboards put all the information, functions, and actions that a business user requires to do their job in one place. Dashboards are built with Oracle Transactional BI objects such as analyses and reports.

Mobile access to timely reporting information from financial applications.

BI Mobile Apps is a mobile application designer that enables you to create information-driven applications with rich interaction, visualization, and media, for mobile devices such as iPhone, iPad, Android phone, tablet, and more.

Financial Reporting Center: How It Works

The Financial Reporting Center is intended to be the primary user interface for financials end users to access all seven report types.

Financial Reporting Center Overview

The main components in the Financial Reporting
Center are Financial Reporting Studio Reports, Account Groups and
Sunburst, Smart View Reports, Oracle Transactional Business Intelligence
Analyses, Oracle Transactional Business Intelligence Dashboards, Oracle
Business Intelligence Publisher Reports, and BI Mobile Apps.

Reports can be accessed through various methods. However, the Financial Reporting Center provides access to every type of report, is intended to be the primary user interface for financials end users, and is tablet and smartphone friendly.

Financial Reports are read from the Shared > Custom > Financials and My Folders directories. All other report types can be saved anywhere in the BI Catalog however, any custom content should be in the Shared > Custom folder. Subfolders can be created within the Shared > Custom folder.

Seven types of reports can be run from the Financial Reporting Center and from the other reporting tools.

  • Financial Reports: These reports are built off of the Oracle Financial Reporting Studio using data in the Oracle Fusion General Ledger balances cube. For example, company income statements and balance sheets. These reports are mainly run by users in General Ledger.

  • Account Groups and Sunburst: Account groups are used to monitor key accounts in General Ledger. When a user creates an account group, it becomes visible in the Financial Reporting Center with the Sunburst visualization tool. The Sunburst visualization tool lets you interact with your account balances across various business dimensions to view balances from different perspectives. Account groups are used only in General Ledger.

  • Smart View Reports: Smart View is a multidimensional pivot analysis tool combined with full Excel functionality. Smart View enables you to interactively analyze your balances and define reports using a familiar spreadsheet environment. These queries are mainly for users in General Ledger. To share Smart View queries, users can e-mail them to other users, or they can upload the queries to the Financial Reporting Center where users can download them to a local drive for use. The Financial Reporting Center is only a place for users to upload and download Smart View queries.

    Note: To upload a Smart View report to the Financial Reporting Center: select the Open Workspace for Financial Reports task, navigate to the BI Catalog, and select Upload from the Tasks section in the left-hand pane. Be sure to upload the Excel file to one of the folder locations mentioned previously.
  • Oracle Transactional Business Intelligence Analyses: These analyses and reports are built off of transactional tables using subject areas. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

  • Oracle Transactional Business Intelligence Dashboards: Dashboards put all the information, functions, and actions that a business user must have to do their job in one place. Dashboards are built off of Oracle Transactional Business Intelligence objects like analyses and reports. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

  • Oracle Business Intelligence Publisher Reports: Most of these reports are predefined and must first be submitted and resubmitted to see the latest data by the Oracle Enterprise Scheduler system through the Scheduled Processes navigation. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

  • BI Mobile Apps: Oracle Business Intelligence Mobile App Designer is an application that enables you to create multitouch information-driven applications with rich interaction, rich visualization, and rich media, for mobile devices such as iPhone, iPad, Android phone, tablet, and more. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

Other Reporting Tools Overview

Six other tools are available for reporting in Financials.

The following table lists the tools and report types.

Other Reporting Tools Report Type

General Accounting Dashboard and Account Inspector

Account Groups

Reports and Analytics

Oracle Transactional Business Intelligence Objects

BI Catalog

All Report Types, Except Oracle Business Intelligence Publisher Reports

Enterprise Performance Management Workspace

Reports, Books, Snapshot Reports, Snapshot Books, Financial Reporting Batches, and Batch Scheduler

Enterprise Scheduler System

Oracle Business Intelligence Publisher Reports

Even though the Financial Reporting Center is designed to be the main user interface for a financial end user's reporting needs, some users may choose to use any of the six other tools for reporting in financials, such as:

  • General Accounting Dashboard, which provides access to Account Groups: Uses the Account Monitor to efficiently monitor and track key account balances in real time.

  • Account Inspector: Perform ad hoc queries from account groups and financial reports through drill down to underlying journals and subledger transactions.

  • Reports and Analytics: This reporting tool has a panel that reflects the folder structure of the BI Catalog. Users can access and run any Oracle Transactional Business Intelligence analysis, report or dashboard. Users can't run Financial Reports or Oracle Business Intelligence Publisher reports from this interface. This interface can be used by all financials users.

  • BI Catalog: A component of the Enterprise Performance Management Workspace where you can run all report types, except for Oracle Business Intelligence Publisher reports.

  • Enterprise Performance Management Workspace: Create reports, books, snapshot reports, snapshot books, Financial Reporting batches, and batch scheduler, and schedule batches to automatically run and burst to e-mail.

  • Enterprise Scheduler System: Only Oracle Business Intelligence Publisher reports can be submitted from this interface. Users access this interface by navigating to Tools > Scheduled Processes. Most financial users have access to this interface to run standard reports for General Ledger, Payables, Receivables, and so on.

Dashboards and Work Areas for Oracle Fusion Financial Applications: Overview

Oracle Fusion Financial Applications embraces the concept of dashboards to bring the work that needs to be done and the information needed to do it to the front and center of each user's attention.

All Oracle Fusion Financials applications deploy dashboards. On a dashboard, work areas display tabulations of the tasks that a given role needs to accomplish. These are updated by incoming work load in real time. In Payables, for example, newly scanned invoices are tabulated for the Payables Specialist to process. In General Ledger, the accounts monitored by the accountant are updated at each journal posting. In Receivables, new invoices and receipts pending further actions are listed for the Billing Specialist and Receivables Specialist to process.

The tabulations are designed to be easily adjusted to suit your needs in several ways and can be modified, prioritized, and even replaced. Portlets to other Oracle and non-Oracle sources can be added.

The work areas monitor processes and provide updates on status. Items awaiting approval, for example, are listed, as are items with issues, such as incomplete invoices and unposted journals. Social tools are available, so that any person who needs to act, such as an approver, can be contacted immediately. The tabulations support searching by example, saved searches, export to spreadsheet, and other actions, so that the work can be moved along without using menus or navigating away from the work area.