1Introduction to Financial Reporting

This chapter contains the following:

Overview of Creating Financial Analytics and Reports

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 user-defined or real-time analytics and reports.

The Oracle Financials Cloud: Creating Analytics and Reports Guide covers creating and editing analysis and reports as well as subject areas for the following Oracle Fusion Financial Applications:

  • General Ledger

  • Intercompany

  • Budgetary Control

  • Subledger Accounting

  • Payables

  • Payments

  • Cash Management

  • Expense Reporting

  • Assets

  • Receivables

  • Collections

Configuring Analytics and Reports

You can create and edit analytics and reports for your own use. Or, if you have the appropriate roles, you can configure for others. For example, you can:

  • Add or remove columns from an analysis.

  • Change the branding logo on report output.

  • Create a dashboard to include your most commonly viewed analyses.

Setup and Administration

Additional tasks support creating and editing analytics and reports. For example, your implementor or administrator can:

  • Secure access to user-defined analytics and reports.

  • Archive and move user-defined analytics and reports from one environment to another.

  • Create financial report definitions.

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

The Financial Reporting Center includes these report types: 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 Business Intelligence Mobile Apps. Other reporting tools are also available to run the same seven report types.

The following figure illustrates the report types that are available in the Financial Reporting Center.

This figure shows the report types that are available
in the Financial Reporting Center. In the Enterprise Performance Management
Workspace, reports can be created from General Ledger balances cubes
and Oracle transaction tables.

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. In addition to accessing reports, you can add favorites, define tags, and view report details, such as type and last updated date.

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 user-defined 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 email 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. 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 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

Six other tools are available for reporting in Financials.

The following table lists the other reporting tools and the types of reports they support.

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 email.

  • 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.

Overview of Reports and Analytics Tools

The following are additional Oracle Fusion Financial reporting and analysis products:

  • Oracle Business Intelligence Publisher (BI Publisher)

  • Oracle Transactional Business Intelligence

  • Oracle Business Intelligence Analytics

  • Spreadsheet Integration

Oracle Business Intelligence Publisher

Oracle Business Intelligence Publisher provides the ability to create and format high-quality reports across Oracle Fusion Applications in general, including Oracle Fusion General Ledger. It applies templates, designed by your users in familiar desktop tools, to standard extracts and reports.

  • Report layouts using familiar desktop tools, such as Adobe Acrobat PDF, Word, and Excel

  • Ability to create one template to provide reports in many languages

  • Reports published in various outputs such as Word, Excel, PDF, RTF, and HTML

  • Scheduled reports for delivery to a wide range of destinations

Oracle Transactional Business Intelligence

Oracle Transactional Business Intelligence (Transaction BI) is a reporting tool that provides embedded analytics. Transaction BI supports online inquiry for most transactions, reducing the requirement to build and maintain user-defined reports. Transaction BI also provides:

  • Drag-and-drop functionality to build the report layout, and immediately run the report to obtain real time results

  • Shared queries and reports using the Report Catalog, a reporting option used to view or save specific definitions

Oracle Business Intelligence Analytics

Oracle Business Intelligence Analytics in Oracle Fusion:

  • Supports real time, queries from an Oracle Fusion balances cubes and external data warehouses

  • Contains prebuilt key performance indicators (KPIs) and metrics that deliver information throughout all levels of the organization

  • Preaggregates data to summarize information across multiple data sources for faster queries

Spreadsheet Integration

You can transfer data easily and promptly to spreadsheets throughout Oracle Fusion General Ledger and Oracle Fusion Financials. In addition use the spreadsheet features in Financial Reporting, Smart View, and Business Intelligence. Watch for the XLS icon on the toolbar associated with a tabulation of data. Selection of the icon creates a spreadsheet tab with the displayed information.

Oracle Fusion Financials facilitates importing data by using prepared spreadsheet templates that include validation and control features.

Caution: When working with these spreadsheets, changes are not recorded in Oracle Fusion Applications until the spreadsheet is uploaded. The upload appropriately fails unless users follow the conventions, statuses, search requirements, refresh requirements, and other instructions associated with the spreadsheet.

Financials Reports and Analytics Pane

The Reports and Analytics pane, also called BI Composer, is a central place to quickly view or run analytics and reports used in your work.

If you have the permission, you can:

  • Create or edit reports and other analytic content by selecting subject areas, columns, filters, and prompts.

  • Add reports from the business intelligence (BI) catalog to the pane.

  • Find this pane in a panel tab. Navigate to: Tools > Reports and Analytics to open the Reports and Analytics work area. The pane appears as the Contents pane.

What's In the Pane?

This table describes what's in the Reports and Analytics pane's top-level folders.

Folder Content

My Folders

Any user-defined analytics or reports that you saved for your own use only.

Shared Folders

  • Any predefined analytics and reports that are relevant to your work area. Or, in the Reports and Analytics work area, all the analytics and reports that you have access to.

  • Any shared user-defined reports and analytics in the user-defined subfolder. Place your shared reports and analytics in this folder to protect them during upgrades.

Business Intelligence Catalog

The business intelligence catalog stores all analytics, reports, and other BI objects. Each analysis, dashboard, or report in the Reports and Analytics pane represents a mapping, or link, to the same object in the catalog. The Reports and Analytics pane also reflects the folder structure of the BI catalog.

You save analyses, dashboards, and reports in the catalog, along with other objects like prompts and filters. Besides the hierarchy of folders organized by product family, another important folder is Custom, found in Shared Folders. This is where you save the analytics and reports you create or edit for others to use.

Shared Folders and the Custom Subfolder

Anyone with the correct access can get to objects stored in Shared Folders. If you have the appropriate roles, you can save in Shared Folders so that your objects are available for other users. You should save objects in the Custom subfolder, and use the product family subfolders to organize and publish analytics and objects for the correct audiences.

Here are a few things to know while working with analytics in the catalog. Keep all modified analyses and reports in the Custom folder. Directly edit predefined analytics only when it's necessary to make sure that any references to the analysis or dashboard still work properly.

  • Preserve modified predefined objects during updates, which can make changes to predefined analytics, reports, and other objects outside the Custom folder. You might lose changes saved outside the Custom folder during updates.

  • You can easily find modified objects if they're not spread around the catalog.

  • You can edit objects in the Custom folder without compromising security on the original objects.

  • For predefined reports only, you can use a special Customize option to copy the report and also the folder structure and permissions. The copy is linked to the original, so editing the copy is like directly editing the original.

When you copy an object into the Custom folder, the copied object inherits the permission settings of the Custom folder. An administrator can reset the permissions on the object and the folder that it's in.

My Folders

My Folders is your personal storage; you're the only one who can access anything that you save there. What you save there is available in the Reports and Analytics work area, but not in My Folders in the Reports and Analytics panel tab on any other work area. But an exception is when you create an analysis using the wizard in the Reports and Analytics work area. If you save a wizard analysis in My Folders, it's available in any panel tab that appears in any work area.

Business Intelligence Catalog

There are two major work areas for analytics administration. The main interface is where your users view the analytics administrators set up in user work areas and on the infolet pages. The second area is the business intelligence catalog. Reports, analyses, dashboards, and other business intelligence (BI) objects are stored and administered in the business intelligence catalog. BI is where you build and edit analytics for your user work areas. You can toggle back and forth between the two areas.

Navigate to the Catalog

  1. Click Tools > Reports and Analytics in the Navigator.

  2. In the Reports and Analytics work area, click the Browse Catalog button.

Objects in the Catalog

The catalog stores the BI objects in a folder structure of individual files, organized by product family.

BI objects and reports are organized in the following folder hierarchy:

  • Shared Folders (parent)

  • Product family (example: Financials)

  • Product (example: Payables)

  • Report groups (example: Invoices)

  • Dashboard reports

  • Data Models

  • Report Components

  • BI Publisher reports

  • Prompts

The following table describes the common BI objects that you find in the catalog:

Catalog Object Description Location

Analysis

Analyses are used for infolets, the Sales pages, and on object pages such as Opportunities.

Analytics library

Dashboard

Dashboards organize analytical content and catalog objects, and present them in a meaningful way.

Reporting group folder

Dashboard Prompt

Dashboard prompts allow users to filter dashboard content using provided values.

Prompts folder

Filter

Filters are used in dashboards and analyses.

Prompts folder

Report

Reports are operational reports in printable format created in Business Intelligence Publisher.

Analytics library

Data Model

Data models are used by reports created in Business Intelligence Publisher.

Data Models folder

Sub-template

Sub-templates are used by reports created in Business Intelligence Publisher.

Reporting group folder