Browser version scriptSkip Headers

Oracle® Fusion Accounting Hub Implementation Guide
11g Release 1 (11.1.4)
Part Number E20374-04
Go to contents  page
Contents
Go to Previous  page
Previous
Go to previous page
Next

12 Define Financial Reporting

This chapter contains the following:

Financial Reporting Center Configuration: How It Works

Setting Up Your Financial Reporting Center: Critical Choices

Oracle Fusion General Ledger Report Listing

Financial Reporting Center Configuration: 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.

The figure shows the main components
in the Financial Reporting Center: Financial Reporting, Account Monitor,
Account Inspector, Smart View, Financial Reporting Workspace, and
Financial Reporting Studio. These components use the Oracle Fusion
General Ledger preaggregated balances as the staring data.

Components

Financial Reporting Center is comprised of numerous components:

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 steps needed to configure and install the components in Financial Reporting Center consist of:

Configuring Financial Reporting Center

Users access reports through the folder structure in Workspace. Administrators should define the folder structure in Workspace considering security requirements for both folder and reports, as well as report distribution requirements for financial reporting batches. Security should be set up on folders and reports from Workspace so users can only view the folders and the reports that they can access.

For more information on configuring the Financial Reporting Client including user name, password, server, and report structure, see the following:

Configuring Workspace Database Connection

Administrators need to create database connections from Workspace so users can access the cubes from either Workspace or Financial Reporting Studio.

Note

Ledger setup has to be completed before the database connection can be created. 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:

  1. Start at the Navigator by selecting Financial Reporting Center > Launch Workspace

  2. From within Workspace > Navigator > BI Catalog > (main tab), select Tools > Database Connection Manager

  3. Select New button

  4. Enter a user friendly name for the connection

  5. Enter the Essbase server, user and password, and select Application (i.e. cube) and database

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.

Installing Financial Reporting Studio

Financial Reporting Studio is client-based software. Report authors need to download the installation files in Workspace from Navigator -> Tools -> Download Desktop Integrator Installer to install Financial Reporting Studio.

After completing the installation, obtain financial reporting server information from your system administrator to connect from the local client to the Oracle Fusion instance.

For more information on configuring Financial Reporting Studio client for users, see the following: Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for Oracle Hyperion Enterprise Performance Management. See especially the following topics:

Installing Smart View

Smart View is an Excel add-in that must be loaded to each client. Users need to download the installation files from Workspace, which is launched from the Financial Reporting Center work area. In Workspace, navigate to 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, it must be configured to connect to Oracle Fusion Applications. This is done using the Smart View Shared Connections URL. You can derive the Smart View Shared Connections URL by following the steps below:

  1. Launch Workspace from the Financial Reporting Center.

  2. Edit the Workspace URL, for example, https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp. Remove index.jsp and add SmartViewProviders at the end of the URL to launch Smart View.

    Note

    For example, the URL now appears as https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/SmartViewProviders.

  3. Copy the URL.

  4. Launch Excel.

  5. Navigate to the Smart View menu > Options > Advanced.

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

  7. Go to the Smart View menu > Open -> Shared Connections.

    Note

    The login window is displayed.

  8. Enter your user name and password.

  9. Click Shared Connections > Select Server to Proceed.

  10. In the Add New Server field, add the Essbase server.

    Note

    The Essbase server URL is the BI Managed Server host (internal) and port 10215. For example: slcac.us.oracle.com:10215. If you are unsure of the host name for the internal BI host, contact your system administrator. You must enter the internal BI host in this URL or drill through functionality won't work.

For more information on configuring Smart View client for users, see the following:

Oracle Fusion General Ledger Report Listing

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

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 (OTBI)

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.

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.

Oracle Business Intelligence Publisher (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.

OTBI

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 OTBI

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.

OTBI

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.

OTBI

Chart of Accounts Reports


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

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

  1. Click the Schedule New Process button

  2. Search on the Process Name.

  3. Enter the desired parameters.

  4. Enter the desired process options and schedule.

  5. Click Submit.

All the reports including those classified as Oracle Fusion Transactional Business Intelligence (OTBI) 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.