Cloud Documentation
Advanced Search


Using Accounting Transactions, Tax Transactions, and Reporting
Close Window

 

This guide also applies to on-premise implementations

Table of Contents

Show All | Collapse

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:

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

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

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

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

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

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

The 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:

  • Running live reports and books in various formats

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

  • Creating embedded charts and graphs

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

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

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

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

  • Distributing reports automatically across your organization using e-mail

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

Account Monitor and Account Inspector

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

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

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

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

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

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

  • Perform ad hoc multidimensional pivot table analysis

  • Review charts based on the Account Monitor data

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

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

Oracle Hyperion Smart View

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

  • Perform ad hoc multidimensional pivot analysis with full spreadsheet functionality

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

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

  • Analyze actual, budget, and forecast information

  • Increase visibility with charts and graphs

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

Oracle Business Intelligence Publisher (BI Publisher)

For frequent and high volume reports, BI Publisher provides:

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

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

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

  • Scheduled reports for delivery to a wide range of destinations

Oracle Fusion Transactional Business Intelligence (BI)

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

  • Ability to perform ad hoc queries directly from transactional tables

  • Drag and drop functionality to build the report layout, and immediately run the report to obtain real time results

  • Shared queries and reports using the Report Catalog, a reporting option used to view or save specific definitions

Financial Reporting Center: How It Works

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

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

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:

  • Financial Reporting: Financial users and analysts access live reports and books or published snapshot reports and books from previously scheduled batches in a variety of formats. Other functionality includes:

    • Refreshing report data using runtime points of view or parameters

    • Drill through capability from parents to other parents

    • Drill down to detail balances, journal lines, and subledger transactions.

  • Oracle Hyperion Smart View: Financial analysts view, import, manipulate, distribute, and share data from your Oracle Fusion General Ledger balances in Microsoft Excel.

  • Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down capability.

  • Workspace: Reporting administrators create, open, save, and delete folders and store report objects, reports, and snapshot reports.

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

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:

  • Client based report definition tool.

  • Object based reporting. Objects are reusable across multiple reports

  • Drag and drop report grids

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

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

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

  • Select dimension member using member selection or functions

  • Add calculations or mathematical functions

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

  • Predefined form interaction

  • Report design

Ad Hoc or Free-Form Analysis

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

Predefined Form Interaction

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

Report Design

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

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

  • Perform ad hoc multidimensional pivot analysis with full spreadsheet functionality

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

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

  • Analyze actual, budget, and forecast information

  • Increase visibility with charts and graphs

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

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:

  • Define general information for an accounting book based on a specific legal entity. For example, book name, book number, company name, organization code, and so on.

  • Export general ledger cash journals and general ledger 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.

  • Specify the cash flow statement rows that will be used in the cash flow statement including both the main statement and the supplementary schedule. Two new attributes, item source and item attribute are required along with the other cash flow item attributes.

    Item source is used to identify the reporting item source in the statutory cash flow statement, such as main statement or supplementary statement.

    Item attribute indicates the attribute of cash flow statement reporting item, for example, the direction of cash flow, like inflow or outflow.

  • Define the subsidiary account sources based on the chart of accounts. Three types of subsidiary account sources are available, all chart of account segments except balancing segment and natural account segment, third party, such as customer, supplier, and employee supplier information, and project number.

  • Define the text formulas for the depreciation methods in Assets.

  • Specify the descriptive flexfields and attributes that will be used to store additional information.

  • Run the Itemize Account and Journal for China process before exporting any financial data. The process is based on ledger and generates itemized amount and balance for each natural account along with available subsidiary account information according to the Chinese standards.

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.

  • The Export Shared Information Data for China: Enterprise process exports shared information data for an enterprise. The XML file includes the following sections: electronic accounting book, accounting period, journal category, exchange rate data type, currency, settlement method, supplier record, customer record, user-defined record, and user-defined record value.

  • The Export General Ledger Data for China: Enterprise process exports data from General Ledger for an enterprise. The XML file includes the following sections: basic general ledger information, natural account information from the chart of accounts, subsidiary items of the account, cash flow items, general ledger account balance and period amount, general ledger journals, journals related to cash flow item segment, and report set and report item information from balance sheet, income statement, cash flow statement, and statement of change in equity reports available in Oracle Hyperion.

  • The Export Payables and Receivables Data for China: Enterprise process exports data from Payables and Receivables for an enterprise. The XML file includes the following sections: document type, transaction type, payables balance detail, and receivables balance detail.

  • The Export Fixed Assets Data for China: Enterprise process exports data from Assets for an enterprise. The XML file includes the following sections: basic fixed asset information, fixed asset category setting, modification method, depreciation method, asset usage, asset card, asset card real asset information, asset card usage information, asset decrease information, asset decrease information real asset information, and asset modification information.

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:

  • Basic General Ledger information: Displays information, such as separator, account structure, cash flow item rule. The other basic information, such as journal header flexfield, corresponding records of journal header flexfield, journal line flexfield, and corresponding records of journal line flexfield are displayed as blank values.

  • Natural account information in General Ledger chart of accounts: Displays information, such as:

    • Account number and name: The chart of account natural account numbers and description under the current ledger. It also includes account numbers and descriptions of disabled accounts.

    • Account level: The hierarchy of the natural account definition.

    • Account type: The account type of each natural account defined in the General Ledger chart of account segment qualifier.

    • Debit or Credit: The balance side of each natural account defined in the General Ledger chart of account segment qualifier. For asset and expense accounts, the debit amount is displayed. For liability, ownership or stockholder's equity, and revenue accounts, the credit amount is displayed.

  • Subsidiary item information: Displays accounting-related subsidiary item information for the specified accounting year. No data is exported when there are no journals or transactions during the specified accounting year. The section includes:

    • Account number: The account number from the itemized table.

    • Subsidiary item number: The serial number of the segment. For example, when the segment name is Segment 1, it displays 1 as the subsidiary item number.

    • Subsidiary item name: The chart of account segment name for the chart of accounts. It is based on the data source. For Oracle Fusion Project Foundation, the description corresponding to the project number is displayed.

      For subledger application, one of the following records is displayed: customer record, supplier record, or employee.

  • Cash flow item information: Displays information on the cash flow items defined. It includes cash flow item number, cash flow item name and description, cash flow item source, and cash flow item attribute. The information is obtained from the Cash Flow Item Attribute Assignments tab on the Manage Enterprise Financial Data Export Options for China page.

  • General Ledger account balance and period amount information: Displays the following information from the itemized balance table:

    • Subsidiary item number: The serial number of the subsidiary segments on the Manage Enterprise Financial Data Export Options for China page.

    • Subsidiary value number: The value number depends on the subsidiary item sources and is obtained from the itemization table.

    • Account balance: The balance is obtained from the itemization table and is summarized based on the entered currency.

    • Account number: The chart of account natural numbers from the specified ledger.

    • Beginning balance side: The Chinese characters indicate debit or credit. The balance side of the account and the beginning balance is compared to assign an appropriate Chinese character to the account.

    • Ending balance side: The Chinese characters indicate debit or credit. The balance side of the account and the ending balance is compared to assign the appropriate Chinese character to the account.

    • Beginning balance: The period beginning balance of the subsidiary account in entered currency and ledger currency.

    • Ending balance: The period ending balance of the subsidiary account in entered currency and ledger currency.

    • Debit amount: The total debit amount of the subsidiary accounts within the specified period in entered currency and ledger currency.

    • Credit amount: The total credit amount of the subsidiary accounts within the specified period in entered currency and ledger currency.

  • General Ledger journals information: Displays the following information from the itemized journal table:

    • General Ledger journal date: The effective date defined for the journal.

    • Journal category number: The category defined for the journal.

    • Journal number: The journal sequence number.

    • Journal line number: The line number of each journal line.

    • Journal source: The source defined for the journal.

    • Account number: The natural account number of the journal line.

    • Currency code: The code of the entered currency.

    • Conversion rate type number: The conversion rate type defined for the journal.

    • Conversion rate: The conversion rate between entered currency and ledger currency. It is calculated as Rate = Ledger Currency/Entered Currency.

    • Debit amount: The debit amount of the account in entered currency and ledger currency.

    • Credit amount: The credit amount of the account in entered currency and ledger currency.

    • Settlement method number: The settlement method used.

    • Creator, reviewer, and poster: The name of the creator, reviewer, and poster is the person name defined by the system administrator. When no person name is assigned to the user, it displays the user name.

      The creator is the person who created the journal. The reviewer is the person who approved the journal and the poster is the person who posted the journal.

      Note

      When a journal does not need to be approved, the name of the poster is displayed.

  • Information on journals related to cash flow item segment: Displays the following information:

    • Journal number: The journal numbers based on the legal entity and journal header identifier.

    • Cash flow line number: The line number of the journal.

    • Cash flow description: The description of the journal.

    • Cash flow item: The value of the cash flow segment in the chart of accounts.

    • Journal category number: The category of the journal.

    • Currency code: The currency code is obtained from the journal header.

    • Cash flow item attribute: The information on the cash flow item attribute on the Cash Flow Item Attributes Assignment tab on the Manage Enterprise Financial Data Export Options for China page.

    • Entered amount: The entered amount of the journal line.

    • Accounted amount: The accounted amount of the journal line.

  • Report set and report item information: Displays the report set and report item information on the following reports:

    • Balance Sheet

    • Income Statement

    • Cash Flow Statement

    • Statement of Change in Equity

    Note

    These reports are exported from Oracle Hyperion.

    The report set includes report number, name, and date. It also includes enterprise name and currency unit.

    Report item information includes report item name, number, formula, and value.

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:

  • Document type: Specifies the document type number and document type. The document type is one of the following: payable note, payment note, receivable note, and receipt note.

  • Transaction type: Specifies the transaction type and transaction number based on the document type.

    • For a payable note, the transaction type is the invoice type of the Payables invoice.

    • For a payment note, the transaction type is the payment type of the Payables payment. The transaction number is the payment type indicator.

    • For a receivables note, the transaction type is the transaction type of the Receivables transaction.

    • For a receipt note, the transaction type is the receipt type of the Receivables receipt. The transaction number is cash for standard receipt type.

  • Payables account details: Specifies payables account related information, such as account payable, prepayment, and other payable details based on the supplier.

    The process only exports liability or prepaid lines that are transferred and posted to Oracle Fusion General Ledger.

    When there are multiple lines with the liability accounting class for each invoice, only the summarized amount with the same accounting date for each invoice is exported.

  • Receivables account details: Specifies receivables account related information based on the customer.

    The process only exports receivables accounting lines that are transferred and posted in General Ledger.

    It exports only receivables accounts with the receivables accounting class for each accounting line in Oracle Fusion Subledger Accounting.

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

  • Account number: The natural account number.

  • Journal created date: The General Ledger date from the journal header.

  • Accounting year: The accounting years associated with the accounting calendar of the selected ledger as specified while executing the process.

  • Accounting period number: The periods from the first period to the end period of the accounting year.

  • Journal category number: The category defined for the journal.

  • Journal number: The journal number that is derived from the journal itemization table.

  • Ledger currency: The ledger currency of the transaction.

  • Conversion rate: The currency conversion rate on the transaction. When it is the ledger currency, the value is one.

  • Balance side: The Chinese characters indicate debit or credit. The balance side of the account and the ending balance is compared to assign an appropriate Chinese character to the account.

  • Entered currency: The currency code.

  • Transaction type number: The number of the transaction type.

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:

  • Basic fixed asset information: This section provides basic information for assets that exist during the specified period and owned by the specified legal entity and ledger. The basic information includes: fixed asset account, accumulated impairment account, and accumulated depreciation account.

  • Fixed asset category setting: This section provides information for assets that exist during the specified period and owned by the specified legal entity and ledger. It includes information, such as fixed asset category code convention, fixed asset category code, and fixed asset category name.

    Determine the fixed asset category convention as the maximum size value of every category segment and use - to link these maximum size values. For example, 20-10-20 indicates the category has three segments, the maximum size value for the first segment is 20, the second is 10, and the last is 20.

  • Modification method: This section exports transaction types that had transactions during the specified period range. Only assets of the following transaction types are exported: addition, adjustment, reclass, reinstatement, transfer, unit adjustment, and reverse adjustment.

    The section includes information, such as modification method code and modification method name.

  • Fixed asset depreciation method: This section exports depreciation methods that are assigned to the assets in the selected period range. It includes information, such as depreciation method code, depreciation method name, and depreciation formula.

  • Fixed asset usage: This section only exports the usage status which is assigned to the eligible assets. It includes information, such as usage status code and usage status name.

    Oracle Fusion uses global descriptive flexfield to maintain the asset usage status code.

  • Fixed asset card: This section exports assets that exist during the specified period range. When multiple periods are specified, the asset card exports multiple times against the specified period. Fully retired assets during the specified period are not included during export.

    When an asset is reinstated during the export period, the asset card is exported for this period and the periods afterward. The following information is displayed for reinstated assets: unit, original value, accumulated depreciation value, net book value, accumulate impairment value, salvage value, and monthly depreciation amount.

    When you assign an asset to multiple balance segment values, the above mentioned information along with product capacity and life to date production is displayed in a percent based on the total unit assignment for all balance segment values of the legal entity.

  • Fixed asset card - real asset information: This section only provides information on assets that exist during the specified period range. When multiple periods are specified, the asset card exports multiple times against the specified period.

    The location information is obtained from the location field on the Asset Assignment region on the Inquire Assets page. When an asset is assigned to multiple legal entities, only the locations associated with the specified legal entity are displayed.

    When an asset is assigned to multiple asset books with the same legal entity and ledger, the asset is exported multiple times.

    The section includes information, such as fixed asset card number, accounting period, fixed asset tag number, fixed asset location, and fixed asset model.

  • Fixed asset card usage information: This section only exports the usage information for assets that are associated with the specified period range. When you specify multiple periods, the asset card exports multiple times against every period.

    The location information is obtained from the location field on the Asset Assignment region on the Inquire Assets page. When an asset is assigned to multiple legal entities, only the locations associated with the specified legal entity are displayed.

    Obtain the department information from the employee assigned to the asset and derive the human resource organization from employee record as the asset department. When the asset is assigned to multiple departments, the asset card appears repeatedly with different departments in the report.

    When an asset is assigned to multiple asset books with the same legal entity and ledger, the asset is exported multiple times.

    The section includes information, such as fixed asset card number, fixed asset tag number, accounting period, fixed asset department, and depreciation prorate.

  • Fixed asset decreasing information: This section provides asset decreasing information that occurred during the specified period range. The decreasing transaction information is extracted from the Asset Transaction Inquiry page. Only fully retirement transaction type and partial retirement transaction type are considered as decreasing transactions.

    When a retired or partially retired asset is assigned to multiple legal entities with different balance segment values, the decreasing value and quantity is calculated as follows:

    • Full retirement:

      Decreasing Quantity = Unit assigned to the Legal Entity

      Decreasing Information Value = Cost Retired * Unit Assigned to the Legal Entity/Total Unit of Asset

    • Partial retirement: For cost retirement, retired unit is not entered.

      Decreasing Quantity = Unit Assigned to the Legal Entity * Cost Retired/Current Cost

      Decreasing Information Value = Cost Retired * Unit Assigned to the Legal Entity/Total Unit of Asset

    When there are multiple partial retirement transactions during a period, the transactions are displayed repeatedly in the report.

    The section includes information, such as transaction number and date, accounting period, modification method code, fixed asset card number, fixed asset name, fixed asset number, decreased quantity, decreased original value, decreased accumulated depreciation, decreased accumulated impairment, decreased salvage value, proceeds of sale, cost of removal, and decrease reason.

  • Fixed asset decreasing information - real asset information: This section includes the following information, transaction number, fixed asset card number, fixed asset tag number, and accounting period.

  • Fixed asset modification information: This section provides the asset modification information that occurred during the specified period range. The modification transaction information is extracted from the Asset Transaction Inquiry page.

    Assets with the following transaction types are exported: addition, adjustment, reclass, reinstatement, transfer, unit adjustment, and reverse adjustment.

    When the asset was assigned to multiple legal entities, the premodification value and post-modification value must be distributed within legal entities per assignment rate.

    When multiple fields are modified in one transaction, split the transaction into multiple records (one record for one change). The transaction number is displayed as Transaction Number-1, Transaction Number-2, and so on.

    The following modification transactions are excluded from the export report: original cost, recoverable cost, prorate date, and salvage rate.

    The modification information export section includes information, such as transaction number, modification date, accounting period, fixed asset card number, fixed asset number, fixed asset name, modification method code, fixed asset tag number, pre-modification content and amount, post-modification content and amount, and modification reason.

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:

  • Electronic accounting book: Displays data related to the accounting book and is exported from the Manage Enterprise Financial Data Export Options for China page for the selected legal entity.

  • Accounting period: Displays all the periods, including both the normal and adjustment periods within the specified accounting year.

  • Journal category: Displays the journal categories that are associated with the journals during the specified accounting years. No data is exported when there is no journal associated with the current legal entity during the specified accounting year.

  • Conversion rate type: Displays the conversion rate types that are associated with the journals during the selected accounting years. No data is exported when no conversion rate type is used for the current legal entity during the specified accounting year.

  • Currency: Displays the currencies that are associated with the journals during the specified accounting years. No data is exported when there is no journal associated with the current legal entity during the specified accounting year.

  • Settlement method: Displays the settlement methods that are used during the selected accounting years. No data is exported when there is no settlement method used under the current legal entity during the specified accounting year.

    The settlement method number is extracted from the itemized records for the specified accounting year, legal entity, and ledger. When the settlement method number is obtained, the settlement method name is extracted.

  • Department records: Displays department information based on the parameter values that are passed while running the process. Information such as department number, department name, and parent department number, if any are displayed.

  • Employee records: Displays information about employees that are associated with a legal employer that is attached to the legal entity. Displays information only for those employees under the legal employers that are attached to the legal entity that is passed as a parameter while running the process. Information such as personal number, name, national identification number, date of birth, date of hire, and so on.

  • Supplier records: Displays the suppliers with actual payables transactions during the selected accounting years. No data is exported when there is no supplier under the current legal entity during the selected accounting year.

    Note

    The Export Shared Information Data for China: Enterprise process exports only the supplier type of Standard Supplier.

    The supplier number is extracted from the itemized records for the specified accounting year, legal entity, and ledger.

  • Customer records: Displays the customers with actual receivables transactions and receipts during the selected accounting years. No data is exported when there is no customer under the current legal entity during the selected accounting year.

    The customer number is extracted from the itemized records for the specified accounting year, legal entity, and ledger.

  • User-defined records: Displays the subsidiary account used during the specified accounting year. No data is exported when there is no subsidiary account used under the current legal entity during the specified accounting year.

    Data is extracted from the Subsidiary Account Mapping region on the Manage Enterprise Financial Data Export Options for China page. Only subsidiary accounts from the relevant chart of accounts and project source are exported.

  • User-defined record value: Displays the report value used during the selected accounting years. No data is exported when no report value is used under the current legal entity during the specified accounting year.

    The user-defined record value is displayed only for the subsidiary accounts from the relevant chart of accounts and project source.

    The record value number is extracted from itemized records for the specified accounting year, legal entity, and ledger. When the record value number is obtained, the required record value name and record value description are extracted.

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:

  • Operating activities

  • Investing activities

  • Financing activities

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

  • Intercompany transactions

  • Subledger transactions

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:

  • For unapplied or unidentified cash receipts, obtain the default cash flow segment from the receipt method.

  • For applied cash receipts, use the accounting rule to override the cash flow segment from the receivable account in transactions.

  • For bank charges, gain or loss, and discounted accounts, use the accounting rule to override the cash flow segment from the receivable account in transactions.

  • For miscellaneous receipts, obtain the default cash flow segment from the receivable activity account.

  • For receivable transactions, all the accounting lines must have the cash flow segment which is obtained from the definition of the transaction type by automatic accounting.

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:

  • Expenses report

  • Internet expenses

  • Evaluated receipt settlement (ERS) invoice

The following rules apply to Payables transactions:

  • For the manual invoices, the cash flow segment is indicated manually.

  • For the invoices matched purchase order (PO) and from ERS, the cash flow segment is defined in the item or purchase categories.

  • For the invoice created by Oracle Fusion Expenses, the cash flow segment is defined in the expense report items.

  • For the payment request invoice which is created by receivables refund, the cash flow segment is from the refund account.

  • For the liability account in a Payables invoice, the cash flow segment is the same as the cash flow segment of an item expense account. Other segments of the chart of accounts must follow their own accounting rules.

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:

  • Period

  • Account

  • Currency

  • Rate

  • Entered Amount

  • Accounted Amount

  • Source

  • Category

  • Journal Batch Name

  • Journal Name

  • Document Number

  • Voucher Number

  • Journal Line

  • Customer or Supplier Name

  • Receipt or Payment Number

  • Receivables Transaction Number or Payables Invoice Number

  • Intercompany Batch Number

  • Purchase Order (PO) Number

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

  • When a ledger is specified, only posted journal lines under the specified ledger are exported. When no legal entity is specified, the report extracts all of the journal lines under the selected ledger.

  • When the source is specified, the general ledger journal lines from the specified source are extracted. When no source is specified, all the general ledger journal lines are exported.

  • Only general ledger journal lines during the selected period range, including both normal period and adjustment period are extracted and exported to the report.

  • Subledger information is exported only for the following sources: payables, receivables, cost management, and intercompany. For other sources, only general ledger information is exported, subledger information is not exported.

  • For the journal lines with the source as Oracle Fusion Payables, subledger information, such as supplier name, Payables invoice number, and Payables document number is exported.

    When the event class in the subledger accounting journal entry belongs to the PAYMENTS event entity, only the supplier name and payment document number are extracted and exported to the report.

    When the event class in the subledger accounting journal entry belongs to the INVOICES event entity, only the supplier name, and invoice number are extracted and exported to the report.

    The supplier name is extracted from the party name field in the subledger accounting journal entry.

  • For the journal lines with the source as Oracle Fusion Receivables, subledger information, such as customer name, Receivables transaction number, and Receivables receipt number is exported.

    When the event class in the subledger accounting journal entry belongs to the RECEIPTS event entity, only customer name and receipt number are extracted and exported to the report.

    When the event class in the subledger accounting journal entry belongs to the TRANSACTION and ADJUSTMENT event entity, only customer name and transaction number are extracted and exported to the report.

    The customer name is extracted from the party name field in the subledger accounting journal entry.

  • For the journal lines with the source as Oracle Fusion Cost Management, the original event class of the journal line is extracted.

    When the event class in subledger accounting journal entry belongs to the RCV_ACCOUNTING_EVENTS event entity, supplier name, purchase order number, and receipt number are extracted and exported to the report.

    When the event class in subledger accounting journal entry does not belong to the RCV_ACCOUNTING_EVENTS event entity, the cost management subledger information is not exported.

  • For the journal lines with the source as Oracle Fusion Intercompany, the original intercompany batch number is extracted.

  • For secondary ledgers, the subledger information is extracted and exported only when the data conversion level is subledger. Otherwise, only general ledger information is extracted and exported. The data conversion level is defined during accounting setup.

  • For the summary report mode, when transferring subledger to general ledger, the report restores the detail level with subledger information to export on the report.

    When the subledger accounting options in the accounting setup and transfer to general ledger options in journal line type set up is summary, the subledger journal lines are summarized and transferred to general ledger.

    In such cases, one general ledger journal line may be summarized from multiple subledger journal lines. The report exports multiple lines for every subledger journal line and the amount displayed is from the corresponding subledger journal line.

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.

  • Debit: Expense.1230 100

  • Credit: Cash.0000 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:

  • Increase in amount from the first column

  • Balance at the beginning of the year from the second column

  • Balance at the end of the year from the third column

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:

  • Debit: 01.000.5010005.1001 (CFS) CNY 100

  • Credit: 01.000.2010001.1001 (CFS) CNY 100

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:

  • Debit: 01.000.2010001.1001 (CFS) CNY 100

  • Credit: 01.000.1001001.0000 (CFS) CNY 100

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.

  • Debit: 01.000.5010005.1001 (CFS) $100

  • Credit: 01.000.2010001.1001 (CFS) $100

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:

  • Debit: 01.000.Receivable.1001 (CFS) CNY 117

  • Credit: 01.000.Revenue. 1001 (CFS) CNY 100

  • Credit: 01.000.Tax.1001 (CFS) CNY 17

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

  • Debit: 01.000.Cash.0000 (CFS) CNY 117

  • Debit: 01.000.Receivable.1001 (CFS) 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.