Reporting

The reports are classified under Processes for the Financial Data Export for China and Hyperion Reporting for Cash Flow Statement.

Processes for the Financial Data Export for China

Enter transactions with these characteristics to ensure that they get the cash flow item correctly.

Business Flow Summary for Financial Data Export

This image shows the business flow summary for Financial Data Export:

Itemize Account and Journal for China

This is a prerequisite process that collects and calculates the detailed accounting transactions for the reporting period.

Follow these steps:

1. Navigate to Tools and select Scheduled Processes.
2. Collect the transactions that you want to report for the legal entity for a period.
   Note: You must run this process before you run other data export processes.

Export Shared Information Data for China: Enterprise

After you have itemized the transactions and accounts by the Itemize Account and Journal for China process, you can export the shared information data for China:

Follow these steps:

1. Navigate to Tools and select Scheduled Processes.
2. Run the Itemize Account and Journal for China’ process.
3. Run the report before the period which you selected in the Itemize Account and Journal for China.
4. Choose Department Tree and Department Tree Version that you set up previously.

   The report output must be in XML format. The XML file includes these sections: electronic accounting book, accounting period, journal category, exchange rate type, currency, settlement method, supplier record, customer record, user-defined record, and user-defined record value.

Export General Ledger Data for China: Enterprise

After you have itemized the transactions and accounts by the Itemize Account and Journal for China process, you can export the General Ledger data for China:

Follow these steps:

1. Navigate to Tools and select Scheduled Processes.
2. Run the Itemize Account and Journal for China’ process.
3. Run the report before the period which you selected in the Itemize Account and Journal for China.
4. Choose financial reports with suffix ‘rpt’ that you saved as snapshots under the path in the Financial Report Snapshot Directory for China profile option.

   The report output must be a XML format. The XML file includes these 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.

Export Fixed Assets Data for China: Enterprise

After you have itemized the transactions and accounts by the Itemize Account and Journal for China process, you can export the Export Fixed Assets Data for China report:

Follow these steps:

1. Navigate to Tools and select Scheduled Processes.

2. Choose the parameter for a legal entity in the period range.

   The report output must be a XML format. The XML file includes these 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 Payables and Receivables Data for China: Enterprise

You can export the Export Payables and Receivables Data for China report:

Follow these steps:

1. Navigate to Tools and select Scheduled Processes.
2. Run the Itemize Account and Journal for China’ process.
3. Run the report before the period which you selected in the Itemize Account and Journal for China.

4. Choose the parameter for a legal entity in the period range.

   The report output must be a XML format. The XML file includes these sections: document type, transaction type, payables balance detail, and receivables balance detail.

Business Flow Summary for Cash Flow Statement

This image shows the business flow summary for cash flow statements:

Hyperion Financial Reporting

You can do these tasks:

1. Define the Cash Flow Statement in the Hyperion Financial Report Studio.
2. Insert a grid and assign the rows as Cash Flow Segment you defined in the Chart of Account.
3. Define each cash flow statement lines and assign the related cash flow segment for each line to get the cash flow amount.
4. In China, you can input the Chinese lines and define the Chinese reports.
5. Save the report or save the report as snapshot in a specific location for the financial data export.
6. Run the report as HTML or PDF format to review the report results.

For example, run the General Ledger Journal and Subledger Transaction Mapping report to check if all the cash flow segment booked correctly. 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. The output of the report is in Excel format. It only supports the four subledger sources: Receivables, Payables, Cost Management and Intercompany.