6Financial Reporting and Analysis

This chapter contains the following:

Considerations for General Ledger Balances Cubes

When performing financial reporting and analysis, you should first review the General Ledger Balances Cubes documentation in the Implementing Enterprise Structures and General Ledger guide for reporting and analysis considerations.

Financial Reporting

Financial Reporting Solutions

Different reporting requirements exist in a finance organization. The Chief Financial Officer needs professional-quality financial statements, financial analysts analyze ledger balances, and other users perform real-time transactional queries.

Oracle Fusion Financials delivers a state-of-the-art reporting platform that is built on top of an analytic data model. The reports work off the same data source and support drill-downs to real-time source transactions. The queries and reports are accurate and up to the minute, providing multidimensional analysis without the need for a separate data warehouse.

Reporting Tools

Oracle has many tools to meet these reporting needs. Some of your reporting needs and the tools used in the reporting solution are listed in this table.

Reporting Needs Solution

Boardroom ready financial statements with drill-down to your source transactions that are GAAP-compliant.

Oracle Financial Reporting Studio is used to create financial reports based on the GL balances cube data. Then, use the Financial Reporting Center to view and drill into reports.

Exception-based account monitoring with multidimensional analysis and drill-down capability

Account Groups are created to monitor key accounts in General Ledger. From the account group, use the Sunburst visualization tool to interact with your account balances across business dimensions to view balances from different perspectives.

Spreadsheet financial reports with multidimensional analysis, pivoting, real-time analysis, and drill down capability.

Oracle Smart View enables you to interactively analyze your balances and define reports using a familiar spreadsheet environment.

High volume operational reporting with configurable templates for financial applications.

Oracle Business Intelligence Publisher (BI Publisher) reports are submitted to show the latest application transactional data using the Enterprise Scheduler System (ESS) from either the Scheduled Processes page or from an application-specific work area. BI Publisher has the ability to generate pixel perfect report output. BI Publisher is the tool of choice to generate fixed form reports such as W-2 and tax forms, invoices, purchase orders, or company checks,

Transactional reporting in real time to support daily decision making.

Oracle Transactional BI Analyses are built off of transactional tables using Subject Areas. Use BI Publisher if the need is for pixel perfect reporting.

Centralize location for performing application functions and reviewing data.

Oracle Transactional BI Dashboards put all the information, functions, and actions that a business user requires to do their job in one place. Dashboards are built with Oracle Transactional BI objects such as analyses and reports.

Mobile access to timely reporting information from financial applications.

BI Mobile Apps is a mobile application designer that enables you to create information-driven applications with rich interaction, visualization, and media, for mobile devices such as iPhone, iPad, Android phone, tablet, and more.

The Financial Reporting Center is intended to be the primary user interface for financials end users to access all seven report types.

Financial Reporting Center

The Financial Reporting Center includes these report types: Financial Reporting Studio Reports, Account Groups and Sunburst, Smart View Reports, Oracle Transactional Business Intelligence Analyses, Oracle Transactional Business Intelligence Dashboards, Oracle Business Intelligence Publisher Reports, and Business Intelligence Mobile Apps. Other reporting tools are also available to run the same seven report types.

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

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

Reports can be accessed through various methods. However, the Financial Reporting Center provides access to every type of report, is intended to be the primary user interface for financials end users, and is tablet and smartphone friendly. In addition to accessing reports, you can add favorites, define tags, and view report details, such as type and last updated date.

Financial Reports are read from the Shared > Custom > Financials and My Folders directories. All other report types can be saved anywhere in the BI Catalog however, any user-defined content should be in the Shared > Custom folder. Subfolders can be created within the Shared > Custom folder.

Seven types of reports can be run from the Financial Reporting Center and from the other reporting tools.

  • Financial Reports: These reports are built off of the Oracle Financial Reporting Studio using data in the Oracle Fusion General Ledger balances cube. For example, company income statements and balance sheets. These reports are mainly run by users in General Ledger.

  • Account Groups and Sunburst: Account groups are used to monitor key accounts in General Ledger. When a user creates an account group, it becomes visible in the Financial Reporting Center with the Sunburst visualization tool. The Sunburst visualization tool lets you interact with your account balances across various business dimensions to view balances from different perspectives. Account groups are used only in General Ledger.

  • Smart View Reports: Smart View is a multidimensional pivot analysis tool combined with full Excel functionality. Smart View enables you to interactively analyze your balances and define reports using a familiar spreadsheet environment. These queries are mainly for users in General Ledger. To share Smart View queries, users can email them to other users, or they can upload the queries to the Financial Reporting Center where users can download them to a local drive for use. The Financial Reporting Center is only a place for users to upload and download Smart View queries.

    Note: To upload a Smart View report to the Financial Reporting Center: select the Open Workspace for Financial Reports task, navigate to the BI Catalog, and select Upload from the Tasks section. Be sure to upload the Excel file to one of the folder locations mentioned previously.
  • Oracle Transactional Business Intelligence Analyses: These analyses and reports are built off of transactional tables using subject areas. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

  • Oracle Transactional Business Intelligence Dashboards: Dashboards put all the information, functions, and actions that a business user must have to do their job in one place. Dashboards are built off of Oracle Transactional Business Intelligence objects like analyses and reports. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

  • Oracle Business Intelligence Publisher Reports: Most of these reports are predefined and must first be submitted and resubmitted to see the latest data by the Oracle Enterprise Scheduler through the Scheduled Processes navigation. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

  • BI Mobile Apps: Oracle Business Intelligence Mobile App Designer is an application that enables you to create multitouch information-driven applications with rich interaction, rich visualization, and rich media, for mobile devices such as iPhone, iPad, Android phone, tablet, and more. These reports can be run by users in General Ledger, Payables, Receivables, Cash Management, Intercompany, and so on.

Other Reporting Tools

Six other tools are available for reporting in Financials.

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

Other Reporting Tools Report Type

General Accounting Dashboard and Account Inspector

Account Groups

Reports and Analytics

Oracle Transactional Business Intelligence Objects

BI Catalog

All Report Types, Except Oracle Business Intelligence Publisher Reports

Enterprise Performance Management Workspace

Reports, Books, Snapshot Reports, Snapshot Books, Financial Reporting Batches, and Batch Scheduler

Enterprise Scheduler System

Oracle Business Intelligence Publisher Reports

Even though the Financial Reporting Center is designed to be the main user interface for a financial end user's reporting needs, some users may choose to use any of the six other tools for reporting in financials, such as:

  • General Accounting Dashboard, which provides access to Account Groups: Uses the Account Monitor to efficiently monitor and track key account balances in real time.

  • Account Inspector: Perform ad hoc queries from account groups and financial reports through drill down to underlying journals and subledger transactions.

  • Reports and Analytics: This reporting tool has a panel that reflects the folder structure of the BI Catalog. Users can access and run any Oracle Transactional Business Intelligence analysis, report or dashboard. Users can't run Financial Reports or Oracle Business Intelligence Publisher reports from this interface. This interface can be used by all financials users.

  • BI Catalog: A component of the Enterprise Performance Management Workspace where you can run all report types, except for Oracle Business Intelligence Publisher reports.

  • Enterprise Performance Management Workspace: Create reports, books, snapshot reports, snapshot books, Financial Reporting batches, and batch scheduler, and schedule batches to automatically run and burst to email.

  • Enterprise Scheduler System: Only Oracle Business Intelligence Publisher reports can be submitted from this interface. Users access this interface by navigating to Tools > Scheduled Processes. Most financial users have access to this interface to run standard reports for General Ledger, Payables, Receivables, and so on.

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

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.

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

  • Select dimension member using member selection or functions

  • Add calculations or mathematical functions

For more information about Financial Reporting Studio, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.

Overview of Reporting Web Studio

Reporting Web Studio is a web-based report authoring solution with a similar look and feel to Windows-based Financial Reporting Studio. Report definitions remain the same for both reporting solutions, so you can edit existing reports using the Windows or web version of Financial Reporting Studio.

You can open Reporting Web Studio from the Enterprise Performance Management System workspace. To get there, start from the Financial Reporting Center work area and click the Open Workspace for Financial Reports task. Then click the Launch Reporting Web Studio menu item from the Tools menu.

Here's an image of the menu items under the Tools menu.

This image shows the Tools menu in the Enterprise
Performance Management System workspace. One of the menu items is
Launch Reporting Web Studio.

This table describes the sections in the Reporting Web Studio interface.

Callout Section in Interface What's in It?

1

Repository

Folders, reports, and a Search toolbar.

2

Summary

Information about an opened report, such as report name and description.

3

Report

Object browser, report objects, design canvas, and report object properties panel. Report objects include grids, text, images, and charts.

4

Design Canvas

Layout for a report.

5

Properties

Attributes for a selected report or report object.

Here's an image of the Reporting Web Studio interface highlighting the key sections described in the table.

This image shows the main interface for Reporting
Web Studio.

For more information about Reporting Web Studio, go to the Oracle Financials Cloud books page on the Oracle Help Center at https://docs.oracle.com. Select the Using EPM with Oracle Financials Cloud link.

How Financial Reporting Reports and Account Groups Are Generated

Use the Generate Financial Reports and Account Groups process to create Financial Reporting reports and account groups for each general ledger balances cube for a specified chart of accounts and accounting calendar.

You can submit the process at any time.

How the Reports and Account Groups Are Generated

Submit the Generate Financial Reports and Account Groups process from the Scheduled Processes work area. Select the chart of accounts and accounting calendar, which identify the balances cube and ledgers for which to generate the Financial Reporting reports and account groups.

Specify values for the top parent revenue and expenses account:

  • Top Revenue Account

  • Top Operating Expenses Account

  • Top Cost of Sales Account (optional)

The top parent accounts are used as the basis for deriving the accounts referenced in the reports. The immediate descendants of the top parent accounts are used to define the rows on the Financial Reporting income statement reports. Depending on whether both the top operating expenses and top cost of sales accounts are selected, different variations of the Financial Reporting income statements are generated. If the optional top cost of sales account is provided, the income statements Financial Reporting income statement reports also include a gross margin section.

Tip: You can pick a specific tree and tree version for each parent. All three parent account values can be from different trees and tree versions. Ideally, you would choose a common tree and tree version for all of the parent accounts. The hierarchy basis for all of the rows in the generated reports is then consistent.

For the balances cube identified by the chart of accounts and calendar in the request submission, the process creates an individual set of the following Financial Reporting reports:

  1. Income Statement

  2. Consolidated Income Statement

  3. Rolling Quarterly Income Statement

  4. Rolling Monthly Income Statement

  5. Trial Balances by Ledger Currency

  6. Trial Balances by Entered Currency

Note: To prevent the unnecessary proliferation of such Financial Reporting reports, unless the original reports created were renamed or deleted, resubmitting the process doesn't generate new Financial Reporting reports.

The process also generates the following three account groups for the balances cube, to be shared among all of the ledgers that are part of that balances cube:

  • Revenues: Defined to display in the Revenues infolet. Automatically set as the default for the General Accounting Infolets home page unless an existing account group is already set as the default.

  • Expenses: Defined to display in the Expenses infolet. Automatically set as the default for the General Accounting Infolets home page unless an existing account group is already set as the default.

  • Close Monitor Summary Income Statement: Defined to display in the Close Monitor. Can be assigned to your ledger sets when you complete the Close Monitor setup.

Note: A new set of account groups is generated for a balances cube with each submission of the process.

How to Manage Financial Reporting Studio Versions

You could run into issues with Financial Reporting Studio reports if the Financial Reporting Studio version on your client is different from the Financial Reporting server version in the application. You must therefore manage the Financial Reporting Studio client version during the course of the regular Oracle Fusion Applications Cloud updates.

Using Financial Reporting Studio Between Test and Production Updates

Your test environment is always updated before your production environment.

During this period, the version of the Financial Reporting server on your test environment may be different than the version on your production environment. When this happens, the existing Financial Reporting Studio client currently installed on your computer may not work with your test environment due to the version mismatch between its server and client. Thus, during this period, you must uninstall and reinstall the Financial Reporting Studio client from the test or production environment accordingly, depending on which environment you work on, to ensure the client version matches the server version.

Using Financial Reporting Studio After the Production Update

After the production environment is updated, the Financial Reporting Studio versions for the test and production environments will be the same.

If you already installed Financial Reporting Studio from the test environment, you won't have to make any changes. Otherwise, you should immediately uninstall, download, and reinstall Financial Reporting Studio from the financial reporting workspace in the production environment.

Comparing the Client and Server Versions

To compare the Financial Reporting Studio client version with the Financial Reporting server version, perform the following steps:

  1. Launch Financial Reporting Studio.

  2. From the Help menu, select About Reporting Studio.

  3. Compare the Oracle Hyperion Financial Reporting version with the Report Server Version to confirm that they match.

The following figure shows an example of the Financial Reporting Studio window with matching client and server versions. The Oracle Hyperion Financial Reporting version is 11.1.2.4.505 and the Report Server Version is 11.1.2.4.560.0505.

This figure shows the page that displays when you
select About Reporting Studio from the Financial Reporting Studio
Help menu.

You can also check the server version from the Help menu of the financial reporting workspace.

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

  2. From the Help menu, select About Oracle Enterprise Performance Management System Workspace.

  3. Click Show Details.

The following figure shows an example of the Enterprise Performance Management System Workspace window with the report server version.

This figure shows the page that displays when you
select About Oracle Enterprise Performance Management System Workspace
from the Help menu in the financial reporting workspace.

Installing Financial Reporting Studio

Perform the following prerequisite steps:

  1. Uninstall the previous version, if any, using the Windows Control Panel.

  2. Delete the existing directory structure. For example, C:\Oracle\Middleware\EPMSystem11R1\products\FinancialReportingStudio.

  3. Restart your computer.

Download the version of the Financial Reporting Studio from that environment's workspace:

  1. Navigate to the Financial Reporting Center and select the Open the Financial Reporting Workspace task.

  2. From the menu, select Tools > Install > Financial Reporting Studio and save the file.

  3. Right-click the executable file and select Run as administrator.

    Caution: Don't close the command window that appears near completion. It will automatically close itself.

    The following figure shows an example of the command window that appears while the executable file is running.

    This figure shows the command window, which automatically
closes.
  4. Click Finish on the install window after the command window closes.

Lastly, when designing reports, you can't design a Financial Reporting Studio report using a client version that's higher than the report server version, and then export or import the report to a lower client version level. The report may not work.

Oracle Hyperion Smart View 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. Smart View 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 use real-time account balances and activity. You can use Smart View for:

  • Analysis

  • Predefined form interaction

  • Report design

Analysis

Smart View uses the Excel environment to interactively investigate the data contained in the sources. You start with templates that begin the process or a blank sheet where you begin shaping and altering the grids of data.

Predefined Form Interaction

As an Oracle Fusion user who executes predefined inputs or reporting forms, Smart View a convenient way of completing tasks within Microsoft Office. Use Smart View to work in the Excel environment either for consistent experience or to tie other spreadsheet-based models into your process. For example, use Smart View with Oracle Hyperion Planning 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 use 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 2014 to 2015 results, realign the data in your 2014 reports by applying the 2015 organization hierarchy.

Tip: Best practice when using Smart View is to always turn on row suppression in the Smart View options. You can't suppress columns in Smart View.

For more information about Smart View suppression, see the Smart View Options chapter in the Oracle Smart View for Office User's Guide at http://docs.oracle.com/cloud/latest/epm-common/SVPBC/opt_data.htm#SVPBC-options_202.

For more detailed information about Smart View, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.

Define a Report in Smart View with the Query Designer

This example shows how to define a report using the Query Designer in Smart View.

Defining a Report with the Query Designer

  1. Open Excel and navigate to the Smart View ribbon. Click Panel.

  2. Click Shared Connections.

  3. Sign in with your user name and password.

  4. Click the Select Server to proceed drop-down list.

  5. Select Oracle Essbase.

  6. Expand the Essbase_FA_Cluster and expand USChartofAccounts.

  7. Highlight db. Don't expand db.

  8. Click Connect.

  9. Click the analysis link.

  10. Navigate to the Essbase ribbon and click Point of View.

  11. In the spreadsheet, click cell A2.

  12. On the Essbase ribbon, click Query and select Query Designer. A new sheet named, Sheet1-Query is created and the Query Designer displays.

  13. On the Point of View panel, move:

    1. Account to the Rows section.

    2. Accounting Period to the Columns section.

    3. Ledger to the Point of View section.

    4. Company to the Rows section, as the first dimension.

    Note: You can also select the dimensions cells on the worksheet and use the Pivot command on the Essbase ribbon to perform these steps.

  14. Open the Amount Type dimension by clicking the drop-down list and selecting the Member Selection link. Remove the default placeholder using the Remove icon. Select the period-to-date value and add it to the panel of selected values using the Add icon.

  15. On the Member Selection window, click the drop-down list next to the Amount Type dimension to toggle to each Point of View dimension. Complete the fields, as shown in this table.

    Field Value

    Ledger

    US Ledger Set > [US Ledger Set].[Us Primary Ledger]

    Line of Business

    All Line of Business Values

    Cost Center

    All Cost Center Values

    Product

    All Product Values

    Intercompany

    All Intercompany Values

    Scenario

    Actual

    Balance Amount

    Period Activity

    Currency

    USD

    Currency Type

    Total

  16. From the POV Sheet1-Query_1 panel, click AccountingPeriod to open the Member Selection window. You can also open the Member Selection window from the worksheet by right-clicking the AccountingPeriod cell, and selecting Smart View, Member Selection.

  17. Remove the default selection. Expand 2016. Select all four quarters and add the quarters to the selected panel.

  18. Click OK.

    Note: The four quarters become separate columns on the worksheet.

  19. Click the Company dimension.

  20. Expand All Company Values.

  21. Select [All Company Values].[101] and [Company]@[941] and add them. Remove the default value.

  22. Click OK.

  23. On the POV Sheet1-Query_1 panel, click Account in the Rows section.

  24. Expand All Corporate Accounts-V1 > Account@[T] > 95001 - Net Income Current Year.

  25. Expand 95011-Revenue and 95021-Expenses.

  26. Remove the default value. Select the following values and add them to the selected panel:

    • 95011-Revenue

    • 40000-Revenues

    • 95021-Expenses

    • 50000-Material and Goods

    • 60000-Operating Expenses

    • 70000-Extra Charges and Tax

  27. Click OK.

  28. On the POV Sheet1-Query_1 panel, click Apply Query.

  29. Save your report to the desktop as your initials Smart View Financial Report.

  30. Insert 7 rows at the beginning of the spreadsheet.

  31. Click in cell A3. Click the Insert tab and select Picture.

  32. Select WINNT (D) > Labs > Fin_reporting > Vision Logo.

  33. Click Refresh.

    Note: You must refresh periodically to maintain the connection to the database.

  34. From the Insert tab, click Text Box.

  35. Click cell C4 and type your initials Income Statement for Companies 101 and 941. Use excel formatting to format the text however you want.

  36. Click Refresh.

  37. Click Save.

  38. Highlight all the cells that contain amounts.

  39. Navigate to the Home ribbon, and from the Number section, select dollar sign.

  40. On the Home ribbon, in the Cells section, select Format > AutoFit Column Width.

  41. Navigate to the Essbase ribbon and select Preserve Format.

  42. Click Refresh.

  43. Click Save.

  44. Insert three rows between the data for company 101 and 941.

  45. On the first new blank row in Column B, type Total Income.

  46. Add the following formula for the first column with data Qtr1-14: =C10+C15 where C10 is 95001-Revenue and C15 is 95021-Expenses.

  47. Copy and paste that formula to the other columns.

  48. Do the same formula for totals of Company 941.

  49. Format all the total cells as Accounting. On the Essbase ribbon, select Preserve Format.

  50. Click Save.

  51. Insert 10 more rows between the data for Company 101 and 941.

  52. Highlight all four rows of the expense data for all four quarters, including Material and Goods.

  53. Navigate to the Insert ribbon and select the Line chart from the Chart section.

  54. Select the first 2-D Line chart layout.

  55. On the line chart, click the Legend that reads Series1, Series2, Series3, and Series4.

  56. From the Chart Tools ribbon, select Select Data.

  57. In the Legend Entries (Series) pane, select Series2 and click Remove. Series2 is a total of expenses and not appropriate for this chart.

  58. In the Legend Entries (Series) pane, select each series individually and click Edit. Complete the series and names fields, as shown in this table.

    Series Name

    Series1

    Material and Goods

    Series3

    Operating Expenses

    Series4

    Extra Charges and Tax

  59. In the Horizontal (Category) Axis Labels panel click the first one and click Edit.

  60. Click the icon next to the Axis label range: field.

  61. On the spreadsheet, highlight the four quarter headers and click the icon next to the Axis Labels field.

  62. Click OK twice.

  63. Move and resize the line chart to fit inside the blank lines.

  64. Click Save.

  65. Navigate to: Financial Reporting Center > Tasks panel tab > Open Workspace for Financial Reports.

  66. Click Navigate > Applications > BI Catalog.

  67. Expand Shared Folders > Custom > highlight Financial Reports.

  68. From the Tasks panel, select Upload.

  69. Click Browse and from your Desktop, select your Smart View Financial Report.

  70. Click Open.

  71. Click OK.

  72. Close the EPM Workspace tab.

  73. From the Financial Reporting Center, click the Search icon.

  74. Enter Smart and click Search.

    Note: Your report may not be found immediately. Wait a few minutes and try again.

Creating an Ad Hoc Analysis in Smart View

This example shows how to create an ad hoc analysis in Smart View.

Creating an Ad Hoc Analysis

This example includes steps for configuring the Smart View connection, selecting dimension members, creating separate reports, and formatting amounts.
  1. Navigate to the Financial Reporting Center.

  2. Open the Tasks panel and click the Open Workspace for Financial Reports task.

  3. Remove /index.jsp from the end of the workspace URL and copy the rest of the URL. For example, copy https://adc-fapXXXX-bi.oracledemos.com, where XXXX is the unique instance ID.

  4. Open Excel.

  5. Navigate to the Smart View ribbon and click Options.

  6. In the Shared Connections URL field on the Advanced tab, replace everything before workspace with the copied URL. For example, https://adc-fapXXXX-bi.oracledemos.com/workspace/SmartViewProviders

  7. Click OK.

  8. On the Smart View ribbon, click Panel. The Smart View panel opens.

  9. On the Smart View panel, click Shared Connections.

  10. Sign in with your user name and password.

  11. On the Smart View panel, select the drop-down list for the Select Server to proceed field.

  12. Select Oracle@Essbase from the list of shared connections.

  13. Expand the list of cubes for Essbase_FA_Cluster.

  14. Expand the USChartofAccounts cube.

  15. Select db. Don't expand the selection.

  16. On the Smart View panel, click Connect, and then click Ad hoc analysis.

  17. On the Essbase ribbon, click POV. The Point of View window enables you to select data dimension values, so you can pinpoint the information you want for the Excel analysis.

  18. On the Point of View window, click the drop-down list for each dimension and select the ellipsis (...) to open the member selector. On the Member Selection window, remove the default selection for each dimension using the Remove icon. Select the dimension value and add it using the Add icon. Click OK. Complete the member selection, as shown in this table.

    Field Value

    Company

    [All Company Values].[101]

    Line of Business

    10

    Account

    11200-Cash

    Cost Center

    All Cost Center Values

    Product

    All Product Values

    Intercompany

    All Intercompany Values

    Scenario

    Actual

    Balance Amount

    Period Activity

    Amount Type

    Period-to-date

    Currency

    USD

    Currency Type

    Total

  19. On the worksheet, click the Accounting Period dimension in row 3, column A.

  20. Right-click and select Smart View, Member Selection.

  21. On the Member Selection window, remove the default selection. Expand the Accounting Period dimension and add the period 12-16.

  22. Click OK.

  23. Double-click Ledger in row 2, column B, to zoom in. You can also zoom in by selecting the dimension, navigating to the Essbase ribbon, and clicking Zoom In

  24. Click All Ledgers in row 2, column B, and click Zoom Out on the Essbase ribbon.

  25. Right-click Ledger in row 2, column B, and select Smart View, Member Selection.

  26. On the Member Selection window, remove the default selection of Ledger.

  27. Select US Ledger Set and click the Add icon.

  28. Click OK.

  29. On the Point of View window, click Refresh.

  30. Double-click US Ledger Set in row 2, column B, to zoom in.

  31. Click the [US Ledger Set].[US Primary Ledger] cell.

  32. On the Essbase ribbon, click Keep Only to remove the other Ledger members and keep only the selected member.

  33. To create a separate report based on the Company dimension, on the Essbase ribbon, click Cascade and select Same Workbook. The Member Selection window opens.

  34. On the Member Selection window, select [All Company Values].[102] and click the Add icon.

  35. Click OK. A worksheet opens for company 102.

  36. Click the All Company Values.101 worksheet.

  37. Click the amount cell in row 3, column B.

  38. Navigate to the Home ribbon and set the Accounting Number Format option to the dollar sign.

  39. Navigate to the Essbase ribbon and click Preserve Format.

  40. On the Point of View window, click Refresh.

Create a Financial Report

In Oracle Hyperion Financial Reporting Studio, you can design traditional financial report formats such as balance sheets, profit and loss statements, and cash flow reports. You can also design nontraditional reports for financial or analytic data that include text and graphics. Use Financial Reporting Studio, a client-based application launched from your desktop, to create your reports.

In this example, you define a basic income statement. This is the first in a series of six tasks on creating a financial report.

  1. Open Financial Reporting Studio on your desktop and sign in with your user name, password, and server URL.

    Tip: The first time you sign in, copy the Financial Reports Workspace URL into the Server URL field and remove workspace/index.jsp from the end of the URL.

    The following figure shows an example of the Financial Reporting Studio sign-in window, with the user name, password, and server URL fields populated.

    This figure shows the sign-in window for Financial
Reporting Studio with an example of sign-in information.
  2. On the Standard toolbar, click the New Report icon. The report designer opens.

  3. On the Designer toolbar, click the Insert Grid icon. Grids are tables that contain data from external database connections.

  4. Drag to select the area for the grid. The Select a Database Connection window opens.

    Tip: When creating a grid, best practice is to leave space in the designer area for other objects, such as a company logo and report title.
  5. On the Select a Database Connection window, click the Database Connection list and select your database. A unique cube exists for each combination of chart of accounts and accounting calendar.

    The following figure shows an example of the Select a Database Connection window, with the connection, user name, and password fields populated.

    This figure shows the database connection window
with example values for the fields.
    Tip: Best practice is to always turn on suppression in financial reports. This should be done at the Database Connection Server level. You can verify the setting by doing the following: highlight the grid, and from the menu, select Task > Data Query Optimization Settings. The normal best practice for most reports is to turn suppression on for the entire grid, and then turn suppression off for certain columns and rows that must always display.

    For more information about suppression settings, refer to the Using the Basic Option in Conditional Suppression section in the Designing with Financial Reporting Studio for Oracle Planning and Budgeting Cloud guide at http://docs.oracle.com/cloud/latest/epm-common/CSFSU/ch09s04s02.html#BEGIN.

  6. Click OK. The Dimension Layout window opens.

Arrange Dimensions and Define Rows

Use the Dimension Layout window to arrange the dimensions on the report. Use the Select Members window to select the revenue and expense accounts to include on the report.

  1. On the Dimension Layout window, drag the dimensions from the Point of View frame as follows:

    1. Accounting Period dimension to the Columns frame.

    2. Account dimension to the Rows frame.

    3. Company dimension to the Pages frame.

    The following figure shows the Dimension Layout window. The Company dimension is in the Pages frame, the Accounting Period dimension is in the Columns frame, and the Account dimension is in the Rows frame.

    This figure shows the Dimension Layout window for
the report.
  2. Click OK. The Dimension Layout window closes. The grid is inserted with the specified layout.

  3. Select the revenues account.

    1. Double-click the Account cell on the grid. The Select Members window opens.

    2. Click the Remove All icon to deselect the default account member.

    3. In the Available area, expand the Account member, and continue expanding until you reach the revenue account for the report. You can also use the search to find your account.

    4. Select the account and click the Add icon to move the account to the Selected area.

      The following figure shows the Select Members window for the Account dimension. The Account member is expanded and the revenues account for the report, which is 40000, appears in the Selected area of the window.

      This figure shows the Select Members window with
the Account dimension member expanded to the revenues account, which
has been selected.
  4. Click OK. The Select Members window closes.

  5. Save the report.

    1. From the File menu, select Save As.

    2. Select the My Folders directory and enter a report name.

    3. Click Save.

  6. Insert a blank row to add space between the revenue and expense accounts.

    1. Select the row after the revenues account and right-click the row header.

    2. From the Insert Row menu, select Text.

  7. Insert a row for the expense accounts.

    1. Select the row after the new blank row and right-click the row header.

    2. From the Insert Row menu, select Data. The default value for the new row contains the revenue account.

  8. Select the expense accounts.

    1. Double-click the new expense account cell in row 3. The Select Members window opens.

    2. Click the Remove All icon to deselect the default revenues account.

    3. In the Available area, expand the Account member, and continue expanding until you reach the expense accounts.

    4. Select the accounts and click the Add icon to move the accounts to the Selected area.

    5. Select the Place selections into separate rows option to create a separate row in the grid for each account.

      The following figure shows the Select Members window for the Account dimension. The Account member is expanded and the expense accounts for the report appear in the Selected area of the window. The selected accounts are 50000, 60000, and 70000. The option called Place selections into separate rows is selected.

      This figure shows the Select Members window with
the Account dimension member expanded to the expense accounts, which
have been selected.
  9. Click OK. The grid now includes the expense accounts.

  10. Save the report and leave it open for the next task, which is adding a formula to financial report.

  11. You can preview the report in HTML or PDF format using the File menu or toolbar.

Add a Formula to a Financial Report

In this example, you define a formula to summarize expense account balances on a financial report. This task is the second in a series of six tasks on creating a financial report.

Before you start, do the steps described in the Define a Basic Financial Report topic, then follow these steps.

  1. Select the row after the last expense account row and right-click the row header.

  2. From the Insert Row menu, select Formula.

  3. Click in the empty cell in the new row. The cell properties sheet opens.

  4. On the cell properties sheet, select the Custom Heading option and enter Total Expenses.

  5. Select the row header for the formula row, which in this example is row 6.

  6. In the Formula bar, click the Sum(0) button to enter the formula into the formula text box.

  7. Enter the cell references for the expense accounts into the formula, between the parentheses. In this example, the completed formula is Sum([3], [4], [5]).

    This image shows the Financial Reporting Studio window with the formula entered in the formula text box.

    This image shows the Financial Reporting Studio
window with a formula to sum the three expense rows.
  8. Validate the formula syntax by clicking the check mark icon in the toolbar. Validation checks the validity of the formula, not if data is available.

    This image shows an example of the grid with the revenue account in row 1, expense accounts in rows 3 through 5, and total expenses in row 6.

    This image shows the grid after defining the formula
for total expenses.
  9. Save the report and leave it open for the next task, which is defining a range function. Optionally preview the report.

Define a Range Function for a Financial Report

In this example, you define a range function to report across periods and create rolling period columns on a financial report. This task is the third in a series of six tasks on creating a financial report.

Before you start, do the steps described in these topics.

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

Now follow these steps.

  1. Double-click the Accounting Period cell. The Select Members window opens.

  2. Click the Remove All icon to deselect the default accounting period member.

  3. Click the Functions tab.

  4. Click the Range list item.

  5. Click the Add icon to move the Range list item to the Selected area. The Edit Range Function window opens.

    1. Click in the Value field on the Start Member row.

    2. Click the Lookup icon. The Edit Start Member Parameter Value window opens.

    3. Click the Functions tab.

    4. Click the Relative Member list item. With the relative member parameter, you can define the periods that display on the report relative to the period you specify at runtime.

    5. Click the Add icon to move the Relative Member list item to the Selected area. The Edit Relative Member Function Window opens.

    6. Click in the Value field on the Member row.

    7. Click the Lookup icon. The Edit Parameter Value window opens.

    8. Click the Current Point of View list item, so you can enter the starting period for the report.

      This image shows the Edit Member Parameter Value window for the Accounting Period member. The Current Point of View row is selected.

      This image shows the Edit Member Parameter Value
window for the Accounting Period member.
    9. Click the Add icon to move the selected value to the Selected area.

    10. Click OK. The Edit Member Parameter Value window closes.

    11. On the Edit Relative Member Function window, select the Offset parameter, and enter -11 in the Value field. The offset value determines the number of periods to include from the current point of view.

      This image shows the Edit Relative Member Function window. The Offset parameter is selected and the value entered is -11.

      This image shows the Offset parameter on the Edit
Relative Member Function window.
    12. Click OK. The Edit Relative Member Function window closes.

    13. Click OK. The Edit Start Member Parameter Value window closes.

  6. On the Edit Range Function window, click the End Member list item.

  7. Click in the Value field and click the Lookup icon. The Edit End Member Parameter Value window opens.

    1. Click the Current Point of View list item.

    2. Click the Add icon to move the value to the Selected area.

    3. Click OK. The Edit End Member Parameter Value window closes.

  8. Click OK. The Edit Range Function window closes.

  9. Click OK. The Select Members window closes.

  10. Save the report and leave it open for the next task, which is defining a grid point of view. Optionally preview the report.

Define a Grid Point of View for a Financial Report

In this example, you define dimensions for the grid point of view on a financial report. The grid point of view ensures the same initial default value every time for every user. This task is the fourth in a series of six tasks on creating a financial report.

Before you start, do the steps described in these topics.

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

  3. Define a Range Function for a Financial Report

Now follow these steps.

  1. Select the grid.

  2. Right-click and select Grid Point of View from the list.

  3. On the grid, click the Ledger: User Point of View for Ledger tab. The Select Members window opens.

    1. Expand the Ledger member and continue to expand until you find the ledger to include on the report. Select the ledger.

    2. Click the Scenario tab to select the type of balance to use on the report.

    3. Expand the Scenario member and select the Actual list item.

    4. Click the Balance Amount tab.

    5. Expand the Balance Amount member and select the Period Activity list item as the balance amount to include on the report.

    6. Click the Currency tab.

    7. Expand the Currency member and select USD from the list.

    8. Click the Currency Type tab.

    9. Expand the Currency Type member and select the Entered list item.

    10. Click OK. The Select Members window closes.

      This image shows the grid after defining the grid point of view. The grid is selected and the Ledger dimension is set to the US Primary Ledger. The Accounting Period dimension is set to User Point of View. Column A is defined as a range, row 1 represents revenue, rows 3 through 5 represent expense accounts, and row 6 represents total expenses.

      This image shows the grid with the grid point of
view set for the Ledger dimension.
  4. Save the report and leave it open for the next task, which is setting page and grid properties.

Set Page and Grid Properties for a Financial Report

In this example, you set the page and grid properties for a financial report. This task is the fifth in a series of six tasks on creating a financial report.

Before you start, do the tasks described in these topics.

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

  3. Define a Range Function for a Financial Report

  4. Define a Grid Point of View for a Financial Report

Now follow these steps.

  1. Select the grid.

  2. Right-click and select Grid Point of View Setup. The Setup Grid Point of View window opens.

    1. For the Balance Amount dimension, set the Report Viewers May Select option to Nothing, Lock Member Selection. This step prevents the Balance Amount type from being changed at runtime.

    2. Click OK. The Setup Grid Point of View window closes.

  3. Set a runtime prompt for the Company dimension to provide the flexibility of selecting any company or combination of companies at runtime.

    1. On the grid, double-click the Pages label. The Select Members window opens.

    2. Click the Remove All icon to deselect the default Company member.

    3. Select the Prompt for Company list item.

    4. Click the Add icon to move the selection to the Selected area.

    5. Click OK. The Define Prompt window opens.

    6. Click the Lookup icon in the Default Member field. The Select Members window opens.

    7. Click the Remove All icon to deselect the default Company member.

    8. Expand the Company member, and continue expanding until you find and select the default companies to display in the prompt.

    9. Click the Add icon to move the companies to the Selected area.

    10. Click OK. The Select Members window closes.

    11. Click the Member Labels in Prompt Selection Dialog list and select the Alias list item. The actual company label displays in the prompt list of values instead of a numeric company value, making the prompt more user-friendly.

      This image shows the Define Prompts window for the Company dimension. The default members are companies 101 and 102, and the prompt for member labels is set to Alias.

      This image shows the Define Prompts window.
    12. Click OK. The Define Prompts window closes.

  4. On the Grid Properties sheet:

    1. Click the Drill Through option to enable drill through from the report to the detail balances represented on the report.

    2. Click the Suppression list item to view the suppression settings.

    3. Enter 0 in the Zero Values field to suppress the display of zero dollar rows on the report.

      This image shows the Grid Properties sheet with the Zero Values text option set to 0.

      This image shows the suppression settings on the
Grid Properties sheet.
  5. Click the Pages label on the grid. If the Page Properties sheet doesn't open, select Property Sheet from the View menu.

    1. On the Page Properties sheet, click the Alias: Default option.

  6. Click the first cell in row 1. The Heading Row Properties sheet opens.

    1. Click the Alias: Default option to show the name of the account rather than the account value.

    2. Click the Allow Expansion option to enable the expand functionality on the report.

    3. Select the cells for the expense accounts on the grid, and on the Heading Row Properties sheet, select the Alias: Default and Allow Expansion options.

  7. Save the report and leave it open for the next task, which is formatting your financial report and adding a graph. Optionally, preview the report.

Format a Financial Report and Add a Graph

In this example, you insert a company logo and add a title and chart to a financial report. Then you run the report. This task is the sixth and final task in a series on creating a financial report.

Before you start, do the steps described in these topics.

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

  3. Define a Range Function for a Financial Report

  4. Define a Grid Point of View for a Financial Report

  5. Set Page and Grid Properties for a Financial Report

Now follow these steps.

  1. On the Designer toolbar, click the Insert Image icon.

    1. Drag and drop the cursor over the report to determine the length and width of the image. You can adjust the header height setting on the Report Properties sheet and the grid object, as needed. Keeping the report header narrow improves the PDF output.

    2. Find the company logo in your file system and select it.

  2. On the Designer toolbar, click the Insert Text icon.

    1. Drag the cursor over the report to determine the length and width of the report title.

    2. Enter a report title.

    3. Select the text, and from the Format menu, select Cell. The Format window opens.

    4. Set the font style to Bold and the size to 14.

    5. Click OK.

    6. On the Designer toolbar, select the Center Justify icon to center the text.

  3. From the File, menu, select Page Setup. Click the Page tab and set the orientation to Landscape.

  4. Click OK.

    This image shows the Financial Reporting Studio designer window with a company logo, a report title of Income Statement by Period, and a grid with account rows and an accounting period column.

    This image shows an example of an income statement
report in the Financial Reporting Studio designer.
  5. On the Designer toolbar, click the Insert Chart icon.

    1. Drag and drop the cursor over the area to determine the length and width of the chart.

    2. On the Chart Properties sheet, select the Line chart type and select the expense account rows in the Data Range section.

    3. Click the Format Chart button. The Format Chart window opens.

    4. On the Appearance tab, enter a title for the chart.

    5. Click the Legend tab and enter a title for the legend.

    6. Click the Axes tab and enter a title for the primary axis.

    7. Click the Element Style tab and set the attributes for the data sets, as needed.

    8. Click the Refresh icon to preview the chart on the Format Chart window.

      This image shows the Element Style tab on the Format Chart window. The title of the chart is Expenses by Month. The legend is titled Type of Expense. The primary axis is titled Dollars.

      This image shows the Element Style tab on the Format
Chart window.
    9. Click OK. The Format Chart window closes.

  6. Save the report.

You can preview the report in Financial Reporting Studio using the File menu or toolbar, and you can run your report from the Financial Reporting Center.

This image shows an example of an income statement report run from the Financial Reporting Center. The report has a logo and title. The grid point of view includes the ledger, scenario, balance amount, currency, and currency type dimensions. The company dimension is at the page level. Twelve accounting periods appear as columns and the revenue and expense accounts appear as rows. The chart displays expenses by month.

This image shows an example income statement by
period.

For more information about Financial Reporting Studio, refer to the Using EPM with Oracle Financials Cloud link on the Books for Oracle Financials Cloud page of the Oracle Help Center at https://docs.oracle.com.

General Ledger Reports

Oracle 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. Use the Browse Catalog icon on the Reports and Analytics work area to open the business intelligence (BI) Catalog. You can run and edit reports in the BI Catalog.

The following table describes the predefined account analysis reports.

Name 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 that 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.

The following table describes the predefined journal reports.

Name 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 about 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 for each journal category and a grand total for each ledger and balancing segment value combination.

  • Doesn't report on budget or encumbrance balances.

Journals Details Report

Provides information about 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.

Reconciled Transactions Report

Provides details of clearing account journal lines that have been successfully reconciled by both automatic and manual reconciliation processes.

Unreconciled Transactions Report

Lists all unreconciled clearing account journal lines, specifically the unreconciled lines that weren't subjected to reconciliation yet, those lines rejected by previous automatic or manual reconciliation processes, and those lines that were marked as reviewed.

The following table describes the predefined trial balance reports.

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

The following table describes the predefined reconciliation reports.

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

The following table describes the predefined chart of account reports.

Name Description

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.

Note: The application doesn't 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.

  • For mappings with account rules, prints each subsidiary account range and the parent account into which it maps.

  • For mapping with segment rules, prints the rule name and the parent and subsidiary segments.

  • For mappings with a rollup range rule, prints each subsidiary segment value range and its corresponding parent segment value.

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

  1. Click Schedule New Process.

  2. Search for the process name.

  3. Specify the parameters.

  4. Enter the process options and schedule.

  5. Click Submit.

General Ledger Account Analysis Reports

This topic includes details about the Oracle Fusion General Ledger account analysis reports.

Overview

The account analysis reports assist in reviewing journals and related transactions. You can use these reports as part of your reconciliation process and in preparation of your closing entries.

The image shows an Account Analysis for Contra
Account Report.

The account analysis reports include:

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.

Key Insights

Before running the account analysis reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters for the account analysis reports.

Parameter Description Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

Encumbrance Type

When Balance Type of Encumbrance is selected, gives the option to select Commitments or Obligations.

Commitments

Account Type

Indicates whether the amounts represent Base, Period, Quarter, or Year to Date. For Average Balancing, indicates Period Average, Quarter Average, or Year Average to Date.

PATD Period Average to date balance used in average balance processing.

Includes User Transaction Identifiers

List of identifiers linking the account generation and the transaction, for example PO Number. This helps in identifying the parent transaction.

No

Account, Account Range, or Contra Account Filters and Conditions Defined

Restricts the data reported based on the entered filter and condition.

Company equals 101

Additional Segment

To run the report by account and another segment.

Cost Center

Document Sequence

Uniquely identifies each business document or business event with a number if enabled.

Invoice

From and To Document Number

Assigned unique document sequence number.

101

Frequently Asked Questions

The following table lists frequently asked questions about the account analysis reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During preparation of closing entries.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Journal Reports

This topic includes details about the Oracle Fusion General Ledger journal reports.

Overview

The journal reports assist in reviewing journals activity. You can use these reports as part of your reconciliation process and in ensuring completion of posting of all entries before period close.

The following figure shows an example of the Journals Report. The report has columns for the line, account, transaction date, description, entered and accounted amounts, and units.

This figure shows the Journals Report.

The following table describes each journal report.

Name 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 about 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 for each journal category and a grand total for each ledger and balancing segment value combination.

  • Doesn't report on budget or encumbrance balances.

Journals Details Report

Provides information about manually entered journals prior to posting, including field by field, all data entered into the application 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 value.

Reconciled Transactions Report

Provides details of clearing account journal lines that have been successfully reconciled by both automatic and manual reconciliation,

Unreconciled Transactions Report

Lists all unreconciled clearing account journal lines, specifically the unreconciled lines that were not subjected to reconciliation yet, those lines rejected by previous automatic or manual reconciliation processes, and those lines that were marked as reviewed.

Key Insights

Before running the journal reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the journal reports and provides examples.

Parameter Description Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

From and To Accounting Date

Determines the date on which the journal is recorded. Must be in an open or future enterable accounting period.

10-01-2014

Includes Adjustment Period

Includes journals posted in adjustment periods, if selected.

No

Frequently Asked Questions

The following table lists frequently asked questions about the journal reports.

FAQ Answer

How do I find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During period close to verify all transactions have been imported and journals posted.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Journal and Balances Reports

This topic includes details about the General Ledger Journal and Balances reports.

Overview

General ledger journal and balance reports provide details on journal entries and account balances. The reports list posted accounting activity for 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: 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 provided at report submission. To improve the performance of the report:

    • If you have entries in multiple currencies, run the report for one currency at a time. Only the accounting lines of the selected currency display, instead of all accounting lines of a multicurrency journal.

    • Enter values for the company or balancing segment when running the report. With this method, you can't see all the accounting lines of your intercompany journal.

    The following figure shows an example of the General Ledger Journal Entry Report. The report has columns for the line, account, account description, line description, posting status, and entered and accounted amounts.

    This figure shows the General Ledger Journal Entry
Report.
  • General Ledger Journal and Balance Report: Retrieves all information for the reports that require journal entries and account balances. The account balances can be printed for selected levels of the hierarchy for actual, encumbrance, or budget balance types. To improve the performance of the report, filter by company or balancing segment value.

    The following figure shows an example of the General Ledger Journal and Balance Report. The report has columns for the batch, journal, category, effective date, journal number and line, description, and amounts.

    This figure shows the General Ledger Journal and
Balance Report.

Key Insights

Before submitting the reports, you must transfer subledger journals to the general ledger.

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.

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.

The following table lists selected parameters for the General Ledger Journal Entry.

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.

The following table lists selected parameters for the General Ledger Journal and Balance Report.

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

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Journal and Balance Reports.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Accountant

When do I use this report?

Use these reports to declare withholding and payments on account of income from employment, economic activities, prizes, certain capital gains and income allocations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Trial Balance Reports

This topic includes details about the Oracle Fusion General Ledger trial balance reports.

Overview

The trial balance reports assist in reviewing general ledger balances. You can use these reports as part of your reconciliation process and in ensuring completion of the period close.

The following figure shows an example of the Trial Balance Report. The report has columns for the account, description, beginning balance, debits, credits, and ending balance.

This figure shows the Trial Balance Report.

The following table describes the trial balance reports.

Name Description

Trial Balance Report

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

General Ledger Trial Balance

Lists detail or summary actual account balances and activity by ledger, balancing segment, and account segment: the report prints the value, description, debit or credit balance for beginning and period end, and debits and credits for period activity.

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.

Key Insights

Before running the trial balance reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the trial balance reports and provides examples.

Parameter Description Example

Data Access Set

Secures access to ledgers, ledger sets, and portions of ledgers using primary balancing segment values.

US Ledger Set

Balancing Segment Filter and Condition Defined

Restricts the data reported based on the entered balancing segment filter and condition.

Company equals 101

Account Filter and Condition Defined

Restricts the data reported based on the account segment filters and conditions.

Cost Center does not equal 100

Summarized By

Determines if the report is only summarized by the Natural Account or the Natural Account plus another segment.

Natural Account

From and To Accounting Date

Determines the date on which the journal is recorded. Must be in an open or future enterable accounting period.

10-01-2014

Includes Adjustment Period

Select to include journals posted in adjustment periods.

No

Frequently Asked Questions

The following table lists frequently asked questions about the trial balance reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Managers

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During month-end reconciliation.

  • During period close to verify all transactions have been processed.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Trial Balance Report

This topic includes details about the General Ledger Trial Balance Report.

Overview

The General Ledger Trial Balance Report lists actual account balances and activity by ledger, balancing segment, and account segment. The report prints the account number, description, and debit or credit balance for the beginning and ending period. This also includes the debits and credits for the period. The report can print income statement, balance sheet, or all balances for a selected range of accounting combinations.

The following figure shows an example of the General Ledger Trial Balance Report. The report has columns for the account, account description, year beginning balances, net beginning balances, prior periods, period activity, ending balances, and net ending balances.

This figure shows the General Ledger Trial Balance
Report.

Key Insights

Before submitting the report, you must complete these tasks:

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

  • Define the account hierarchy.

You can use the report to print account balances and activity by legal entity. The report enables you to print reporting and accounting sequences.

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

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:

  • Blank for printing only detail rows.

  • 1 through 10 for printing relevant number of parent total rows. For example, consider you entered 3 and your account hierarchy for the natural account has 3 levels. You see balances at 2 parent levels and for the natural account segment. For the same structure, if you enter 2 then you 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

Select 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

Select:

  • Yes for zero balances for debit and credit.

  • No for the year beginning balance.

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. The default value is Detail. Use the default value to print all accounts in your selected range. The Begin Year, End Year, and Results trial balance types are provided for compliance with specific country requirements.

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.

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Trial Balance Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Accountant

  • Financial Manager

When do I use this report?

Use the General Ledger Trial Balance Report to review:

  • Accounting combination or natural account values and description

  • Prior period activity and year-to-date activity

  • Period beginning and period ending balances

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Reconciliation Reports

This topic includes details about the Oracle General Ledger reconciliation reports.

Overview

The reconciliation reports assist in reconciling journals and related transactions. You can use these reports as part of your reconciliation with your subledgers.

The following figure shows an example of the Receivables to Ledger Reconciliation Summary report. The report includes columns for the accounting beginning balance, receivables amounts, accounting amounts, and the difference.

This figure shows the Receivables to Ledger Reconciliation
Summary report.

The following table describes the reconciliation reports.

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

Key Insights

Before running the reconciliations reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes some of the process parameters from the reports and provides examples.

Parameter Description Example

Bank Account

Account used for your cash transactions.

Bank of America

Include Intercompany Transactions

Include or exclude intercompany transactions or run the report for intercompany transactions only.

Yes

Include Bills Payable

Include the transactions, formerly known as future dated payments, which instruct banks to disburse funds to a supplier's bank on a specific date. That date is known as the maturity date.

Yes

Include On-Account Items

Include items which are credits applied to a customer's account.

Yes

Include Unapplied and Unidentified Receipts

Include receipts that haven't been applied to a customer's account.

Yes

Account Filters and Conditions Defined

Restricts the data reported based on the entered filter and condition.

Company equals 101

Frequently Asked Questions

The following table lists frequently asked questions about the reconciliation reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During period close to verify all transactions have been imported and journals posted.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Chart of Accounts Reports

This topic includes details about the Oracle General Ledger chart of accounts reports.

Overview

The account analysis reports assist in reviewing journals and related transactions. You can use these reports as part of your reconciliation process and in preparation of your closing entries.

The following figure shows an example of the Chart of Accounts Mapping Rules Report. The parameters for the report include the chart of accounts mapping name and the tree version effective date. The report provides the account rules and segment rules for the specified mapping.

This figure shows the Chart of Accounts Mapping
Rules Report.

The following table describes the chart of accounts reports.

Name Description

Balancing Segment Value Assignments Report

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

  • Lets you quickly identify overlapping balancing segment value errors and review for 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, the report prints each subsidiary account range and the parent account into which it maps.

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

Key Insights

Before running the chart of accounts reports, verify that all subledger transactions have been imported and all journal entries for the period have been posted.

Parameters

The following table describes selected process parameters from the reports and provides examples.

Parameter Description Example

Value Set

Enter the value set that contains the balancing segments you are reporting on.

Corporate Company

From and To Balancing Segments

Enter the description of the balancing segment value to report from and to.

Canada

Assignment Status

Select one of the following options: All, Ledger only, Legal Entity, only, or Unassigned to

Ledger only

Actuating Configuration

Select the ledger you want to report on.

US Primary Ledger

Show Only Balancing Segment Values with Multiple Assignments

Show only those balancing segment values that have more than one legal entity assigned to it.

No

Chart of Accounts Mapping

Select the mapping you have defined.

CN code to US Mapping

Tree Version Effective Date

Select the date that determines which tree version to use as one of the report's criteria.

8/28/2016

Frequently Asked Questions

The following table lists frequently asked questions about the chart of accounts reports.

FAQ Answer

How do find these reports?

Schedule, run, and view these reports from Navigator > Tools > Scheduled Processes.

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During preparation of closing entries.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger and Subledger Accounting Reports

Oracle General Ledger and Oracle Subledger Accounting provides a variety of 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. They 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 for each category.

Report Category 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

Workflow Rules Report

This topic includes details about the Workflow Rules Report.

Overview

You can now use the Workflow Rules Report to view the workflow rules configured in Oracle Business Process Management (BPM) for Payables Invoice Approval, General Ledger Journal Approval, and Expense Report Approval workflows. You can view the report output in both spreadsheet and XML format.

Key Insights

You can use this report to obtain details of the stage, participant, rule status, rule conditions, and approval routing for each rule.

Report Parameters

Parameter Description

Workflow

You can select the workflow for which you want to review the workflow rules.

Frequently Asked Questions

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Workflow Rules Administrator

When do I use this report?

Use this report to review existing workflow rules defined in BPM.

What type of a report is this?

Spreadsheet, XML

Approval Groups Report

This topic includes details about the Approval Groups Report.

Overview

You can now use the Approvals Group Report to view the approval groups defined in Oracle Business Process Management (BPM). You can view the report output in both spreadsheet and XML format.

Key Insights

You can obtain the details of the group name, the approvers, and the sequence in which the approvers appear in the approval group.

Report Parameters

There are no parameters that you need to select for this report.

Frequently Asked Questions

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Workflow Rules Administrator

When do I use this report?

Use this report to review approval groups defined in BPM.

What type of a report is this?

Spreadsheet, XML

Balance Analysis

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. 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. If the changed report is saved in a user's My Folder area, then no changes are propagated.

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

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 columns in the journal tables.

General Ledger has four 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: To create a report that queries balances and allows drill down to journals, use the General Ledger - Transactional Balances Real Time and the General Ledger - Journals Real Time subject areas. Other than that, it's advised that you don't create reports that cross subject areas. Such reports may result in less than optimal performance and are hard to maintain.

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're numeric values like journal debit and credit amounts. Fact folders are usually listed after dimension 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 with attributes.

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.

The following figure shows the General Ledger - Journals Real Time subject area. The subject area contains these folders: Approval Status, Journal Batches, Journal Headers, Journal Lines, Posting Status, Time.

The Approval Status folder is a Dimension - Presentation folder and contains these dimension attributes: Approval Status Code, Approval Status Description, Approval Status Meaning. The Lines folder is a Fact - Presentation folder and contains these measures: Accounted Credit, Accounted Debit, Entered Credit, Entered Debit, Statistical Quantity.

This figure shows the General Ledger - Journals
Real Time subject area and its folders.

Balance Inquiry

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.

Note: All segment values and column, row, or page levels must be at a detail level before the drill link is enabled.
Tip: You can now inquire on journal lines by company, cost center, and natural account or any other segment.

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

You can run account inquiries using the Inquire on Detail Balances page. To get to the page, select the Inquire on Detail Balances task in the Period Close work area. You can also drill through to the page from Financial Reporting or Smart View.

Search Criteria

Here are some points to consider when entering search criteria.

  • Your data access set assignments determine the ledgers and ledger sets you can search on.

  • You can search only on accounting periods, not on years or quarters.

  • You can search any account hierarchy level in the chart of account fields, as long as the account hierarchies (tree versions) are published to the balances cube. If the search times out before returning results, set parent values for the chart of account dimensions to lower levels.

Saved Search

If you search often using the same criteria, create a saved search.

  1. Enter your search criteria.

  2. Click Save.

  3. Enter a name for the search.

  4. Optionally, make the saved search the default search. When you land on the Inquire on Detail Balances page, the default saved search criteria is populated automatically.

  5. Click OK.

Search Results

Here are a few things you can do with the search results.

  • Drill to the journal lines (for actual balances) and then drill to the journal entry or subledger transactions.

  • Export the balances to Excel.

  • Hide, show, and manage the columns using the View > Columns and View > Columns > Manage Columns menu. For example, descriptions for chart of accounts dimensions are hidden by default. You may decide to display descriptions for the company, cost center, and account dimensions.

Note: If you select Entered or Converted in the Currency Type search field, the search results appear in two rows. The first row shows the entered currency. The second row shows the ledger currency.

Drill Through from Financial Reporting and Smart View

If you're getting to the Inquire on Detail Balances page by drilling through from Financial Reporting or Smart View, consider these points.

  • Your data access set assignments determine whether you can drill through to the page.

  • Best practice is to set the point of view settings for chart of account dimensions to the lowest possible parent or detail value to avoid a timeout.

  • If you're drilling into a year or quarter Accounting Period dimension, the accounting periods are converted to the applicable range of accounting periods on the Inquire on Detail Balances page.

  • Your selections for rows, columns, page, and point of view display in the page search fields. You can refine the search criteria as needed and rerun the search.

  • From the inquiry page, you can drill to journal lines (for actual balances) and then drill to the journal entry or subledger transactions.

FAQs for Financial Reporting and Analysis

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

The following table describes the differences between the Financial Reporting Center and the Oracle Enterprise Performance Management System Workspace.

Financial Reporting Center Oracle Enterprise Performance Management System Workspace

Intended for most financial users.

Intended for power users.

Integrated section to run reports.

  • Browser-based report repository and distribution tool.

  • Opened from the Financial Reporting Center.

Supports the following features:

  • Run live reports.

  • View snapshot reports.

Supports 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 the Financial Reporting Center and the Workspace use the same report repository.

How can I store and edit Financial Reporting objects?

First installed Oracle BI EE as part of Oracle Fusion Applications. Then 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.