How You Export Enterprise Financial Data for China

You can export financial data from Oracle Fusion Applications into a national standard format developed by the National Audit Office of the People's Republic of China.

The format is based on the Financial Information Technology - Data Interface of Accounting Software (GB/T 24589-2010) standard, and approved by the Standardization Administration of the People's Republic of China.

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

  • Oracle Fusion Assets

Settings That Affect Enterprise Financial Data Export for China

Before exporting the financial data, complete these setup tasks:

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

  • Export general ledger cash journals and general ledger accounts. Use the Local Use segment qualifier available in Oracle Fusion General Ledger to identify the cash flow segment. Assign one segment in the chart of accounts as Local Use.

  • Specify the cash flow statement rows to use in the cash flow statement, including both the main statement and the supplementary schedule. These attributes are required with other cash flow item attributes:

    • Item source

      Identifies 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. These 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

    • Project number

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

  • Specify the descriptive flexfields and attributes to store additional information.

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

How Financial Data Is Exported

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

Scheduled Process

Purpose

XML Contents

Export Shared Information Data for China: Enterprise process

Exports shared information data for an enterprise

  • Electronic accounting book
  • Accounting period

  • Journal category

  • Exchange rate type

  • Currency

  • Settlement method

  • Supplier record

  • Customer record

  • User-defined record

  • User-defined record value

Export General Ledger Data for China: Enterprise process

Exports data from General Ledger for an enterprise

  • Basic general ledger information and 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 and journals related to cash flow item segment

  • 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 Payables and Receivables Data for China: Enterprise process

Exports data from Payables and Receivables for an enterprise

  • Document type

  • Transaction type

  • Payables balance detail

  • Receivables balance detail

Export Fixed Assets Data for China: Enterprise process

Exports data from Assets for an enterprise

  • Basic fixed asset information

  • Fixed asset category setting

  • Modification method

  • Depreciation method

  • Asset usage, asset card, asset card real asset information, and asset card usage information

  • Asset decrease information and asset decrease information real asset information

  • Asset modification information