Skip Headers

Home

Contents

Book
List

Contact
Us

PDF

12 Define Financial Reporting

This chapter contains the following:

Financial Reporting Center: How It Works

Setting Up Your Financial Reporting Center: Critical Choices

Oracle Fusion General Ledger Predefined Reports

Financial Reporting Center: How It Works

The Oracle Fusion Financial Reporting Center provides functionality for reporting on Oracle Fusion General Ledger balances. It provides secure, self-service access to reports that use real time account information.

You can design traditional financial report formats such as balance sheets, profit and loss statements, and cash flow reports. You can also design nontraditional formats for financial or analytic data that include text and graphics.

Components

Financial Reporting Center is comprised of numerous components:

Financial Reporting: Financial users and analysts access live reports and books or published snapshot reports and books from previously scheduled batches in a variety of formats. Other functionality includes:
- Refreshing report data using runtime points of view or parameters
- Drill through capability from parents to other parents
- Drill down to detail balances, journal lines, and subledger transactions.
Oracle Hyperion Smart View: Financial analysts view, import, manipulate, distribute, and share data from your Oracle Fusion General Ledger balances in Microsoft Excel.
Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down capability.
Workspace: Reporting administrators create, open, save, and delete folders and store report objects, reports, and snapshot reports.
Oracle Hyperion Financial Reporting Studio: Report authors use an object-oriented graphical report layout with report objects, such as text boxes, grids, images, and charts, to design reports.

Setting Up Your Financial Reporting Center: Critical Choices

Oracle Fusion Financial Reporting Center is a powerful tool for accessing, 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 Financial Reporting Center
Installing and configuring Financial Reporting Studio, performed by your end users.
Installing Smart View, performed by your end user.
Configuring Workspace Database Connection, performed by your administrator.

Configuring Financial Reporting Center

You have access to the reports through the folder structure 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 considering 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 Hyperion Financial Reporting Studio is client-based software. If you access Oracle Fusion Applications from Oracle Cloud, you connect to the Financial Reporting Studio through a Windows Remote Desktop Connection.

Otherwise, report authors download the installation files for Financial Reporting Studio from Workspace by clicking Navigator > Financial Reporting Center > Open Workspace for Financial Reporting. Once Workspace is launched, click Tools > Install > Financial Reporting Studio. After performing the prerequisites and completing the installation, launch the Financial Reporting Studio. Provide your user ID, password, and the Server URL. Derive the Server URL information by following the steps:

Open Navigator > Financial Reporting Center > Open Workspace for Financial Reporting.
Edit the Workspace URL and remove workspace/index.jsp.
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.
Copy the modified URL to the Server URL field.

Note

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

Note

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

Prerequisites needed for installing the Financial Reporting Studio are:

Financial Reporting Studio Client Certifications that are found at: http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html
Microsoft Office installed on your end-users computers.

Note

For more information, see:

Oracle Enterprise Performance Management System Installation and Configuration Guide
Oracle Hyperion Enterprise Performance Management System EPM System Standard Deployment Guide

Installing Smart View

Smart View is an Excel add-in that must be loaded to each client. To download the installation files from Workspace click the Navigator > Financial Reporting Center > Open Workspace for Financial Reporting. Once the Workspace is launched, click on Tools > Install > Smart View. Alternatively, download Smart View from http://www.oracle.com/technetwork/middleware/epm/downloads/smart-view-1112x-1594693.html.

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, it must be configured to connect to Oracle Fusion Applications. This is done using the Smart View Shared Connections URL. You can derive the Shared Connections URL by following the steps below:

Open Workspace for Financial Reporting from the Financial Reporting Center task panel.
Edit the Workspace URL, for example, if the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp. Remove index.jsp and add SmartViewProviders at the end of the URL.

Note

This is another 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.
Copy the URL.
Launch Excel.
Navigate to the Smart View menu > Options > Advanced.
Paste the URL in the Shared Connections URL field.
Click on the OK button.

For more information on configuring Smart View client for users, see Oracle Hyperion Smart View for Office User's Guide for Oracle Hyperion Smart View.

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

Open Smart View from your Start menu > Programs > Microsoft Office > Microsoft Excel 2007.
Go to the Smart View menu > Open, in the Start on the ribbon > click on Smart View Panel that appears in the drop down box under the ribbon. This launches a task pane.
Click on the Shared Connections button on the task pane.
Sign in with your user name and password.
Click on the Select Server to proceed drop down.
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 sever and locate the cube under it.
Select Oracle Essbase from the list of shared connections.
Click the Expand to expand the list of cubes.
Expand your cube (name of your chart of accounts).
Click on db. A list of functions appears on the bottom of the panel.
Click the Ad hoc analysis.

Note

You need to perform these steps only once for a new server and database.

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

Click on the Options on the ribbon > select the Member Options > select Member Name Display.
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 Oracle Fusion General Ledger. For all other documentation, refer to the Oracle Hyperion Smart View for Office User's Guide for Oracle Hyperion Smart View.

Configuring Workspace Database Connections

Administrators need to 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. Oracle Fusion General Ledger balances cubes are created as part of ledger setup. There is a separate cube 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:

Start at the Navigator by selecting Financial Reporting Center.
From the Financial Reporting Center task panel select Open Workspace for Financial Reporting.
From within Workspace select the Navigator menu > BI Catalog.
Select Tools menu > Database Connection Manager.
Select New button.
Enter a user friendly name for the Database Connection Name.
Enter Essbase as the Type, your server, user name, and password.
Select Application (cube) and Database from the list of values. Expand the Application name to see the related Database, for example, db.
Click the OK button twice to save your selections.
Click Close button in the Database Connection Manager window to save your connection.

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

Note

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

Configuring Oracle Fusion Transactional BI Dimensions

Within Oracle Fusion 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.

Oracle Fusion General Ledger Predefined Reports

Oracle Fusion General Ledger provides predefined reports that are used in the close process and to verify setup of the accounting configuration.

Oracle Business Intelligence Publisher

The reports classified as Oracle Business Intelligence Publisher (BI Publisher) are scheduled and run from the Scheduled Processes work area on the Navigator menu.

Oracle Fusion Translational Business Intelligence

All the reports including those classified as Oracle Fusion Transactional Business Intelligence (BI) are accessed from the Reports and Analytics pane on the Navigator menu or from dashboards, where the reports are saved. The report links in the Reports and Analytics pane open in the Oracle Business Intelligence Catalog where reports can be edited, printed, and reviewed.

The following tables are the lists of predefined reports by type.

Account Analysis Reports

Process Name	Display Name	Description	Classification
GLACTANL2	Account Analysis	Prints balances by account segment and a secondary segment for each journal entry, and lists the subledger document number for transactions imported from subledgers.	Oracle Fusion Transactional Business Intelligence (BI)
GLRFCLD	General Ledger 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. Additionally, for each journal line, prints journal details including source, category, journal name, and effective date. Lists accounts in ascending order by account segment value, and prints a CR next to credit amounts.	Oracle Business Intelligence Publisher (BI Publisher)
GLWACCTR	Account Analysis for Contra Account Report	Prints balances by account segment and a secondary segment, lists the contra account for each journal entry, and lists the subledger document number for transactions imported from subledgers. Print this report by date range, accounting flexfield range, contra account, and amount range.	BI Publisher
GLXAVADT	Average Balance Audit Account Analysis Report	Displays the detail account activity which created the aggregate balances and related average balances. Used to research how average balances are calculated for an account. 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.	BI Publisher

Journal Reports

Process Name	Display Name	Description	Classification
GLJRNL	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. In addition, a total is provided for each balancing segment and a grand total is provided for all the activity included.	BI Publisher
GLRXVCJ	General Journals Report	Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.	Oracle Fusion Transactional (BI)
GLYRLJRE	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, and sorts the information by journal batch within each journal entry category. In addition, totals are provided for each journal category and a grand total for each ledger and balancing segment value combination included in your report. Does not report on budget or encumbrance balances.	BI Publisher
GLRXCKJ	Journals Check Report	Provides information on manually entered journals prior to posting, including field by field, all data entered into the system or data imported from external sources.	BI Publisher
GLRXDBJ	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. For each accounting date, journal entries are sorted 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. For each journal line, it also prints the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.	BI Publisher

Trial Balance Reports

Process Name	Display Name	Description	Classification
GLTRBAL	Trial Balance Report	Provides summarized actual account balances and activity by ledger, balancing segment, and account segment value.	BI Publisher and Oracle Fusion Transactional (BI)
GLXAVTRB	Trial Balance - Average Balances	Provides a listing of ending balances and average balances for selected accounts based on an as of date specified. Print the ledger currency or foreign-entered balances. In addition, displays period, quarter, and year average-to-date balances. Request additional information by specifying balancing segments and account ranges.	BI Publisher

Reconciliation Reports

Process Name	Display Name	Description	Classification
GLReconciliationReport	Cash to General Ledger Reconciliation Report	Extracts cash management and general ledger accounting and transactional data for reconciling cash management to the general ledger.	BI Publisher
Payables to Ledger Reconciliation Report	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.	Oracle Fusion Transactional (BI)
Receivables to Ledger Reconciliation Report	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.	Oracle Fusion Transactional (BI)

Chart of Accounts Reports

Process Name	Display Name	Description	Classification
GLXBSVA	Balancing Segment Value Assignments Report	Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting setups. Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values. The application does not check for overlapping balancing segment values online.	BI Publisher
GLXCOCRR	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, prints each subsidiary account range and the parent account into which it maps. If the mapping has segment rules, prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, prints each subsidiary segment value range and its corresponding parent segment value.	BI Publisher

To run BI Publisher reports, use the following steps the Scheduled Processes work area in the Navigator menu.

Click the Schedule New Process button
Search on the Process Name.
Enter the desired parameters.
Enter the desired process options and schedule.
Click Submit.