5Financial Reporting and Analysis

This chapter contains the following:

• Financial Reporting Solutions: Points to Consider

• Financial Reporting Center: How It Works

• Use of the Open Dialog Components When Working with Objects: Explained

• Financial Reporting Studio: Explained

• Smart View: Explained

• Inquiries

• Global Reports

• Analytics

• FAQs for Financial Reporting and Analysis

Financial Reporting Solutions: Points to Consider

Use Oracle Fusion financial reporting and analysis solutions to meet your reporting requirements. The Oracle Fusion General Ledger posting process updates your balances in real time and stores these balances in both balances cube for efficient multidimensional analysis and relational tables for transaction processing. The financial reporting functionality enables:

• Analysis of your financial and management information, reports, and key performance indicators (KPIs)

• Ad hoc inquiry and analysis of your real time transactional data

• Analysis of past, present, or future data with date-effective hierarchies

• Preaggregated balances for every parent level in your chart of account segments

• Drill down from any parent level to the next parent or child level

• Drill down from any level to detail balances, journal lines, and subledger transactions

The following table lists your reporting needs and the solutions you can use in Oracle Fusion to meet those needs:

Reporting Need	Solution
Boardroom ready financial statements with live drill down to your source transactions	Financial Reporting in the Financial Reporting Center
Exception based account monitoring with multidimensional analysis and drill down capability	Account Monitor and Account Inspector in the Financial Reporting Center and from the General Accounting Dashboard
Spreadsheet financial reports with multidimensional analysis, pivoting, and drill down capability	Oracle Hyperion Smart View
High volume operational reporting with configurable templates	Oracle Business Intelligence Publisher (BI Publisher)
Ad hoc queries of transactions	Oracle Fusion Transactional Business Intelligence

Financial Reporting Center

In Oracle Fusion, the Financial Reporting Center provides inquiry and reporting through the Financial Reports functionality and the Account Monitor. The Financial Reports functionality includes:

• Running live reports and books in various formats

• Published snapshot reports and books from previously defined and scheduled batches in various formats

• Creating embedded charts and graphs

• Refreshing report data using run time points of view or parameters

• Expanding or drilling down from any parent to the next parent or child level

• Expanding or drilling down from any level to detail balances, journal lines, and subledger transactions

• Building multidimensional reports, with multiple hierarchies, using a client based tool, Oracle Hyperion Financial Reporting Studio, Fusion Edition

• Distributing reports automatically across your organization using e-mail

• Storing reports in a repository folder structure, using various formats, including PDF, HTML, and spreadsheets

Account Monitor and Account Inspector

With the financial reporting solution, you define tolerance rules in order to create self-monitoring accounts. Tolerance rules can optionally be set using a criteria of a comparative measurement between two selected balances for a balance increase or decrease that is above or below a percentage or constant amount. Only when the criteria are met does the Account Monitor display the balance information for the account specified. The output from your rules is displayed on the Financial Reporting Center and General Accounting Dashboard in a region called the Account Monitor. Any accounts that exceed your tolerance limits are automatically displayed, and can therefore, eliminate the surprise of account anomalies during your close process. With the Account Monitor:

• Automatically monitor your key accounts in real time on an exception or permanent basis

• Review both current and comparative balance, including comparisons with your budget numbers and across different time frames, such as PTD, YTD, QTD, or same period last year

• Analyze change percentages based on your defined rules and thresholds to assess whether your balance variances are favorable or unfavorable

• Define account groups and arrange accounts to be monitored on a regular basis into different account groups to meet your business requirements

In addition, there is full integration with the online multidimensional analysis tool called the Account Inspector from the Account Monitor. With the Account Inspector:

• Perform ad hoc multidimensional pivot table analysis

• Review charts based on the Account Monitor data

• Use drill down from the Account Monitor from any parent to the next parent or child level

• Perform drill down from any child level to detail balances, journal lines, and subledger transactions

Oracle Hyperion Smart View

Oracle Hyperion Smart View, Fusion Edition provides the ability to create and refresh spreadsheets to access real time account balance information. Use Smart View to:

• Perform ad hoc multidimensional pivot analysis with full spreadsheet functionality

• Drill down from any parent to the next parent or child level

• Perform drill down from any level to detail balances, journal lines, and subledger transactions

• Analyze actual, budget, and forecast information

• Increase visibility with charts and graphs

• Apply date effective hierarchies to past, present, or future hierarchies to change the financial data reported in your financial reports. For example, to compare 2010 to 2011 results, realign the data in your 2010 reports by applying the 2011 organization hierarchy.

Oracle Business Intelligence Publisher (BI Publisher)

For frequent and high volume reports, BI Publisher provides:

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

• Ability to create one template to provide reports in up to 185 languages and 244 territorial dialects

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

• Scheduled reports for delivery to a wide range of destinations

Oracle Fusion Transactional Business Intelligence (BI)

Oracle Fusion Transactional BI is a reporting tool that provides embedded analytics. With Oracle Fusion Transactional BI there is no need to build and maintain customized reports or a data warehouse because it provides online inquiry for nearly every transactional object. Oracle Fusion Transactional BI also provides:

• Ability to perform ad hoc queries directly from transactional tables

• 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

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 the following capabilities:

  • Refresh report data using runtime points of view or parameters

  • Drill through 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

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

Related Topics

• Setting Up Your Financial Reporting Center: Critical Choices

Use of the Open Dialog Components When Working with Objects: Explained

The Open dialog is displayed slightly different when you use it to work with objects from Oracle Hyperion Financial Reporting in Workspace.

The dialog title is Select and you can:

• Display this dialog to insert an object, such as a document in a book. In this case, the dialog contains the Available Items and Selected Items areas. You can select one or more items in the Available Items area and use the shuttle controls to move them to the Selected Items area. You can use the arrows beside the Selected Items area to reorder the items in the list. The order of files in a book is significant. Click the arrow on the left side of the dialog to expand and collapse the Folders list.

• Display this dialog to select the folder in the catalog into which you want to import objects from a file such as a ZIP file. After you select a folder, you see an dialog in which you specify the files to import.

• Display this dialog to select the files or folders for exporting Financial Reporting objects from the catalog. After you select a folder, you see an dialog in which you specify the location for exporting.

Components

Use the following components, which are available only for objects from Oracle Hyperion Financial Reporting:

• Open As: Use this box to specify how to open an object from Financial Reporting in Workspace. You can select HTML or PDF.

• Select Mime Type: Use this box to specify how to save an object from Financial Reporting in Workspace.

Options

You can select the following options:

• Financial Reporting Book: Saves the definition of the book.

• Financial Reporting Snapshot Book: Runs the book and saves the output.

• Financial Reporting Batch: Saves the batch.

  :

Financial Reporting Studio: Explained

Oracle Hyperion Financial Reporting Studio, Fusion Edition enables report authors to use an object-oriented graphical report layout with report objects, such as text boxes, grids, images, and charts, to design reports.

Financial Reporting Studio supports the following functionality:

• Client based report definition tool.

• Object based reporting. Objects are reusable across multiple reports

• Drag and drop report grids

• Insert additional report objects such as text boxes, images, and charts

• Drag and drop dimensions to the report grid. Each dimension can only be in one location on report: Row, column, page, or Point of View (POV)

• Insert rows and columns including data, formula, and text

• Select dimension member using member selection or functions

• Add calculations or mathematical functions

Related Topics

• Oracle Hyperion Financial Reporting Studio User's Guide

Smart View: Explained

Oracle Hyperion Smart View for Office provides common Word, PowerPoint, and Excel interfaces designed specifically for Oracle Hyperion Enterprise Performance Management, Oracle Business Intelligence Enterprise Edition, and Oracle Fusion General Ledger. Using Smart View, you can view, import, manipulate, distribute, and share data in Excel, Word, and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating Enterprise Performance Management, Business Intelligence, and General Ledger content from Microsoft Office products.

Smart View provides the ability to create and refresh spreadsheets to access real time account balances and activity. You can use the Smart View for:

• Ad hoc or free form analysis

• Predefined form interaction

• Report design

Ad Hoc or Free-Form Analysis

Smart View uses the Excel environment to interactively investigate the data contained in the sources. Users start with templates that begin the process or a blank sheet where they begin shaping and altering the grids of data as they use the exposed functionality.

Predefined Form Interaction

As an Oracle Fusion user who executes predefined input or reporting forms, you will find Smart View a convenient way of completing tasks within the Microsoft Office environment. Use Smart View if you have a desire to work in the Excel environment either for consistent experience compared to the web application or to tie other spreadsheet-based models into your process. For example, use Smart View with Oracle Hyperion Planning, Fusion Edition in order to incorporate data that is still housed in spreadsheet and workbook based models.

Report Design

Report design is another dimension of Smart View, which leverages the capabilities of Oracle Fusion General Ledger data. Once the data is available within Smart View you can create reports as needed based on a combination of data sources. For example, planning and financial management data can be used to compare actual to budget. Reports can be made more complex by providing the ability to compare multiple scenarios for different periods. The power of Smart View is used to create reports and is refreshed periodically, as needed.

Smart View provides the ability to create and refresh spreadsheets to access real time account balance information. You can use Smart View to:

• Perform ad hoc multidimensional pivot analysis with full spreadsheet functionality

• Drill down from any parent value to the next parent or child value

• Perform drill down from any child value to detail balances, journal lines, and subledger transactions

• Analyze actual, budget, and forecast information

• Increase visibility with charts and graphs

• Apply date effective hierarchies to past, present, or future hierarchies to change the financial data reported in your financial reports. For example, to compare 2010 to 2011 results, realign the data in your 2010 reports by applying the 2011 organization hierarchy.

Related Topics

• Oracle Hyperion Smart View for Office User's Guide

Inquiries

Configuring Account Groups for Account Monitor: Example

Oracle Fusion Financial Reporting Center is a powerful tool for accessing, designing, and presenting financial reports and analytic data. To analysis your data, define specific account groups in the Account Monitor.

Scenario

In this example you define account groups to organize key accounts by purpose, category, and comparison criteria. Steps to define account groups are:

1. From Financial Reporting Center -> Account Monitor region select View -> Account Group -> Create

2. Enter the Account Group name and determine if the account group should be used for the default view for Account Monitor

3. Enter the accounts to be monitored, the threshold options, and the comparison options

4. Click Save and Close or Save and Create Another

Inquiring and Analyzing GL Balances: Worked Example

Balances are preaggregated at every level of your account hierarchy and updated when a journal is posted. To inquire and analyze on real-time balances:

• Access both active and prepublished reports and books using the Financial Reporting Center.

• Review summary and detail information at any point in your account hierarchy using different points of view.

• Drill down from the parent and detail levels into balances and transactions.

Important

All segment values and column, row, or page levels must be at a detail level before the drill link is enabled.

Drill down to Balances

Use the Account Inspector to expand and drill down into an account balances. The default Account Inspector view includes the member values from the default account group selected in the Account Monitor.

1. Click the Navigator > Financial Reporting Center link.

2. Select one of the accounts in the Account Monitor.

3. Click the Inquire and Analyze Balances link.

4. Drag and drop or select:

   • All Cost Center Values.

   • Your account.

   • Company: All Company Values.

   • All other segments fill with 0's or accept the default.

5. Select an Accounting Period.

6. Click Refresh.

7. Click Expand on the Cost Center.

8. Review the balances.

9. Change the accounting period to see how the balances change.

Inquire on Detail Balances: Explained

The Inquire on Detail Balances page allows you to perform an independent account inquiry within Oracle Fusion General Ledger from any parent value for the chart of account dimensions. You do not have to search by an individual account combination, but can search using any level in the account hierarchies. Only account hierarchies (tree versions) published to the balances cube are available.

From Financial Reporting Center

The task Inquire on Detail Balances is on the tasks pane of the Financial Reporting Center. The following functionality is available:

• Drill to journal lines and then to the journal entry or subledger transactions.

• Drill through from a financial report or Smart View query to this page to further drill to journal lines, journal entry, and subledger transactions.

• Search by ledger set.

• Inquire on the Scenario dimension equal to Actual balances, as well as budget and forecast scenario dimensions. Note: Drill to journal lines is only available for actual balances.

  Note

  Drill to journal lines is only available for actual balances.

• Hide or show columns as you prefer by using the View menu > Manage Columns.

  Note

  A user may only want to show the first four of the eight charts of account dimensions and show the description only for company, cost center, and account. The descriptions for chart of account dimensions are hidden by default.

• Sort by chart of account dimension or other columns.

• Export detailed balances to Excel.

• Other Points to Consider:

  • The Ledger dimension is limited to data access set.

  • Currency defaults to the currency of the default ledger in data access set.

  • You can only drill on accounting periods, both from and to, and not years or quarters from the Accounting Period dimension.

  • A timeout is set if the query will cause performance considerations. An error is raised in the page. You have to set the parent levels for the chart of account dimensions to lower levels and then rerun the search.

  • For entered or converted from currency types, the results are shown in two different rows, one for entered currency followed immediately by one row for ledger currency.

Drill Through from Financial Reporting and Smart View to Detail Balances

You are able to drill from a parent level on a financial report or Smart View query to the Inquire on Detail Balances page. The ledger dimension setting on the financial report or Smart View query must be included in the current data access set or the query returns no rows. Other functionality includes:

• Drill to journal lines and then to the journal entry or subledger transactions.

• Each of the dimension settings from Financial Reporting and Smart View, including rows, columns, page, and POV, is displayed as the default values in the page search fields.

• When drilling where the Accounting Period is set to a year or quarter in Financial Reporting or Smart View, the Inquire on Detail Balances feature converts these accounting periods to the applicable range of accounting periods.

• Refine the default search criteria defaulted from Financial Reporting or Smart View, and then rerun the search.

• As the timeout setting is also applicable, it is recommended that in Financial Reporting or Smart View you set the POV settings for chart of account dimensions to the lowest possible parent or detail value when executing the drill through from Financial Reporting. If an error occurs, you have to change the setting in Financial Reporting or Smart View to a lower level, and then rerun the drill through.

• All other functionality of the Inquire on Detail Balances page applies as listed in the section above.

Drill Through from Financial Reporting or Smart View to Account Inspector

You can drill through from a financial report or Smart View query to the Account Inspector for further analysis.

• For Financial Reporting, export the financial report to a Smart View query if you prefer an Excel environment. From Smart View, you can then drill through to Inquire on Detail Balances.

• For Smart View, you may prefer only to do analysis in Excel, and then to drill through to Inquire on Detail Balances.

Global Reports

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 launch the business intelligence (BI) catalog where you can also run and edit reports.

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 system 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, 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.

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.

Related Topics

• Reports and Analytics Pane: Explained

Account Analysis Reports: Explained

Use the account analysis reports to provide a complete set of reports that support fiscal verification processes in countries like Europe and South America. You can also use these reports to inform shareholders on the financial situation of the company in countries like the United States.

Companies are often required to:

• Collect and report information on all posted journal transactions in the general ledger, for a selected period and range of accounts.

• Verify that transactions are recorded systematically and ensure an audit trail from general ledger to the subledger.

• Perform validation for each accounting period once it is closed.

• Verify the accounting entry lines before their approval.

The account analysis reports:

• Provide a legal account ledger

• Reconcile subledger balances with the general ledger balances

• Maintain an audit trail

• Allow a periodic internal verification

The following information is commonly displayed for each account:

• Account identification

• Account beginning balances for the reporting period

• Period transactions with subledger and general ledger information

• Resulting account ending balances

The account analysis reports include the following reports:

• General Ledger and Subledger Account Analysis Report

• General Ledger and Subledger Accounting by Journal Lines Report

• Account Analysis by Legal Entity Report

Common Report Parameters

The following table lists the common parameters for all the account analysis reports:

Parameter	Description
Ledger	Specify the ledgers for the selected data access set. Ledger is required for all general ledger reports.
Legal Entity	Specify the legal entity. You can control the report output through this parameter only if you have associated balancing segment values to your legal entities.
From Period and To Period	Indicate the period range for the report data.
Flex Filter Conditions	Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger and define conditions including account value ranges.

General Ledger and Subledger Account Analysis Report

The General Ledger and Subledger Account Analysis Report prints account balances by account with subledger journal details.

The report also provides:

• Entered amounts

• Third-party information

• Sequences

• Total number of debit and credit documents

• Flexible sorting options

The following table lists selected report parameters.

Parameter	Description
Include Legal Entity Information	Select Yes to print the legal entity on the report.
Balance Type	Specify whether the balance type is budget, encumbrance, or actual amounts.
Display Tax Rate Code	Select Yes to include the tax rate code details.
Document Sequence Name	Enter the name of the document sequence used to generate unique number for the journal.

General Ledger and Subledger Accounting by Journal Lines Report

The General Ledger and Subledger Accounting by Journal Lines Report prints Subledger accounting activity grouped under accounts.

The report also provides:

• Entered amounts

• Third-party information

• Source

• Category

• Sequences

• Total number of debit and credit documents

• Flexible sorting options

The report prints:

• Details of subledger accounting entry lines, regardless of the general ledger journals summarization.

• Audit trail information on the original business documents or transactions to support each accounting entry line. This information varies across countries.

The following table lists selected report parameters:

Parameter	Description
Accounting Sequence Name	Indicate the name of the sequence used to generate a unique number for the subledger journal.
Posting Status	Indicate whether the posting status is transferred but not posted, not transferred, or posted.
Journal Entry Status	Indicate whether the journal entries are in draft, final or invalid status.
Third-Party Type	Select the party type as customer or supplier. This is an optional parameter and you can leave it blank.
Journal Source	Enter the source of journal entries, such as payables, receivables, or manual.
Journal Category	Select journal category if you want to report on a specific subledger journal category, or leave it blank if you want to include all the journal categories.

Account Analysis by Legal Entity Report

The Account Analysis by Legal Entity Report prints account balances with subledger journal details including third-party information and sequences.

The following table lists selected report parameters:

Parameter	Description
Balance Type	Specify whether the balance type is budget, encumbrance, or actual amounts.
Include Zero Amount Lines	Indicate whether the report should include accounts with no activity in the selected period that is, zero amount lines.
Report Heading	Accept the default value or customize the report page heading by selecting one of the available values. The default value is the legal entity name.

Journal Reports: Explained

Use Journal reports to verify that your journals, accounting entries, and source documents are in compliance with the legal requirements.

Journal reports include the following reports:

• Daily Journals Report

• Subledger Detail Journal Report

• Journal Ledger Report

Daily Journals Report

In some European and Latin American countries, companies must report all journals in the general ledger for the accounting period on a monthly, quarterly, and annual basis.

The Daily Journals Report provides:

• Subledger accounting entry lines regardless of the general ledger journals summarization.

• Audit trail information on the original business documents or transactions to support each accounting entry line.

• Verification details that all journals are recorded in chronological order with no gaps, using legal sequencing rules for both journal or accounting entries and source documents.

• Flexible sorting options to help you with reconciliation. Report data is sorted by period end document sequence name and number, accounting sequence, accounting date, and journal name.

The following table lists selected report parameters:

Parameter	Description
Posting Status	Select the applicable posting status. Valid values are Error Status, Posted Journals, and Unposted Journals.
Journal Entry Status	Indicate whether the journal entries are in draft, final or invalid status.
Third-Party Name	Select the name of the third party for whom you want to generate the report.
Summarization Level	Choose: Detail: Displays details of each transaction line. Summary: Summarizes the transaction lines by specific accounting flexfield segments.
Show Account Recapitulation	Select Yes to print the report summary at the accounting flexfield level.

Subledger Detail Journal Report

The Subledger Detail Journal Report displays information on posted general ledger journal batches from the receivables and payables subledgers. All transactions are reported regardless of whether they are transferred in detail or summary.

The following table lists selected report parameters:

Parameter	Description
Journal Entry Status	Indicate whether the journal entries are in draft, final or invalid status.
Accounting Sequence Name	Specify the accounting sequence name for which you want to run the journals.

Journal Ledger Report

The Journal Ledger Report provides an audit trail between the general ledger and subledgers to satisfy legal and business requirements. This report lists the accounting entries in general ledger with subledger details.

Use the Journal Ledger Report to:

• Maintain an audit trial

• Perform periodic internal verification

• Reconcile subledger accounting activity with general ledger journals

• Sort data to audit and reconcile subledger data. You can sort data by period end document sequence name and number, accounting sequence, accounting date, and journal name.

The following table lists selected report parameters:

Parameter	Description
Accounting Period Type	Indicate whether to submit the report for all, standard , or adjustment accounting period types.
Show Running Totals	Select Yes to print running totals in the report.
Summarize by Account	Select Yes to print summarized debit and credit lines per account for a single journal. The default value is No.

General Ledger Journal and Balances Reports: Explained

General Ledger Journal and Balance reports provide details on journal entries and account balances. These reports list posted accounting activity under account balances for all periods in a selected period range. For each account, the reports provide, beginning balance, general ledger posted journal lines, and ending balance. Journal entry reports print all details of general ledger journals.

General Ledger Journal and Balance reports include the following reports:

• General Ledger Journal Entry Report

• General Ledger Journal and Balance Report

Common Report Parameters

The following table lists the common parameters applicable to all the General Ledger Journal and Balance reports.

Parameter	Description
Data Access Set	Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports.
Ledger	Specify the ledgers for the selected data access set. Ledger is required for all general ledger reports.
From Period and To Period	Indicate the period range for the report data.
Flex Filter Conditions	Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger and define conditions including account value ranges.

General Ledger Journal Entry Report

The General Ledger Journal Entry Report provides general ledger journal activity for a given period or date range, and optionally other criteria including journal source, entered currency, and journal batch. Flexible grouping and sorting options are available during report submission.

Journal entries include:

• Journal batch

• Journal entry header

• Journal entry line

Note

Before submitting the General Ledger Journal Entry Report, you must transfer subledger journals to the general ledger.

The following table lists selected report parameters.

Parameter	Description
Posting Status	Select the applicable posting status. Valid values are Error Status, Posted Journals, and Unposted Journals.
Journal Source	Enter the source of journal entries such as, payables, receivables, or manual.

General Ledger Journal and Balance Report

The General Ledger Journal and Balance Report lists posted accounting activity under account balances for all periods in a selected period range. For each account, the report is organized to provide beginning balance, general ledger posted journal lines, and ending balance.

Before submitting the General Ledger Journal and Balance report, you must complete the transfer of subledger journals to general ledger.

The following table lists selected report parameters:

Parameter	Description
Currency Type	Specify the currency type, such as entered, statistical or total. The default value is Total.
Balance Type	Specify whether the balance type is actual or encumbrance. The default is Actual (A).

General Ledger and Subledger Accounting Reports: Explained

Oracle General Ledger and Oracle Subledger Accounting provide a variety of financial reports to support your reporting requirements for trial balances, detail journals and account analysis. These reports also support the needs of your organization for internal reporting, reconciliation, and communication with third parties like customers and suppliers.

The general ledger and subledger reports are categorized into:

• Account Analysis Reports: These reports support fiscal verification processes in countries like Europe and South America, and inform shareholders on the financial situation of the company in countries like the United States.

  The account analysis reports:

  • Provide a legal account ledger

  • Reconcile subledger balances with the general ledger balances

  • Maintain an audit trail

  • Allow a periodic internal verification

• Journal Reports: These reports verify that your journals, accounting entries, and source documents are in compliance with legal requirements.

• Third-Party Detail and Balances Reports: These reports provide balances per third-party control account, third party, and third-party site. These reports verify that the third-party subledgers are consistent with the general ledger.

  Use the third-party detail and balances reports to:

  • Review the accounting process details by third party and third-party site.

  • Audit third-party accounts in detail.

  During the accounting process, run the reports to ensure that subledger and general ledger balances reconcile, and to identify discrepancies.

• General Ledger Journal and Balance Reports: These reports list general ledger journals and account balances for all periods in a selected period range. For each account, the reports provide beginning balance, general ledger posted journal lines, and ending balance.

• General Ledger Trial Balance Report: This report checks your account balances and reviews your accounting activity. You can run the report using zero beginning balances at the start of the fiscal year.

The following table lists the reports provided under each category.

Report Group	List of Reports
Account Analysis Reports	General Ledger and Subledger Account Analysis Report General Ledger and Subledger Accounting by Journal Lines Report Account Analysis by Legal Entity Report
Journal Reports	Daily Journals Report Subledger Detail Journal Report Journal Ledger Report
Third-Party Detail and Balances Reports	Third-Party Detail and Balance Report Third-Party Balances Summary Report Third-Party Account Balance Report
General Ledger Journal and Balances Report	General Ledger Journal Entry Report General Ledger Journal and Balance Report
Trial Balance Report	General Ledger Trial Balance Report

General Ledger Trial Balance Report: Explained

Use the General Ledger Trial Balance Report to check your account balances and review your accounting activity. The report lists account details in detail or summary form at the required hierarchy levels. You can run the report using zero beginning balances at the start of the fiscal year.

The General Ledger Trial Balance Report displays:

• Accounting combination or natural account values and description

• Prior period activity and year-to-date activity

• Period beginning and period ending balances

Before submitting the report, you must complete these tasks:

• Ensure that balances are available for printing in the selected date and account range.

• Define the account hierarchy.

Report Parameters

The following table lists selected report parameters:

Parameter	Description
Data Access Set	Enter the data access set that you can access based on the defined security structure. Data access set is required for all general ledger reports.
Ledger	Specify the ledgers for the selected data access set. Ledger is required for all general ledger reports.
From Period and To Period	Indicate the period range for the report data.
Flex Filter Conditions	Enter the filtering conditions on the accounting flexfield. You can select all segments for the selected ledger and define conditions including account value ranges.
Currency Type	Specify the currency type, such as entered, statistical, or total. The default value is Total.
Account Level	Enter the number of hierarchy levels you want to use for reporting. The valid values are: Null for printing only detail rows. 1 through 10 for printing relevant number of parent total rows. For example, if you enter 3 and your account hierarchy for the natural account has 3 levels you will see balances at 2 parent levels and for the natural account segment. For the same structure, if you enter 2 then you will see balances at only the 2 parent levels.
Top Level Parent Account	Indicate the highest level, top level parent account that you want to work with. This parameter works with the account level parameter.
Account Class	Pick a specific account class or accept the default value of All.
Account Delimiter	Specify the character that must be used as a separator between accounting flexfield segments.
Zero Beginning of Year Balance	Choose: Yes for zero balances for debit and credit. No for the year beginning balance. This is the default value.
Trial Balance Type	Specify the type of account balance to determine the level of detail and results as of the beginning or end of the year. You can select one of the following types: Begin Year, Detail, End Year, Results. Default value is Begin Year.
Page Number Format	Select the applicable page number format. The valid values are Page: n and Page: n of m. The default value is Page: n of m.

Third-Party Detail and Balances Reports: Explained

The third-party detail and balances reports provide balances per third-party control account, third party, and third-party site. These reports verify that the third-party subledgers are consistent with the general ledger.

Use the third-party detail and balances reports to:

• Review the accounting process details by third party and third-party site.

• Audit third-party accounts in detail.

• Reconcile transactions accounted by an audited company with transactions accounted by the third parties.

During the accounting process, run the reports to ensure that subledger and general ledger balances reconcile, and to identify discrepancies such as:

• Transaction amounts are assigned to incorrect accounts. For example, an invoice distribution amount is assigned to a liability account.

• Transactions are not posted to the general ledger.

• Journal batches are not posted in the general ledger.

The third-party detail and balances reports include:

• Third-Party Balances Summary Report

• Third-Party Detail and Balances Report

• Third-Party Account Balance Report

• Journals and Third-Party Report

Report Prerequisites

Before submitting the reports, you must complete these tasks:

• Ensure that the third-party control account balances are available for printing for the selected date and account range.

• Manually run the Update Subledger Account Balances process for your ledger and application, if you accounted your third-party transactions online.

Note

You must setup third-party control account, you can set it up as supplier control account, customer control account, or both.

Third-Party Balances Summary Report

The Third-Party Balances Summary Report displays information about each third party and third-party site account, and account identification. This report is a tool for auditing third-party accounts.

The balances include period beginning balances, period activity, and ending balances. You can verify whether third-party subledgers are consistent with the general ledger by reconciling the subledger balances with general ledger balances.

The following information is commonly displayed for each account, third party, third-party site:

• Account identification

• Third party and third-party sites identification

• Beginning, period activity and ending balances

Third-Party Detail and Balances Report

The Third-Party Detail and Balances Report provide third-party account balances and accounting activity details for a period. You can sort the report by accounting date or document sequence name and number. The report lists account activity in entered and ledger currency. For each account, third party and third-party site, the report displays beginning balance, period activity, and period end balance.

Third-Party Account Balance Report

The Third-Party Account Balance Report prints account and associated third-party transactions for a particular period. You can choose the accounting flexfield segments or segment range for which you want to print balances. Transaction Type, Transaction Number, accounting sequence number, tax details and amounts in entered and ledger currency are displayed. Period beginning and ending balances are printed for the third party and third-party site. You can display the full account combination or up to three selected segments.

The report is run to ensure that subledger and general ledger balances reconcile, and to identify discrepancies.

Journals and Third-Party Report

The Journals and Third-Party Report prints all the journals posted to the general ledger for an accounting period. It provides detailed subledger accounting entry lines reporting level regardless of the general ledger journals summarization, including transaction line description, third party name and number and transaction amounts in entered and ledger currency. The report also verifies whether all journals are recorded in a chronological order with no gaps, using legal sequencing rules for both accounting entries and source documents.

The report allows you to create various views of reported information based on seven flexible sorting rules that help with reconciliation and auditing.

Report Parameters

The following table lists selected report parameters:

Report Name	Parameter	Description
Third-Party Balances Summary Report Third-Party Account Balance Report	Report Heading	Choose you if you want to print report headings. You can choose one of the following options: Ledger, Legal Entity, and Statutory Header for Italy.
Third-Party Balances Summary Report Third-Party Detail and Balances Report Third-Party Account Balance Report Journals and Third-Party Report	Journal Entry Source	Enter the source of journal entries, such as payables, receivables, or manual.
Journals and Third-Party Report	Event Class	Indicate the event class, such as credit memos and debit memos.
Journals and Third-Party Report	Group by Period	Indicate whether to group the journal entries by period.
Third-Party Balances Summary Report Third-Party Detail and Balances Report Third-Party Account Balance Report	Third-Party Type	Indicate the party type, such as supplier or customer.
Third-Party Balances Summary Report Third-Party Detail and Balances Report	Third-Party Name	Submit the report for a specific third party, or leave this field blank for all third parties.

Analytics

Oracle Fusion Financial Reports and Analytics: Overview

Navigate to the Reports and Analytics work area by selecting the Navigator then clicking Tools and then Reports and Analytics. The Reports and Analytics work area contains links to all the reports that you can access.

Report Links

The Reports and Analytics work area contains links to reports and analytics from the Oracle Business Intelligence Presentation Catalog in an organized hierarchy. In the Reports and Analytics work area, business intelligence analysis and dashboards are categorized as Analysis and Oracle Business Intelligence Publisher reports are categorized as Reports.

Multiple instances of the same report but with different parameters may exist in one work area and within the same folder in that area. Links to the same report may be in multiple folders.

Business Intelligence Analysis and Dashboards

In the Reports and Analytics work area, you can view or edit any business intelligence analysis or dashboard. Any changes made to existing reports are reflected wherever the analysis or dashboard is used in Oracle Fusion Applications, unless the changed report is saved in a user's My Folder area.

Business intelligence analyses and dashboards are created from the Reports and Analytics toolbar. They can be saved privately or shared.

General Ledger Subject Areas, Folders, and Attributes: Explained

To create real-time analyses for General Ledger, you should be familiar with subject areas, folders, and attributes.

Subject Areas

To create an analysis, you begin by selecting a subject area from which you select columns of information to include in the analysis. For example, to create an analysis of journal information, you begin by selecting a General Ledger - Journals Real Time subject area. Subject areas are based around a business object or fact. In this example, the subject area is based on the column in the journal tables.

General Ledger has 4 general ledger specific subject areas:

• General Ledger - Balances Real Time

• General Ledger - Journals Real Time

• General Ledger - Period Status Real Time

• General Ledger - Transactional Balances Real Time

Tip

You can create a report that combines data from more than one subject area. Such a report is referred to as a cross-subject area query.

However, the simplest and fastest way to generate a report is to use a single subject area. If the dimension attributes and fact metrics that you are interested in are all available from a single subject area, then you can use that subject area to build the report. Such a report results in better performance and is easier to maintain.

If your report requirements cannot be met by any single subject area because you need metrics from more than one subject area, you can build a cross-subject area query using common dimensions.

Folders

Each subject area has one fact folder and a number of dimension folders. Fact folders contain attributes that can be measured, meaning that they are numeric values like journal debit and credit amounts. Fact folders are usually at the bottom of the list of folders and are usually named after the subject area. Dimension folders contain attribute and hierarchical columns like journal name and accounting period.

Some folders appear in more than one subject area, such as Time. These are referred to as common folders or common dimensions.

Each folder within a subject area may have a different level of granularity. For example:

• Journal Approval has approval attributes.

• Journal Batches has subfolders and attributes under the subfolders.

Attributes

Finally, each dimension folder contains attributes (columns), such as balance type and posting date. This figure illustrates the structure of subject areas, folders, and attributes.

In the preceding figure, the following components are shown:

• Subject area: General Ledger - Journals Real Time

• Dimension - Presentation Folder: Approval Status

• Dimension - Attributes: Approval Status Code, Approval Status Description, and Approval Status Meaning.

• Fact - Presentation Folder: Lines

• Fact - Measures: Accounted Credit, Accounted Debit, Entered Credit, Entered Debit, and Statistical Quantity

Related Topics

• Data Structure for Analytics: Explained

FAQs for Financial Reporting and Analysis

What's the difference between Financial Control Reporting and Workspace?

The key differences between Financial Reporting Center and Oracle Enterprise Performance Management System Workspace are:

Financial Reporting Center	Oracle Enterprise Performance Management System Workspace
Intended for most financial users.	Intended for power users.
Integrated region to run reports.	Browser based report repository and distribution tool. Launched from the Financial Reporting Center.
Supports the following features: Run live reports. View snapshot reports.	Support the following features: Run live reports. View snapshot reports. Define books and batches. Schedule reports and batches. Import and export of Financial Reports. Download Financial Reporting Studio and Smart View applications. Manage balances cube connections.

Note

Both Financial Reporting Center and Workspace access the same report repository.

How can I store and edit Financial Reporting objects?

If you installed Oracle BI EE as part of Oracle Fusion Applications, store and edit new objects that you create for Oracle Hyperion Financial Reporting in Workspace in the Oracle BI Presentation Catalog. Perform operations on those objects in the catalog similarly to how you work with other objects, such as copying and modifying properties. See the documentation for Hyperion Financial Reporting for complete information on working with objects. Financial Reporting report designers can also access the Financial Reporting objects in the Financial Reporting Studio.