4Oracle Fusion General Ledger

This chapter contains the following:

Oracle Transactional Business Intelligence Reports for GL

This topic includes details about the Oracle Fusion General Ledger reports predefined using Oracle Transactional Business Intelligence (BI).

Overview

These reports assist in reviewing journals, accounts, and balances. You can use these reports as part of your reconciliation process.

The image is the Account Analysis Report using
Oracle Transactional Business Intelligence.

The Oracle Business Intelligence reports for the General Ledger include:

Journal Reports Description

Account Analysis Report

Provides the beginning, periodic activity, and ending balances for the selected accounts and periods. Drill down on the periodic activity balance provides journal details and transactions details including journal source, category, transaction number, and event class.

General Journals Report

Provides the journals activity for the selected period. The content can be filtered by ledger set, ledger, entered currency, approval status, date range, account, source, category, journal batch, and batch status.

Trial Balance Report

Provides the beginning, periodic activity, and ending balances summarized by balancing segment, natural account, and cost center for the selected ledger, accounting period, and currency.

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.

Columns

Oracle Transactional Business Intelligence reporting tool provides embedded analytics and supports online inquiry for most transactions. The selections you make are dependent on the columns that were chosen during the report definition.

The output of data in a predefined format provides little or no interaction and simplifies your reporting.

The image shows the columns defined in the General
Journals report.

Frequently Asked Questions

The following table lists frequently asked questions about these reports.

FAQ Answer

How do find these reports?

Edit, run, and view these reports from Navigator > Tools > Reports and Analytics > Financials > General Ledger.

Who uses these reports?

  • Financial Managers

  • 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 Transactional Business Intelligence

Oracle General Ledger provides predefined reports that cover the following areas:

  • Account Analysis

  • Journals

  • Trial Balance Reports

  • Reconciliation Reports

  • Chart of Accounts

You can schedule and run reports from the Scheduled Processes work area. In some cases, you can access and open reports in the Reports and Analytics work area. Use the Browse Catalog icon on the Reports and Analytics work area to open the business intelligence (BI) Catalog. You can run and edit reports in the BI Catalog.

The following table describes the predefined account analysis reports.

Name Description

Account Analysis

  • Prints balances by account segment and a secondary segment for each journal entry.

  • Lists the subledger document number for transactions imported from subledgers.

General Ledger Account Details Report

  • Provides journal information to trace each transaction back to its original source.

  • Prints a separate page for each balancing segment value.

  • For each journal line, prints:

    • The account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.

    • Journal details including source, category, journal name, and effective date.

  • Lists accounts in ascending order by account segment value.

  • Prints a CR next to credit amounts.

Account Analysis for Contra Account Report

  • Prints balances by account segment and a secondary segment.

  • Lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.

  • Prints by date range, accounting flexfield range, contra account, and amount range.

Average Balance Audit Account Analysis Report

  • Displays the detail account activity that created the aggregate balances and related average balances.

  • Displays daily average balance information for the selected accounts for the specified range of dates.

  • Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

Note: Use to research how average balances are calculated for an account.

The following table describes the predefined journal reports.

Name Description

Journals Report

  • Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

  • Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.

  • Includes a total for each balancing segment and a grand total for all the activity.

General Journals Report

Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Batch Summary Report

  • Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range.

  • Provides information about actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. Sorts the information by journal batch within each journal entry category.

  • Includes totals for each journal category and a grand total for each ledger and balancing segment value combination.

  • Doesn't report on budget or encumbrance balances.

Journals Details Report

Provides information about manually entered journals prior to posting, including field by field, all data entered into the applications or data imported from external sources.

Journals Day Book Report

  • Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.

  • Sorts journal entries for each accounting date by document number.

  • Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.

  • Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

Reconciled Transactions Report

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

Unreconciled Transactions Report

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

The following table describes the predefined trial balance reports.

Name Description

Trial Balance Report

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

Trial Balance - Average Balances

  • Provides a listing of ending balances and average balances for selected accounts based on an effective date specified.

  • Prints the ledger currency or foreign-entered balances.

  • Displays period, quarter, and year average-to-date balances.

Note: Request additional information by specifying balancing segments and account ranges.

The following table describes the predefined reconciliation reports.

Name Description

Cash to General Ledger Reconciliation Report

Extracts cash management and general ledger accounting and transactional data for reconciling cash management to the general ledger.

Payables to Ledger Reconciliation Report

  • Provides both summarized and detailed reconciling data for review.

  • Shows payables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted.

Receivables to Ledger Reconciliation Report

  • Provides reconciliation of receivables data to the general ledger.

  • Shows receivables and accounting beginning and ending balances, as well as summarized activity for the period and how the activity was accounted.

The following table describes the predefined chart of account reports.

Name Description

Balancing Segment Value Assignments Report

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

  • Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values.

Note: The application doesn't check for overlapping balancing segment values online.

Chart of Accounts Mapping Rules Report

  • Provides both the segment and account rules defined for a specific chart of accounts mapping.

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

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

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

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

  1. Click Schedule New Process.

  2. Search for the process name.

  3. Specify the parameters.

  4. Enter the process options and schedule.

  5. Click Submit.

General Ledger Account Analysis Reports

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

Overview

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

The image shows an Account Analysis for Contra
Account Report.

The account analysis reports include:

Account Analysis Reports Description

Account Analysis

  • Prints balances by account segment and a secondary segment for each journal entry.

  • Lists the subledger document number for transactions imported from subledgers.

General Ledger Account Details Report

  • Provides journal information to trace each transaction back to its original source.

  • Prints a separate page for each balancing segment value.

  • For each journal line, prints:

    • The account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.

    • Journal details including source, category, journal name, and effective date.

  • Lists accounts in ascending order by account segment value.

  • Prints a CR next to credit amounts.

Account Analysis for Contra Account Report

  • Prints balances by account segment and a secondary segment.

  • Lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.

  • Prints by date range, accounting flexfield range, contra account, and amount range.

Average Balance Audit Account Analysis Report

  • Displays the detail account activity which created the aggregate balances and related average balances.

  • Displays daily average balance information for the selected accounts for the specified range of dates.

  • Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

Note: Use to research how average balances are calculated for an account.

Key Insights

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

Parameters

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

Parameter Description Example

Data Access Set

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

US Ledger Set

Encumbrance Type

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

Commitments

Account Type

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

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

Includes User Transaction Identifiers

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

No

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

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

Company equals 101

Additional Segment

To run the report by account and another segment.

Cost Center

Document Sequence

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

Invoice

From and To Document Number

Assigned unique document sequence number.

101

Frequently Asked Questions

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

FAQ Answer

How do find these reports?

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

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

  • During preparation of closing entries.

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Journal Reports

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

Overview

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

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

This figure shows the Journals Report.

The following table describes each journal report.

Name Description

Journals Report

  • Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

  • Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.

  • Includes a total for each balancing segment and a grand total for all the activity.

General Journals Report

Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Batch Summary Report

  • Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range.

  • Provides information about actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. Sorts the information by journal batch within each journal entry category.

  • Includes totals for each journal category and a grand total for each ledger and balancing segment value combination.

  • Doesn't report on budget or encumbrance balances.

Journals Details Report

Provides information about manually entered journals prior to posting, including field by field, all data entered into the application or data imported from external sources.

Journals Day Book Report

  • Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.

  • Sorts journal entries for each accounting date by document number.

  • Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.

  • Prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center value.

Reconciled Transactions Report

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

Unreconciled Transactions Report

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

Key Insights

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

Parameters

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

Parameter Description Example

Data Access Set

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

US Ledger Set

From and To Accounting Date

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

10-01-2014

Includes Adjustment Period

Includes journals posted in adjustment periods, if selected.

No

Frequently Asked Questions

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

FAQ Answer

How do I find these reports?

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

Who uses these reports?

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During monthly journal entry processing.

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

  • In account balance reconciliations.

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger Trial Balance Reports

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

Overview

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

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

This figure shows the Trial Balance Report.

The following table describes the trial balance reports.

Name Description

Trial Balance Report

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

General Ledger Trial Balance

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

Trial Balance - Average Balances

  • Provides a listing of ending balances and average balances for selected accounts based on an effective date specified.

  • Prints the ledger currency or foreign-entered balances.

  • Displays period, quarter, and year average-to-date balances.

Note: Request additional information by specifying balancing segments and account ranges.

Key Insights

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

Parameters

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

Parameter Description Example

Data Access Set

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

US Ledger Set

Balancing Segment Filter and Condition Defined

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

Company equals 101

Account Filter and Condition Defined

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

Cost Center does not equal 100

Summarized By

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

Natural Account

From and To Accounting Date

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

10-01-2014

Includes Adjustment Period

Select to include journals posted in adjustment periods.

No

Frequently Asked Questions

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

FAQ Answer

How do find these reports?

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

Who uses these reports?

  • Financial Managers

  • Financial Accountants

  • Financial Specialists

When do I use these reports?

  • During month-end reconciliation.

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

What type of reports are these?

Oracle Business Intelligence Publisher

General Ledger 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

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.

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.

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.

Approval Groups Report

This topic includes details about the Approval Groups Report.

Overview

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

Key Insights

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

Report Parameters

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

Frequently Asked Questions

FAQ Answer

How do I find this report?

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

Who uses this report?

Workflow Rules Administrator

When do I use this report?

Use this report to review approval groups defined in BPM.

What type of a report is this?

Spreadsheet, XML

Workflow Rules Report

This topic includes details about the Workflow Rules Report.

Overview

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

Key Insights

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

Report Parameters

Parameter Description

Workflow

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

Frequently Asked Questions

FAQ Answer

How do I find this report?

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

Who uses this report?

Workflow Rules Administrator

When do I use this report?

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

What type of a report is this?

Spreadsheet, XML

Create a Financial Report

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

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

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

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

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

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

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

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

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

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

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

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

  6. Click OK. The Dimension Layout window opens.

Arrange Dimensions and Define Rows

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

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

    1. Accounting Period dimension to the Columns frame.

    2. Account dimension to the Rows frame.

    3. Company dimension to the Pages frame.

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

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

  3. Select the revenues account.

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

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

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

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

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

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

  5. Save the report.

    1. From the File menu, select Save As.

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

    3. Click Save.

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

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

    2. From the Insert Row menu, select Text.

  7. Insert a row for the expense accounts.

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

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

  8. Select the expense accounts.

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

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

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

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

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

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

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

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

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

Add a Formula to a Financial Report

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

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

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

  2. From the Insert Row menu, select Formula.

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

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

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

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

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

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

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

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

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

Define a Range Function for a Financial Report

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

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

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

Now follow these steps.

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

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

  3. Click the Functions tab.

  4. Click the Range list item.

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

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

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

    3. Click the Functions tab.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    1. Click the Current Point of View list item.

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

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

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

  9. Click OK. The Select Members window closes.

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

Define a Grid Point of View for a Financial Report

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

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

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

  3. Define a Range Function for a Financial Report

Now follow these steps.

  1. Select the grid.

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

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

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

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

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

    4. Click the Balance Amount tab.

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

    6. Click the Currency tab.

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

    8. Click the Currency Type tab.

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

    10. Click OK. The Select Members window closes.

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

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

Set Page and Grid Properties for a Financial Report

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

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

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

  3. Define a Range Function for a Financial Report

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

Now follow these steps.

  1. Select the grid.

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

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

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

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

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

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

    3. Select the Prompt for Company list item.

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

    5. Click OK. The Define Prompt window opens.

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

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

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

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

    10. Click OK. The Select Members window closes.

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

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

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

  4. On the Grid Properties sheet:

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

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

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

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

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

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

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

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

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

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

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

Format a Financial Report and Add a Graph

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

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

  1. Define a Basic Financial Report

  2. Add a Formula to a Financial Report

  3. Define a Range Function for a Financial Report

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

  5. Set Page and Grid Properties for a Financial Report

Now follow these steps.

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

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

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

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

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

    2. Enter a report title.

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

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

    5. Click OK.

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

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

  4. Click OK.

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

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

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

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

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

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

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

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

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

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

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

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

  6. Save the report.

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

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

This image shows an example income statement by
period.

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

Inquiries

View an Account Group from the Financial Reporting Center

This example shows how to view an account group from the Financial Reporting Center.

Viewing an Account Group

  1. Navigate to the Financial Reporting Center.

  2. Click the Sales Organization account group link.

  3. Change the period to 03-17. The balances are automatically updated.

  4. Click Show/Hide Segments.

  5. On the Account segment, select Value and Description.

  6. For the Product and Intercompany segments, clear Value.

  7. Click Done.

  8. Click View as Sunburst.

  9. Click Show Description.

  10. Select any cost center segment and click Move Ring Toward Center.

    Note: You can also use the Segments section to move the rings.

  11. Click Done.

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.

How You Inquire on Detail Balances

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

Search Criteria

Here are some points to consider when entering search criteria.

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

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

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

Saved Search

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

  1. Enter your search criteria.

  2. Click Save.

  3. Enter a name for the search.

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

  5. Click OK.

Search Results

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

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

  • Export the balances to Excel.

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

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

Drill Through from Financial Reporting and Smart View

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

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

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

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

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

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