5 Manage Financial Reporting and Analysis

This chapter contains the following:

Financial Reporting Solutions: Points to Consider

Financial Reporting Center: How It Works

Oracle Hyperion Financial Reporting Studio: Explained

Oracle Hyperion Smart View: Explained

Oracle Fusion Financial Reports and Analytics: Overview

Oracle Fusion General Ledger Predefined Reports

Configuring Account Groups for Account Monitor: Example

Prepare Financial Reports: Oracle Fusion Financials for Asia/Pacific

Financial Reporting Solutions: Points to Consider

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

The figure shows the Oracle Fusion financial reporting solutions that use data stored in the balances table in the form of preaggregated balances. These balances are posted and aggregated from the Oracle Fusion General Ledger journal entry data. The Oracle Fusion subledgers import transactional data into the General Ledger in the form of journal entries that are then posted to the balances table.

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


Reporting Need

Solution

Boardroom ready financial statements with live drill down to your source transactions

Financial Reporting in the Financial Reporting Center

Exception based account monitoring with multidimensional analysis and drill down capability

Account Monitor and Account Inspector in the Financial Reporting Center and from the General Accounting Dashboard

Spreadsheet financial reports with multidimensional analysis, pivoting, and drill down capability

Oracle Hyperion Smart View

High volume operational reporting with configurable templates

Oracle Business Intelligence Publisher (BI Publisher)

Ad hoc queries of transactions

Oracle Fusion Transactional Business Intelligence

Financial Reporting Center

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

Account Monitor and Account Inspector

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

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

Oracle Hyperion Smart View

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

Oracle Business Intelligence Publisher (BI Publisher)

For frequent and high volume reports, BI Publisher provides:

Oracle Fusion Transactional Business Intelligence (BI)

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

Financial Reporting Center: How It Works

The Oracle Fusion Financial Reporting Center provides functionality for reporting on Oracle Fusion General Ledger balances. It provides secure, self-service access to reports that use real time account information.

You can design traditional financial report formats such as balance sheets, profit and loss statements, and cash flow reports. You can also design nontraditional formats for financial or analytic data that include text and graphics.

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

Components

Financial Reporting Center is comprised of numerous components:

Oracle Hyperion Financial Reporting Studio: Explained

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

Financial Reporting Studio supports the following functionality:

Oracle Hyperion Smart View: Explained

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

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

Ad Hoc or Free-Form Analysis

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

Predefined Form Interaction

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

Report Design

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

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

Oracle Fusion Financial Reports and Analytics: Overview

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

Report Links

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

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

Business Intelligence Analysis and Dashboards

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

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

Oracle Fusion General Ledger Predefined Reports

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

Oracle Business Intelligence Publisher

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

Oracle Fusion Translational Business Intelligence

All the reports including those classified as Oracle Fusion Transactional Business Intelligence (BI) are accessed from the Reports and Analytics pane on the Navigator menu or from dashboards, where the reports are saved. The report links in the Reports and Analytics pane open in the Oracle Business Intelligence Catalog where reports can be edited, printed, and reviewed.

The following tables are the lists of predefined reports by type.

Account Analysis Reports


Process Name

Display Name

Description

Classification

GLACTANL2

Account Analysis

Prints balances by account segment and a secondary segment for each journal entry, and lists the subledger document number for transactions imported from subledgers.

Oracle Fusion Transactional Business Intelligence (BI)

GLRFCLD

General Ledger Report

Provides journal information to trace each transaction back to its original source. Prints a separate page for each balancing segment value. For each journal line, prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance. Additionally, for each journal line, prints journal details including source, category, journal name, and effective date. Lists accounts in ascending order by account segment value, and prints a CR next to credit amounts.

Oracle Business Intelligence Publisher (BI Publisher)

GLWACCTR

Account Analysis for Contra Account Report

Prints balances by account segment and a secondary segment, lists the contra account for each journal entry, and lists the subledger document number for transactions imported from subledgers. Print this report by date range, accounting flexfield range, contra account, and amount range.

BI Publisher

GLXAVADT

Average Balance Audit Account Analysis Report

Displays the detail account activity which created the aggregate balances and related average balances. Used to research how average balances are calculated for an account. Displays daily average balance information for the selected accounts for the specified range of dates. Contains parameters such as the as-of reporting date, average balance type (period, quarter, or year average-to-date), and account ranges.

BI Publisher

Journal Reports


Process Name

Display Name

Description

Classification

GLJRNL

Journals Report

Provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values. Prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal. In addition, a total is provided for each balancing segment and a grand total is provided for all the activity included.

BI Publisher

GLRXVCJ

General Journals Report

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

Oracle Fusion Transactional (BI)

GLYRLJRE

Journals Batch Summary Report

Lists posted journal batches for a particular ledger, balancing segment value, currency, and date range. Provides information on actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits, and sorts the information by journal batch within each journal entry category. In addition, totals are provided for each journal category and a grand total for each ledger and balancing segment value combination included in your report. Does not report on budget or encumbrance balances.

BI Publisher

GLRXCKJ

Journals Check Report

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

BI Publisher

GLRXDBJ

Journals Day Book Report

Provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category. For each accounting date, journal entries are sorted by document number. Prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate. For each journal line, it also prints the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

BI Publisher

Trial Balance Reports


Process Name

Display Name

Description

Classification

GLTRBAL

Trial Balance Report

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

BI Publisher and Oracle Fusion Transactional (BI)

GLXAVTRB

Trial Balance - Average Balances

Provides a listing of ending balances and average balances for selected accounts based on an as of date specified. Print the ledger currency or foreign-entered balances. In addition, displays period, quarter, and year average-to-date balances. Request additional information by specifying balancing segments and account ranges.

BI Publisher

Reconciliation Reports


Process Name

Display Name

Description

Classification

GLReconciliationReport

Cash to General Ledger Reconciliation Report

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

BI Publisher

Payables to Ledger Reconciliation Report

Payables to Ledger Reconciliation Report

Provides both summarized and detailed reconciling data for review. Shows payables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted.

Oracle Fusion Transactional (BI)

Receivables to Ledger Reconciliation Report

Receivables to Ledger Reconciliation Report

Provides reconciliation of receivables data to the general ledger. Shows receivables and accounting beginning and ending balances, as well as summarized activity for the period and how the activity was accounted.

Oracle Fusion Transactional (BI)

Chart of Accounts Reports


Process Name

Display Name

Description

Classification

GLXBSVA

Balancing Segment Value Assignments Report

Reports on the assignment of primary balancing segment values to legal entities and ledgers across accounting setups. Allows quick identification of overlapping balancing segment value errors and reviews of any unassigned values. The application does not check for overlapping balancing segment values online.

BI Publisher

GLXCOCRR

Chart of Accounts Mapping Rules Report

Provides both the segment and account rules defined for a specific chart of accounts mapping. If the mapping has account rules, prints each subsidiary account range and the parent account into which it maps. If the mapping has segment rules, prints the rule name and the parent and subsidiary segments. If the mapping has a rollup range rule, prints each subsidiary segment value range and its corresponding parent segment value.

BI Publisher

To run BI Publisher reports, use the following steps the Scheduled Processes work area in the Navigator menu.

  1. Click the Schedule New Process button

  2. Search on the Process Name.

  3. Enter the desired parameters.

  4. Enter the desired process options and schedule.

  5. Click Submit.

Configuring Account Groups for Account Monitor: Example

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

Scenario

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

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

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

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

  4. Click Save and Close or Save and Create Another

Prepare Financial Reports: Oracle Fusion Financials for Asia/Pacific

Enterprise Financial Data for China: How It Is Exported

The enterprise financial data export for China functionality provides processes for exporting financial data from Oracle Fusion Financials Common Module, Oracle Fusion General Ledger, Oracle Fusion Payables, Oracle Fusion Payments, Oracle Fusion Receivables, Oracle Fusion Subledger Accounting, and Oracle Fusion Assets into a format specified by the National Audit Office of the People's Republic of China.

It is based on the Financial Information Technology - Data Interface of Accounting Software (GB/T 24589-2010) standard, a new national standard developed by the National Audit Office of the People's Republic of China and approved by the Standardization Administration of the People's Republic of China.

Settings That Affect Enterprise Financial Data Export for China

Before exporting the financial data, perform the following setup tasks:

How Financial Data Is Exported

The following scheduled processes are used to export financial data in an XML format as specified by the Chinese standards. The files are exported based on the legal entities.

Export General Ledger Data for China: How Data Is Exported

The Export General Ledger Data for China: Enterprise process exports data from Oracle Fusion General Ledger for an enterprise. On successful execution of the process, data is exported in an XML file.

Run the process from the Scheduled Processes Overview page under Navigator - Tools.

Settings That Affect Data Export

Set the following parameters before running the process:


Parameter

Description

Data Access Set

Specify the data access set that is associated with your data role.

Ledger

Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.

Legal Entity

When the selected ledger is a primary ledger, specify the legal entities assigned to it.

When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.

Accounting Year

Specify the accounting years associated with the accounting calendar of the selected ledger.

From Period

Specify the beginning of a range of general ledger periods to be included for exporting data.

To Period

Specify the end of a range of general ledger periods to be included for exporting data.

Oracle Hyperion Reports

Specify the following Oracle Hyperion reports:

  • Cash Flow Statement Report

  • Balance Sheet Report

  • Profile Statement Report

  • Statement of Changes in Owner's Equity Report

How Data Is Exported

The XML file includes the following sections:

Export Payables and Receivables Data for China: How Data Is Exported

The Export Payables and Receivables Data for China: Enterprise process exports data from Oracle Fusion Payables, Oracle Fusion Payments, and Oracle Fusion Receivables for an enterprise. On successful execution of the process, data is exported in an XML file.

Run the process from the Scheduled Processes Overview page under Navigator - Tools.

Settings That Affect Data Export

Set the following parameters before running the process:


Parameters

Description

Data Access Set

Specify the data access set that is associated with your data role.

Ledger

Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.

Legal Entity

When the selected ledger is a primary ledger, specify the legal entities assigned to it.

When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.

Accounting Year

Specify the accounting years associated with the accounting calendar of the selected ledger.

From Period

Specify the beginning of a range of general ledger periods to be included for exporting data.

To Period

Specify the end of a range of general ledger periods to be included for exporting data.

How Data Is Exported

The XML file includes the following sections:

The following common details are exported to the XML file and are part of both the Payables and Receivables sections:

The following table lists the details that are specific to the Payables and Receivables sections:


Payables

Receivables

Supplier or customer number

Only suppliers with a balance greater than zero or suppliers with valid transactions during the period are exported. The file does not include suppliers of type employee.

Only customers with a customer balance greater than zero or customers with valid transactions during the period are exported and displayed.

Journal date

Displays the General Ledger date of the Payables transaction line.

Displays the General Ledger date of the Receivables transaction line.

Accounted amount balance

Displays the ending accounted amount balance as per account and supplier in the current period.

Displays the ending accounted amount balance as per account and customer in the current period.

Entered balance

Displays the ending entered balance as per account and supplier in the current period by the currency.

Displays the ending entered balance as per account and customer in the current period by the currency.

Accounted amount

Displays the ledger currency amount on the Payables accounting line.

Displays the ledger currency amount on the Receivables accounting line.

Entered amount

Displays the entered currency amount on the Payables transaction line.

Displays the entered currency amount on the Receivables transaction line.

Description

Displays the description from the Payables invoice header and the payment description.

Displays the description from the Receivables transaction and the receipt description.

Due date

Displays the date when the invoice is due for payment. The date is calculated based on the invoice terms date and the invoice payment terms.

For example, when the invoice terms date is January 1, 2012, and the invoice payment term is 30, the due date is calculated as January 30, 2012.

For receivables line, displays the due date of the transaction. For receipt line, displays the maturity date of the receipt.

Applied journal number

The data is exported for payment and prepayment accounting lines. The value is blank for invoice lines.

For payment accounting lines, the applied journal number is the journal number of the invoice paid. When the journal number is different for each invoice, the applied journal number is displayed in different lines.

For prepayment accounting lines, the applied journal number is the journal number of prepayment.

Note

The applied journal number for invoices is displayed only when the invoice is applied to the prepayment.

The data is exported for receipts and credit memo accounting line. The value is blank for transaction lines.

When the receipt is applied to more than one transaction, the process displays the receipt as separate lines under each transaction.

When more than one receipt is applied to one transaction, the process displays the receipts under each transaction.

Applied date

For payments, the applied date is the payment date. For invoices, the date is the date on which the invoice was applied to the prepayment. When the invoice is not applied to the prepayment, the date is left blank.

For receipt lines, it is the General Ledger date of the applied transaction. For transaction lines, the date is left blank.

Document type number

Displays the number on the payable note for an invoice and displays the number on the payment note for the payment.

Displays the number on the receivables note for transactions and displays the number on the receipt note for receipts.

Transaction number

Displays the voucher number for each invoice line and displays the document number for payment.

Displays the Receivables transaction number for each transaction line and displays the receipt number for receipt line.

Invoice number

Displays the invoice number for invoices. The value is blank for payments.

Displays the value-added tax (VAT) invoice number on the golden tax invoice. When there are multiple VAT invoices for a transaction, the process appends the VAT invoice number with a comma.

Contract number

Displays the purchase order (PO) number when the invoice matches the PO.

Displays the sales order number of the transaction, when the transaction is imported from Oracle Fusion Order Management.

Project number

Displays the project number from the invoice header.

Displays the project number from the Oracle Fusion Project Foundation invoice transaction flexfield.

Settlement method number

Displays the payment method used for invoice and payments.

Displays the receipt method used for transactions and receipts.

Payment date

Displays the payment date of the payment. The value is blank, when it is an invoice line.

For receipts, it is the receipt date and for transaction lines, the value is blank.

Clear flag

When the invoice is fully paid or applied, the process displays 1 for the invoice and payment line. When the invoice is unpaid or applied, it displays 0.

When the prepayment is fully applied, it displays 1. When the prepayment is not paid or applied, it displays 0.

When the transaction or receipt is fully applied during a period, the clear indicator is 1. When the transaction or receipt has never been applied, the clear indicator is 0.

Remittance bill number

Displays the global descriptive flexfield from the payment header.

Displays the global descriptive flexfield from the receipt header.

Export Fixed Assets Data for China: How Data Is Exported

The Export Fixed Assets Data for China: Enterprise process exports data from Oracle Fusion Assets for an enterprise. On successful execution of the process, data is exported in an XML file.

Run the process from the Scheduled Processes Overview page under Navigator - Tools.

Settings That Affect Data Export

Set the following parameters before running the process:


Parameter

Description

Data Access Set

Specify the data access set that is associated with your data role.

Ledger

Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.

Legal Entity

When the selected ledger is a primary ledger, specify the legal entities assigned to it.

When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.

Accounting Year

Specify the accounting years associated with the accounting calendar of the selected ledger.

From Period

Specify the beginning of a range of general ledger periods to be included for exporting data.

To Period

Specify the end of a range of general ledger periods to be included for exporting data.

How Data Is Exported

The XML file includes the following sections:

Export Shared Information Data for China: How Data Is Exported

The Export Shared Information Data for China: Enterprise process exports shared information data for an enterprise. On successful execution of the process, data is exported in an XML file.

Note

To export shared information data, you must have the duty role, Enterprise Financial and Employee Data Export for China Duty.

Settings That Affect Data Export

Run the process from the Scheduled Processes Overview page under Navigator - Tools. The following table describes selected process parameters:


Parameters

Description

Data Access Set

Specify the data access set that is associated with your data role.

Ledger

Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.

Legal Entity

When the selected ledger is a primary ledger, specify the legal entities assigned to it.

When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.

Accounting Year

Specify the accounting year associated with the accounting calendar of the selected ledger.

Department Tree

Specify the name of the department tree from which you want to export data.

Department Version

Specify the name of the department tree version from which you want to export data.

Department Node

Specify the name of the department tree node from which you want to export data.

Include Top Node

Specify whether the top node in the department tree structure must be exported.

What Shared Information Data Is Exported

The XML file displays the shared information data that is exported. It includes the following sections:

Generating the Cash Flow Statement: Explained

The cash flow statement reflects the sources and uses of money in an accounting period for an enterprise. It is a financial report required by the China Ministry of Finance. The cash flow statement analyzes the financial status of an enterprise in cash or the corresponding equivalent as follows:

The cash flow statement is defined in Oracle Hyperion and includes two parts: the main statement and the supplemental statement. The main statement includes information about the cash inflow and outflow generated by the operating activities, investing activities, and financing activities. In the supplementary statement, you define the account assignments for the corresponding lines and the formulas to calculate the values in the rows and columns.

The cash flow statement functionality allows you to define and export the Cash Flow Statement and is based on balance segment values. It covers the related cash flow businesses, including general ledger and subledgers.

In the primary ledger, the cash flow statement solution adds a new cash flow segment for the chart of accounts. The cash flow items are collected by the amount of the accounting lines.

Before collecting and generating the cash flow statement, define cash flow item segment in the chart of accounts. Use the Local Use segment qualifier available in Oracle Fusion General Ledger. This segment qualifier is used to identify the cash flow segment. Assign one segment in the chart of account as Local Use. In addition, use the Standard Accrual for China subledger accounting methods that are defined in the subledger accounting method in Oracle Fusion Subledger Accounting.

Complete the following daily transactions before generating the cash flow statement:

General Ledger Transactions

When entering journals in General Ledger, use the Local Use segment qualifier in the chart of accounts for a journal line account that is noncash-related. Enter the cash flow segment on the opposite side of the cash-related account. After defining the segment qualifier and posting the journal, run the General Ledger and Subledger Transactions Mapping process to validate that the journal line accounts are cash related and correspond to the relevant cash flow items. For cash-related journals, use the default cash flow item in the cash-related accounts.

Intercompany Transactions

You can transfer intercompany transactions to the General Ledger or create invoices in subledgers. While entering transactions in Oracle Fusion Intercompany, use the Local Use segment qualifier in chart of accounts. Enter the cash flow segment on the opposite side of the cash-related account of the distribution line. The General Ledger and Subledger Transactions Mapping process collects all the posted accounts from subledgers. Validate that the transaction line accounts are cash-related and correspond to the relevant cash flow items.

Subledger Transactions

The cash flow statement functionality collects subledger cash-related activities based on the Local Use segment qualifier in the chart of accounts from subledger journal entries tables.

Receivables Transactions

All cash-related Receivables transactions are collected based on the Local Use segment qualifier in the chart of accounts.

The following rules apply to Receivables transactions:

The following table describes the cash flow segment source for each accounting class. It is important to define the cash flow segment source correctly to be able to generate an accurate cash flow statement.


Accounting Class

Cash Flow Segment Source

Notes

Receipt Bank Charges

Bank charge account

Define the bank charges account using the bank account definition page and the receipt classes setup page.

Receipt On Account Application

On account

Define the on-account receipts account using the receipt classes setup page.

Receipt Refund Application

Refund account

Define the refund type account using the receivables activities definition page.

Receipt Unapplied Cash

Unapplied account

Define the unapplied receipts account using the receipt classes setup page.

Receipt Unidentified Cash

Unidentified account

Define the unidentified receipts account using the receipt classes setup page.

Receipt Write-Off Application

Write-off account

Define the receipt write-off type account using the receivables activities definition page.

Receivable or Revenue or Tax

Transaction type

Define the receivable, revenue, or tax accounts based on the receivables transaction type.

Define automatic accounting rules for these accounting classes based on the transaction type.

Miscellaneous Receipt Miscellaneous Cash

Miscellaneous receipt account

Define the miscellaneous cash type account using the receivables activities definition page.

Payables Transactions

All cash-related Payables transactions are collected based on the Local Use segment qualifier in the chart of accounts.

The cash flow statement solution supports invoices that are imported and manually entered. The source of imported invoice can be:

The following rules apply to Payables transactions:

The following table describes the cash flow segment source for each accounting class. It is important to define the cash flow segment source correctly to be able to generate an accurate cash flow statement.


Accounting Class

Cash Flow Segment Source

Notes

Item expense-for ERS and PO matched invoices

PO category or item category accrual account and the expense account

Item expense-for expense report and Expenses invoices

Expense report item account

Define the expense report item account in the expense report template.

Refund invoice from Receivables

Refund account

Define the refund type account using the receivables activities definition page.

Intercompany invoice

Intercompany account

Define the cash flow segment source using the intercompany account definition page.

Prepayment

Supplier site

When there are two cash flow segments for one supplier, separate by the supplier site.

General Ledger and Subledger Transactions Mapping Report: How It Is Processed

The General Ledger Journal and Subledger Transactions Mapping Report process exports the accounting entries with detailed information from subledger and journals and lists the results using an Oracle Business Intelligence Publisher report.

Run the process from the Scheduled Processes Overview page under Navigator - Tools.

Settings That Affect Data Export

Some of the parameters associated with the process are given in the following table.


Parameters

Description

Data Access Set

Specify the data access set that is associated with your data role.

Ledger

Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.

Legal Entity

When the selected ledger is a primary ledger, specify the legal entities assigned to it.

When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.

Source

Specify the name of the journal source as defined in the Manage Journal Source page.

From Batch Name

Specify the beginning of a range of the general ledger batch name list to be included for exporting data.

To Batch Name

Specify the end of a range of the general ledger batch name list to be included for exporting data.

From Document Number

Specify the beginning of a range of general ledger sequence number to be included for exporting data.

To Document Number

Specify the end of a range of general ledger sequence number to be included for exporting data.

From Period

Specify the beginning of a range of general ledger periods to be included for exporting data.

To Period

Specify the end of a range of general ledger periods to be included for exporting data.

How Data Is Exported

The report includes the following sections:

Data is exported to the report based on the following criteria:

Cash Flow Statement: Examples

The cash flow statement is defined in Oracle Hyperion and includes two parts: the main statement and the supplementary statement. The main statement includes information about the cash inflow and outflow generated by the operating activities, investing activities, and financing activities. In the supplementary statement, you define the account assignments for the corresponding lines and the formulas to calculate the values in the rows and columns.

Cash flow statements use the balance amount of the cash flow segment, which is the Local Use segment qualifier in the chart of accounts.

Main Statement

Consider an expense of CNY 100.

During the period, the balance amount of the cash flow item (1230) should be CNY 100.

In the cash flow statement, 100 should be the amount of the cash flow item 1230.


Line Number

Line Item

Calculation Lines

Cash Flow Item Assignment

10

1. Cash flows from operating activities:

20

Cash received from sales of goods or rendering of services

1110, 1120

30

Refund of taxes and levies

1130

40

Other cash received relating to operating activities

1140

50

Subtotal of cash inflows

20+30+40

60

Cash paid for goods and services

1210, 1220

70

Cash paid to and on behalf of employees

1230

80

Payments of all types of taxes

1240

90

Other cash paid relating to operating activities

1250

100

Subtotal of cash outflows

60+70+80+90

110

Net cash flows from operating activities

50+100

120

2. Cash flows from investing activities:

130

Cash received from return of investments

2110

140

Cash received from return on investments

2120

150

Net cash received from disposal of fixed assets, intangible assets and other long-term assets

2130, 2140, 2150

160

Other cash received relating to investing activities

2160

170

Subtotal of cash inflows

130+140+150+160

180

Cash paid to acquire fixed assets, intangible assets and other long-term assets

2210, 2220, 2230

190

Cash paid to acquire investments

2240

200

Other cash paid relating to investing activities

2250

210

Subtotal of cash outflows

180+190+200

220

Net cash flows from investing activities

170+210

230

3. Cash flows from financing activities:

240

Cash received from investments by others

3110

250

Cash received from borrowings

3120

260

Other proceeds relating to financing activities

3130

270

Subtotal of cash inflows

240+250+260

280

Cash repayments of amounts borrowed

3210

290

Cash payments for distribution of dividends or profits

3220

300

Other cash payments relating to financing activities

3230

310

Subtotal of cash outflows

280+290+300

320

Net cash flows from financing activities

270+310

330

4. Effect of foreign conversion rate changes on cash

620-110-220-320

340

5. Net increase in cash and cash equivalents

620

Supplementary Statement

The values in the supplementary statement are derived as follows:

The supplementary report uses the balance amount of each natural account. The column sequence, of the column names for this cash flow statement, is as follows:


Column Name

Column Sequence

30-20

10

YTD-Actual (Offset-1)

20

YTD-Actual

30

The following table shows an example of a cash flow statement-supplementary report.


Column Definition

Line Number

30-20

YTD-Actual (Offset -1)

YTD-Actual

Supplemental information

1. Adjust net profit to operating activity cash flows

Net profit

57

Amount

Add: Provision for property depreciation

58

Amount

Depreciation of fixed assets

59

Amount

Amortization of intangible assets

60

Amount

Amortization of other long-term deferred expense

61

Amount

Decrease of deferred expense (deduct: increase)

64

Amount

Increase of accrued expense (deduct: decrease)

65

Amount

Losses on disposal of fixed assets, intangible assets, and other long-term assets

66

Amount

Losses on scrapping of fixed assets

67

Amount

Financial expense

68

Amount

Losses from investments (deduct: gains)

69

Amount

Deferred tax credit (deduct: debit)

70

Amount

Decrease in inventories (deduct: increase)

71

Amount

Decrease in operating receivables (deduct: increase)

72

Amount

Increase in operating payables (deduct: decrease)

73

Amount

Other

74

Amount

Net cash flows from operating activities

75

Amount

2. 1. Investing and financing activities that do not involve cash receipt and payment

Capitals converted from debts

76

Amount

Current maturity of convertible bonds

77

Current maturity of convertible bonds

78

3. Net increase in cash and cash equivalents

Cash balance at the end of the period

79

Amount

Deduct: Cash balance at the beginning of the period

80

Amount

Add: Cash equivalents balance at the end of the period

81

Amount

Deduct: Cash equivalents balance at the beginning of the period

82

Amount

Net increase in cash and cash equivalents

83

Note

Define cash flow statement items in Chinese.

Calculating Cash Flow Amount: Example

The basic rule for calculating the cash flow amount is the period to date balance amount for each cash flow segment in the chart of accounts. The set up tasks aim to get the cash flow amount for each cash related transaction according to the amount between the debit and credit side of the cash flow segment. For noncash-related transactions, the cash flow segment is balanced between the debit and credit side. Cash flow amount is obtained from the opposite side of the cash related account.

Scenario

For example, consider an invoice in Oracle Fusion Payables that is related to a noncash-related transaction, but is the source of the cash flow item, so the account in the Payables invoice is:

The cash flow segment 1001 in this transaction is balanced.

The payment in Payables is a cash-related transaction, so the cash flow amount is calculated as:

When 1001001 is the cash account and the cash flow segment on the credit side is null, the cash flow amount from the cash flow segment for the transaction is CNY 100.

Defining Revaluation Template in Oracle Fusion General Ledger: Explained

Revaluation template is defined by currency and is based on cash flow segment.

For cash related accounts, the cash flow segment is the default segment. Therefore, the gain/loss account in the template must also be the default values. For example, 0000.

For noncash-related accounts, such as liability and receivable accounts in Oracle Fusion Payables and Oracle Fusion Receivables respectively, the template is defined in detailed based on each cash flow segment in the chart of account.

For example, when a foreign currency invoice in the period end is not paid, revaluate the 2010001 Liability account.

To balance the cash flow amount in the revaluation template, the gain/loss account must also have the same cash flow segment. Hence, the gain/loss account in the chart of account must be 01.000.Gain/Loss.1001.

Defining Automatic Accounting Rules in Oracle Fusion Receivables: Explained

The automatic accounting rules in Oracle Fusion Receivables help in obtaining the source of the cash flow segment. For example, when you set the transaction type for a cash flow segment in the automatic accounting rule, the account details are:

When you receive the receipt and apply it to the transaction, the cash flow amount is calculated as CNY 117:

Define your own cash flow segment source rules according to your business requirements. It can be from the transaction type, customer site and so on.

Handling Dummy Bank Transactions: Explained

In Oracle Fusion, it is difficult to distinguish between a real bank account and a dummy bank account. For dummy bank transactions, balance the cash flow segment manually according to your business.

Dummy payments are payments made from a payment bank account that is not a real bank account. Dummy payments are used for clearing transactions and are classified as noncash-related transactions in Oracle Fusion Payables.

For example, consider an invoice of CNY 100 that needs to be paid in US dollars (USD). In such a scenario, make a dummy payment using a dummy bank account in CNY, input a journal in the Oracle Fusion General Ledger, and choose a real bank account to make the payment in USD.

The cash flow amount for such dummy payments is calculated as:

Debit: 01.000.2010001.1001 (CFS) CNY 100

Credit: 01.000.9009009.0000 (CFS) CNY 100 (this is a dummy clearing account)

When making dummy payments, balance the cash flow segment manually in General Ledger to input an adjustment journal:

Debit: 01.000.9009009.0000 (CFS) CNY 100

Credit: 01.000.9009009.1001 (CFS) CNY 100

FAQs for Prepare Financial Reports: Oracle Fusion Financials for Asia/Pacific

Why is the trial balance report not balanced?

The cash flow amount is obtained from the opposite side of the cash-related account in a chart of accounts. Therefore, the trial balance must be balanced at the natural account level instead of the chart of accounts level.

How can I define a cash flow item segment in the chart of accounts?

Use the local use segment qualifier available in Oracle Fusion General Ledger to define the segment qualifier. This segment qualifier is used to identify the cash flow segment. Assign one segment in the chart of accounts as Local Use.

Where does the cash flow segment for a purchase order matched invoice come from?

For invoices that are related to a purchase order (PO), the cash flow segment is obtained from the PO charge account and the PO accrual account.

The PO charge account and the PO accrual account are the sources for the cash flow segment in Oracle Fusion Payables for the invoice distribution account.

For example, define the cash flow segment according to the item category and PO category.

Define the cash flow segment for an expense account on the Category Account Definition page, and use the workflow to get the cash flow segment in the PO charge account and the PO accrual account. The cash flow segment matches the invoice distribution account.