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

This 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 Web 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 predefined 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 predefined 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.

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

Financial Reporting Web Studio supports the following functionality:

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

Financial Reporting Web Studio is a web-based report authoring solution that you open 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 Financial 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 Financial Reporting Web Studio.

This table describes the sections in the Financial 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 Financial 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 Financial 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.

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

You can use Financial Reporting Web Studio to 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.

In this example, you're designing a basic financial report. This is the first of six topics on designing a financial report with Financial Reporting Web Studio.

  1. From the Financial Reporting Center work area, select the Tasks panel tab and click Open Workspace for Financial Reports.

  2. On the Tools menu, select Launch Financial Reporting Web Studio.

  3. On the File menu, select New, Report.

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

  5. In the design canvas, draw a box to create the grid. The Database Connection Properties dialog box opens.

    Tip: When creating a grid, best practice is to leave space in the design canvas for other objects, such as a company logo and report title.
  6. Select the Data Sources list and select the data source for the chart of accounts that the report is based on. A unique cube exists for each combination of chart of accounts and accounting calendar.

    Tip: Best practice is to always turn on suppression in financial reports at the Database Connection Server level. You can verify the setting by highlighting the grid, and then selecting Data Query Optimization Settings on the Task menu. For most reports, best practice is to turn on suppression for the entire grid. Then turn suppression off for columns and rows that must always display.

    For more information about suppression settings, refer to the Defining Basic Conditional Suppression section in the Financial Reporting Web Studio User's guide.

  7. Click OK. The Dimension Layout dialog box opens.

Arrange the Dimensions

Use the Dimension Layout dialog box to arrange the dimensions on your report. For this report, the accounting periods display on the columns and the revenue and expense account information displays on the rows. The company appears on each page and can be selected at runtime.

  1. Drag the Accounting Period dimension to the Columns axis.

  2. Drag the Account dimension to the Rows axis.

  3. Drag the Company dimension to the Page axis.

  4. Click OK to close the Dimension Layout dialog box.

Define the Rows

Use the Select Members dialog box to define the revenue and expense account rows.

  1. Select the revenue parent account.

    1. Double-click the Account cell. The Select Members dialog box opens with a default member selected.

    2. Remove the default Account selection from the Selected area by clicking it to select it and then clicking the Remove from Selected icon.

    3. In the Search field, enter the value for the account that represents total revenue and click the Search icon.

    4. Select the account from the search results and click OK. The account moves to the Selected area.

    5. Click OK. The Select Members dialog box closes.

  2. Now insert a text row to add space between the revenue and expense accounts.

    1. Select the last row in the grid by clicking the row header.

    2. On the Insert menu, select Row, then Text.

  3. Insert a row for the expense accounts.

    1. Right-click the last row header.

    2. On the Insert Row menu, select Data. Notice the default value for the new row is the revenue parent account.

  4. Select the expense parent accounts.

    1. Double-click the account value in the new expense account row. The Select Members dialog box opens with the revenue parent account selected.

    2. Remove the revenue parent account selection from the Selected area by clicking to select it and then clicking the Remove from Selected icon.

    3. In the Available area, expand the Account member, and continue expanding until you find the expense parent accounts for the report.

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

    5. Select the Place selections into separate rows option so each account appears in its own row on the report.

    6. Click OK. The Select Members dialog box closes.

Save and Preview the Report

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

  1. Click the Save icon.

  2. Select the folder with your name and enter the report name and description.

  3. Click Save.

  4. Optionally preview the report in HTML or PDF format using the File menu or toolbar.

Add Formulas to a Financial Reporting Report

In this example, you define a formula to summarize the expense account balances on your financial report. This is the second of six topics on designing a financial report with Financial Reporting Web Studio.

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

  1. Right-click the last row header, select Insert Row and select Formula.

  2. Click in the empty cell in the new row.

  3. In the Heading Row Properties pane, select the Custom Heading option, enter Total Expenses and click the Update icon. The new heading appears in the report.

  4. Select the row header for the formula row. The SUM function appears in the design canvas.

  5. In the Formula bar, click the Sum(0) button and enter the formula and cell references in the formula text box.

    Because the expense rows appear one after the other, you can use the first row number and the last row number with a colon in between. For example, Sum([3:5]). If the rows weren't contiguous, you could put brackets around each row number and separate them with commas. For example, Sum([3], [5], [6]).

  6. Validate the formula syntax by clicking the check mark icon in the toolbar. Validation checks the validity of the formula, not if the data is available.

  7. Save the report and leave it open for the next topic, which is defining a range function. Optionally preview the report.

Define Range Functions for a Financial Reporting Report

In this example, you define a range function to report across multiple accounting periods. You configure the range to present balances for the last 12 months from the period selected at runtime. This is the third of six topics on designing a financial report with Financial Reporting Web Studio.

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

  1. Define a Basic Financial Report Using the Reporting Web Studio

  2. Add Formulas to a Financial Reporting Report

Now follow these steps.

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

  2. Remove the default accounting period from the Selected area by clicking it to select it and then clicking the Remove from Selected icon.

  3. Click the Functions tab.

  4. Select Range from the list.

  5. Click the Add to Selected icon. The Range dialog box opens.

  6. Define the starting member for the range.

    1. On the Start Member row, click the Lookup Selection icon in the Value column.

    2. Click the Functions tab.

    3. Select the Relative Member function to define the periods that display on the report relative to the period specified at runtime.

    4. Click OK. The Relative Member dialog box opens.

    5. On the Member row, click the Lookup Selection icon in the Value column.

    6. Select Current Point of View for Accounting Period so you can enter the starting period for the report.

    7. Click OK.

    8. On the Offset row, enter -11 in the Value field.

      The offset determines the first period of the range. The starting period in the range function is always the oldest period. Because this is a rolling 12 period report, enter -11 to include the 11 periods prior to the period you enter at runtime. The member selection for the End Member parameter determines period 12.

    9. Click OK.

  7. Define the ending member for the range.

    1. On the End Member row, click the Lookup Selection icon in the Value column.

    2. Select Current Point of View for Accounting Period.

    3. Click OK.

    4. Click OK to close the Range dialog box.

    5. Click OK to close the Select Members dialog box.

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

Set User and Grid Points of View for a Financial Reporting Report

In this example, you set a user point of view and a grid point of view for a financial report. This is the fourth of six topics on designing a financial report with Financial Reporting Web Studio.

All financial reporting reports have a user point of view and a grid point of view. Best practice is to use a combination of both.

If you want users to select certain dimension members at runtime, then those dimensions should be set in the user point of view. Selections for user point of view members are global for a user and data source. This means the application saves and applies them to any other report that has the same dimensions set to the user point of view. By default, all dimensions are set to the user point of view and must be selected at runtime. If you want your report to always use certain dimension selections, then select the specific members in the grid point of view.

Note: Members of a grid point of view only display in HTML.

In this example you set the Ledger, Scenario, Balance Amount and Currency dimensions to use the grid point of view.

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

  1. Define a Basic Financial Report Using the Reporting Web Studio

  2. Add Formulas to a Financial Reporting Report

  3. Define Range Functions for a Financial Reporting Report

Now follow these steps.

  1. Select the cell in the grid that represents the intersection of the rows and columns. The Grid Properties pane opens.

  2. In the Grid Properties pane, click the Grid Point of View check box.

  3. In the design canvas, click the Ledger: User Point of View for Ledger button. The Select Members dialog box opens.

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

  5. Click Apply Selection.

  6. Select Scenario from the Dimension list to select the type of balance to use on the report.

  7. Expand the Scenario member and select Actual.

  8. Click Apply Selection.

  9. Select Balance Amount from the Dimension list.

  10. Expand the Balance Amount member and select Period Activity.

  11. Click Apply Selection.

  12. Select Currency from the Dimension list.

  13. Search for USD.

  14. Click OK to accept the search result.

  15. Click Apply Selection.

  16. Click OK to close the Select Members dialog box.

  17. Save the report and leave it open for the next topic, which is setting page and grid properties. Optionally, preview the report.

Work with Grid Point of View Setup and Page Axis for a Financial Reporting Report

In this example, you change the grid point of view setup and set the page member selection to a prompt on your financial report. This is the fifth of six topics on designing a financial report with Financial Reporting Web Studio.

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

  1. Define a Basic Financial Report Using the Reporting Web Studio

  2. Add Formulas to a Financial Reporting Report

  3. Define Range Functions for a Financial Reporting Report

  4. Set User and Grid Points of View for a Financial Reporting Report

Now follow these steps.

  1. Click the first cell in the grid to select all of the rows and columns.

  2. Right-click and select Grid Point of View Setup from the list. The Setup Grid Point of View dialog box opens.

    1. To prevent the Balance Amount dimension from being changed at runtime, select the Lock Member Selection option.

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

  3. In the Grid Properties pane:

    1. Click the Drill Through option to allow drilling from the report to the General Ledger transaction data.

    2. Click the Suppression section to view the suppression settings.

    3. Enter 0 in the Zero Values field to set the text option for rows with zero values. If necessary, you could also suppress the display of rows with zero values, rows with missing data, and rows with errors.

  4. Set a runtime prompt for the Company dimension so you have the flexibility of selecting any company or combination of companies at runtime. In this example, you want to restrict the valid list of companies that can be selected at runtime.

    1. On the grid, click the Pages label. The Company dimension appears in the design canvas.

    2. Click the Company button. The Select Members dialog box opens.

    3. Remove the default Company selection from the Selected area by clicking it to select it and then clicking the Remove from Selected icon.

    4. Select Prompt for Company.

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

    6. Click OK. The Define Prompts dialog box opens.

    7. Click the Lookup icon in the Choices List field. The Select Members dialog box opens.

    8. Remove the default Company selection from the Selected area by clicking it to select it and then clicking the Remove from Selected icon.

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

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

    11. Click OK. The Select Members window closes.

    12. On the Define Prompts dialog box, click in the Member Name field and select Alias. The actual company label displays in the prompt list of values instead of a numeric company value, making the prompt more user-friendly.

    13. Click OK. The Define Prompts window closes.

  5. Click the Pages label on the grid. The Page Properties pane opens.

    1. In the Page Properties pane, select the Alias: Default option so each page of the report shows the name of the company instead of the number.

  6. Select the four data rows in the grid so all of the rows have the same settings.

    1. In the Heading Row Properties pane, select the Alias: Default option in the Heading Row Properties pane to display the revenue and expense account names instead of the accounts.

    2. In the Heading Row Properties pane, select the Allow Expansion option so you can expand the parent account values to view the detail child values.

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

Add Formats and Graphs to a Financial Reporting Report

In this example, you add formats and graphs to a financial report. This is the sixth and final topic in a series of topics on designing a financial report with Financial Reporting Web Studio.

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

  1. Define a Basic Financial Report Using the Reporting Web Studio

  2. Add Formulas to a Financial Reporting Report

  3. Define Range Functions for a Financial Reporting Report

  4. Set User and Grid Points of View for a Financial Reporting Report

  5. Work with Grid Point of View Setup and Page Axis for a Financial Reporting Report

Now follow these steps.

  1. In the report object browser, select the name of the report, which is the first object.

  2. Add a logo.

    1. In the report layout, drag the header line to make space for the logo and title.

    2. In the Header section, click the Add Report Object icon and select Image.

    3. In the Image Properties pane, click Browse and select your company logo.

  3. Add a title.

    1. Select the name of the report in the report object browser.

    2. In the Header section, click the Add Report Object and select Text. As an alternative, you can click the Text icon in the toolbar and draw the text box. The text box opens.

    3. Enter the report title.

    4. Select the title text and use the format toolbar to adjust the font size, center the text, and change the font style to bold.

  4. Change the page orientation.

    1. Select the name of the report in the report object browser.

    2. On the File, menu, select Page Setup.

    3. In the Page Setup dialog box, select the Landscape option.

    4. Click OK.

  5. Add a chart.

    1. In the Body section, click the Add Report Object icon and select Chart.

    2. In the Chart Properties pane, select the Line chart type.

    3. To show only the expense account rows, deselect row 1, and select rows 3, 4, and 5 in the Data Range section.

    4. Click the Format Chart button. The Format Chart dialog box opens.

    5. In the Appearance tab, enter the title for the chart. For example, Expenses by Period.

    6. Click the Legend tab and enter a title for the legend. For example, Type of Expenses.

    7. Click the Axes tab and enter a title for the Metadata axis. For example, Period. Enter a title for the Primary Axis. For example, Dollars.

    8. Click the Refresh Chart button to preview the chart on the Format Chart dialog box.

    9. Click OK. The Format Chart dialog box closes.

  6. Save the report and optionally, preview it.

For more information about Financial Reporting Web Studio, select the Using EPM with Oracle Financials Cloud link from the All 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.

    Note: To run the report for all journal sources and categories, clear the Source and Category fields.
  • 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.

    Note: To run the report for all journal sources and categories, clear the Source and Category fields.
  • 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 aren't 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.

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

An example of the Trial Balance Report.

Here are descriptions of 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 Report

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.

Average Balances Trial Balance Report

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

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 The Reports That Include It

Data Access Set

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

US Ledger Set

Trial Balance Report, General Ledger Trial Balance Report, Average Balances Trial Balance Report

Balancing Segment Filter and Condition

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

Company equals 101

Trial Balance Report

Account Filter and Condition

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

Cost Center doesn't equal 100

General Ledger Trial Balance Report, Average Balances Trial Balance Report

Summarize By

Determines if the report is summarized by Account, which refers to account combination, Natural Account, or by Natural Account plus another segment.

Natural Account

Trial Balance Report, Average Balances Trial Balance Report

From and To Periods

Determines the accounting period for which account balances are reported.

Apr-21

General Ledger Trial Balance Report

Frequently Asked Questions

The following table lists frequently asked questions about the trial balance 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 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

This topic includes details about the Workflow Rules Report.

Overview

You can now use the Workflow Rules Report to view and validate 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 the report to validate the workflow rules configured in Oracle Business Process Management (BPM) to meet recommended best practices. Wherever the rules deviate from best practices, you can use the suggested recommendations to make the necessary corrections.

You can also 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

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 journal lines for actual balances and then drill to the journal entry or subledger transactions.

    Note: Drilling on budget data isn't supported.
  • Export the balances to Excel.

  • Hide, show, and manage the columns using the View > Columns and View > Columns > Manage Columns menus. 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.

Note: Drilling through on budget data isn't supported.

FAQs for Financial Reporting and Analysis

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

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

  • Launch Financial Reporting Web Studio.

  • Install Smart View application.

  • 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 install 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 Web Studio.