2Other Financial Reporting

This chapter contains the following:

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.

Setting Up Your Financial Reporting Center: Critical Choices

Oracle Fusion Financial Reporting Center is a powerful tool for reviewing, designing, and presenting financial reports and analytic data. The critical choices required to configure and install the components in Financial Reporting Center consist of:

  • Configuring the Financial Reporting Center

  • Installing and configuring Financial Reporting Studio, performed by your end users

  • Installing Smart View, performed by your end users

  • Configuring Workspace Database Connection, performed by your administrator

  • Configuring Oracle Transactional BI Dimensions

Configuring Financial Reporting Center

You have access to the reports in the Financial Reporting Center and Workspace installed with Oracle Fusion Financial Applications. Your Oracle Fusion Business Intelligence (BI) administrator defines the folder structure in Workspace. The administrator considers your company's security requirements for folders and reports, as well as report distribution requirements for financial reporting batches.

  • Security can be set on folders and reports from Workspace.

  • You are granted access to the folders and reports you want to view by your BI administrator.

Installing and Configuring Financial Reporting Studio

Oracle Financial Reporting Studio is client-based software. If you open Oracle Fusion Applications from Oracle Cloud, you connect to the Financial Reporting Studio through a Windows Remote Desktop Connection. Report authors download installation files for Financial Reporting Studio from Workspace by clicking Navigator > Financial Reporting Center > Tasks panel drawer > Open Workspace for Financial Reporting. Once Workspace is started, click Tools > Install > Financial Reporting Studio. After performing the prerequisites and completing the installation, start the Financial Reporting Studio. Provide your user ID, password, and the Server URL. Derive the Server URL information by following the steps:

  1. Open Navigator > Financial Reporting Center > Tasks panel drawer > Open Workspace for Financial Reporting.

  2. Edit the Workspace URL and remove workspace/index.jsp.

  3. Following are two examples of Server URLs:

    • If the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp, the Server URL is https://fusionsystemtest-p-external-bi.us.oracle.com.

    • If the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com:10622/workspace/index.jsp, the Server URL is https://fusionsystemtest-p-external-bi.us.oracle.com:10622.

  4. Copy the modified URL to the Server URL field.

Note: For end users installing the Oracle Fusion Financials Reporting Studio, the installer starts a separate console window. The installer continues to run for a brief time after the installation completes the setup tasks. The process is normal, expected, and applies to Oracle Reporting Studio installations in both the Oracle Fusion Applications and Enterprise Performance Manager modes.

Wait for the console window to close, which happens automatically, before clicking the Finish button on the Financial Reporting Studio Installation dialog box. If you click the Finish button before the console window closes, the Financial Reporting Studio installation may not complete.

Note: You must save a new report before attempting to preview it with Web Preview.

Prerequisites needed for installing the Financial Reporting Studio are:

  1. Financial Reporting Studio Client Certifications that are found at: http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html.

  2. Microsoft Office installed on your end-users computers.

Installing Smart View

Smart View is an Excel add-in that must be loaded on each client. To download Smart View, click Navigator > Financial Reporting Center > Tasks panel drawer > Open Workspace for Financial Reports. Once the workspace is started, click Tools > Install > Smart View.

Note: Since Smart View is an add-in to Microsoft Office products, you can install Smart View only on a Windows operating system.

Once Smart View is installed, you must configure the connection using the Smart View Shared Connections URL. You can derive the Shared Connections URL by following these steps:

  1. From the Financial Reporting Center task panel, select Open Workspace for Financial Reporting.

  2. Edit the workspace URL by removing index.jsp and adding SmartViewProviders at the end.

    Note: The following URL is an example for a Cloud-based environment. If the workspace URL is https://efops-rel5st4-cdrm-external-bi.us.oracle.com:10622/workspace/index.jsp, the Shared Connections URL is https://efops-rel5st4-cdrm-external-bi.us.oracle.com:10622/workspace/SmartViewProviders.
  3. Copy the URL.

  4. Open Excel.

  5. From the Smart View menu, click Options > Advanced.

  6. Paste the URL in the Shared Connections URL field.

  7. Click OK.

For more information about configuring Smart View client for users, see the Oracle Smart View for Office User's guide.

To connect Oracle Fusion General Ledger Balances cubes in Smart View:

  1. Open Smart View from your Start menu > Programs > Microsoft Office > Microsoft Excel 2007.

  2. Navigate to the Smart View menu > Open. On the Start on the ribbon, click on Smart View Panel that appears in the list of values under the ribbon. The task pane opens.

  3. Click on the Shared Connections button on the task pane.

  4. Sign in with your user name and password.

  5. Click on the Select Server to proceed list of values.

    Note: If the Essbase Server is not there, then it has to be added. Use the following steps:
    1. Click on the Add Essbase Server link on the bottom of the spreadsheet.

    2. Specify the Essbase Server login and password.

    3. Expand the Essbase server and locate the cube under it.

  6. Select Oracle Essbase from the list of shared connections.

  7. Expand the list of cubes.

  8. Expand your cube (name of your chart of accounts).

  9. Click on db. A list of functions appears on the bottom of the panel.

  10. Click the Ad hoc analysis function.

Note: You must perform these steps only once for a new server and database.

To set how the name and alias of the Essbase database appears:

  1. Click Options on the ribbon. Select Member Options > Member Name Display.

  2. Set one of these three options:

    • Distinct Member Name. Only shows the full Essbase distinct path.

    • Member Name and Alias: Shows both the member name and the alias.

    • Member Name Only. Shows only the member name.

Note: The Smart Slice feature is not supported in General Ledger. For all other documentation, refer to the Oracle Smart View for Office User's Guide.

Configuring Workspace Database Connections

Administrators must create database connections from Workspace so users can access the cubes from Workspace and Financial Reporting Studio.

Note: Ledger setup has to be completed before the database connection can be created. General Ledger balances cubes are created as part of ledger setup. A separate cube is created for each combination of chart of accounts and accounting calendar. A database connection is needed for each cube.

Steps to define a database connection are:

  1. Start at the Navigator by selecting Financial Reporting Center.

  2. From the Financial Reporting Center task panel, select Open Workspace for Financial Reporting.

  3. From within Workspace select the Navigator menu > Applications >BI Catalog.

  4. Select Tools menu > Database Connection Manager.

  5. Select New button.

  6. Enter a user-friendly name for the Database Connection Name.

  7. Enter Essbase as the Type, your server, user name, and password.

  8. Select Application (cube) and Database from the list of values. Expand the Application name to see the related Database, for example, db.

  9. Click the OK button twice to save your selections.

  10. Click Close button in the Database Connection Manager window to save your connection.

For more information about configuring Essbase database connections in Workspace see: Database Administrator's Guide for Oracle Essbase.

Note:

The database connection is available in both Workspace and Financial Reporting Studio. Optionally, it can be set up in Financial Reporting Studio when putting grids on a report. This should only be done by an administrator.

Configuring Oracle Transactional BI Dimensions

Within Oracle Transactional Business Intelligence (BI), Accounting Segment Dimensions such as Balancing segment or Cost Center segment are based on the Chart of Accounts configuration. These segments can be configured to be tree-enabled, which means that hierarchies are defined upon the segment values for rollup purposes. In such scenarios, you must filter by a specific hierarchy when performing ad hoc queries against tree-based accounting segments. Incorrect results may occur if tree filters are not applied. To apply tree filters, create a filter condition on Tree Filter attributes in Accounting Segment Dimensions.

Note: For information, see: Administering Transactional Analyses at http://docs.oracle.com/cloud/latest/common/OATBI/toc.htm.

Oracle Fusion General Ledger Predefined Reports

Oracle Fusion General Ledger provides predefined reports that cover the following areas:

  • Account Analysis

  • Journals

  • Trial Balance Reports

  • Reconciliation Reports

  • Chart of Accounts

You can schedule and run reports from the Scheduled Processes work area. In some cases, you can access and open reports in the Reports and Analytics work area. Both work areas are found under Tools on the Navigator. Use the icon on the top of the Reports and Analytics work area to open the business intelligence (BI) Catalog. You can run and edit report in the BI Catalog.

The following tables are the predefined reports.

Account Analysis Reports Description

Account Analysis

  • Prints balances by account segment and a secondary segment for each journal entry.

  • Lists the subledger document number for transactions imported from subledgers.

General Ledger Account Details Report

  • Provides journal information to trace each transaction back to its original source.

  • Prints a separate page for each balancing segment value.

  • For each journal line, prints:

    • The account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.

    • Journal details including source, category, journal name, and effective date.

  • Lists accounts in ascending order by account segment value.

  • Prints a CR next to credit amounts.

Account Analysis for Contra Account Report

  • Prints balances by account segment and a secondary segment.

  • Lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.

  • Prints by date range, accounting flexfield range, contra account, and amount range.

Average Balance Audit Account Analysis Report

  • Displays the detail account activity which created the aggregate balances and related average balances.

  • Displays daily average balance information for the selected accounts for the specified range of dates.

  • Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

Note: Use to research how average balances are calculated for an account.

Journal Reports Description

Journals Report

  • Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

  • Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.

  • Includes a total for each balancing segment and a grand total for all the activity.

General Journals Report

Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Batch Summary Report

  • Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range.

  • Provides information on actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. Sorts the information by journal batch within each journal entry category.

  • Includes totals each journal category and a grand total for each ledger and balancing segment value combination.

  • Does not report on budget or encumbrance balances.

Journals Details Report

Provides information on manually entered journals prior to posting, including field by field, all data entered into the applications or data imported from external sources.

Journals Day Book Report

  • Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.

  • Sorts journal entries for each accounting date by document number.

  • Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.

  • Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

Trial Balance Reports Description

Trial Balance Report

Provides summarized actual account balances and activity by ledger, balancing segment, and account segment value.

Trial Balance - Average Balances

  • Provides a listing of ending balances and average balances for selected accounts based on an effective date specified.

  • Prints the ledger currency or foreign-entered balances.

  • Displays period, quarter, and year average-to-date balances.

Note: Request additional information by specifying balancing segments and account ranges.

Reconciliation Reports Description

Cash to General Ledger Reconciliation Report

Extracts cash management and general ledger accounting and transactional data for reconciling cash management to the general ledger.

Payables to Ledger Reconciliation Report

  • Provides both summarized and detailed reconciling data for review.

  • Shows payables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted.

Receivables to Ledger Reconciliation Report

  • Provides reconciliation of receivables data to the general ledger.

  • Shows receivables and accounting beginning and ending balances, as well as summarized activity for the period and how the activity was accounted.

Chart of Accounts Reports Description

Balancing Segment Value Assignments Report

  • Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting set ups.

  • Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values.

Note: The application does not check for overlapping balancing segment values online.

Chart of Accounts Mapping Rules Report

  • Provides both the segment and account rules defined for a specific chart of accounts mapping.

  • If the mapping has account rules, print each subsidiary account range and the parent account into which it maps.

  • If the mapping has segment rules, print the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, print each subsidiary segment value range and its corresponding parent segment value.

To run predefine reports, navigate to the Scheduled Processes work area and follow these steps:

  1. Click the Schedule New Process button.

  2. Search for your process name.

  3. Enter your parameters.

  4. Enter your process options and schedule.

  5. Click Submit.