Oracle® Fusion
Applications
Financials Implementation Guide 11g Release 5 (11.1.5) Part Number E20375-06 |
Contents |
Contact Us |
Previous |
Next |
This chapter contains the following:
Managing Enterprise Financial Data Export Options for China: Points to Consider
Defining the Structure for Natural Accounts: Example
FAQs for Oracle Fusion Financials for Asia/Pacific
The enterprise financial data export for China functionality provides processes for exporting financial data from Oracle Fusion General Ledger, Oracle Fusion Payables, 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.
To be able to export data, provide the following:
Financial Information
Accounting Book Information
Depreciation Method Formula
Provide the above information through the Manage Enterprise Financial Data Export Options for China page under Navigator - Setup and Maintenance.
Define the financial information options for all chart of accounts that are associated with the data access set for a specific data role. Only chart of accounts that have associated financial information are listed on the Manage Enterprise Financial Data Export Options for China page. You can edit or delete the financial information options for a particular chart of accounts.
To provide financial information for a chart of account, provide the following information:
Accounting Information
Flexfield Assignment
Cash Flow Item Attribute Assignment
Note
To provide financial information for a chart of account, click the Add Row icon on the Manage Enterprise Financial Data Export Options for China page to navigate to the Create Financial Information Options for China page.
Define the structure for natural accounts. The natural account structure is a key flexfield to define the structure for the natural account in the chart of accounts.
The account structure flexfield specifies the structure code for the natural account structure. It indicates the hierarchy of natural account against the local statutory requirement. For example, local government requires that the natural account must have eight digits, the first four digits for the first level, the next two digits for the second level, and the last two digits for the third level. The structure in this case is 4-2-2.
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: customer, supplier, and employee supplier information, and project number. You can specify about 30 subsidiary segments.
Specify descriptive flexfields and attributes that are used to store additional information. By default, a descriptive flexfield is defined for intercompany transactions. The flexfield stores the settlement method that is used for intercompany transactions.
Specify the cash flow statement rows that are used in the cash flow statement and 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.
The cash flow item length is the length of the cash flow statement item. For example, when the cash flow item is 1000, the cash flow item length is 4. The length of all the cash flow statement items must be the same.
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.
You can define accounting book information for each legal entity associated with you data access set.
Define the text formulas for the depreciation methods in Oracle Fusion Assets. Information about the depreciation method is used by the Export Fixed Assets Data for China: Enterprise process. For example, the depreciation method formula for the straight line method is Depreciation Amount = Recoverable Amount/Life.
Define the structure for natural accounts. The natural account structure is a key flexfield to define the structure for the natural account in the chart of accounts.
The account structure flexfield specifies the structure code for the natural account structure. It indicates the hierarchy of natural account against the local statutory requirement. For example, local government requires that the natural account must have eight digits, the first four digits for the first level, the next two digits for the second level, and the last two digits for the third level. The structure in this case is 4-2-2.
Define the subsidiary account sources based on the chart of accounts. There are three types of subsidiary account sources available:
Chart of account segments: Segments in chart of accounts except for natural account segment and company segment.
Third party and employee supplier information: Customers, suppliers, and employees can be taken as subsidiary account.
Project: A seeded supporting reference populates the project number to be a subsidiary account.
You can specify about 30 subsidiary segments. Subsidiary segment is mapped to subsidiary account sequentially when saving.
For example, consider defining the following subsidiary segment mapping as follows:
Segment 1: Chart of Account Department
Segment 2: Subledger Accounting Customer
Segment 3: Subledger Accounting Supplier
You can delete any segment and add a new one. Consider removing segment 2 and adding a new segment as follows:
Segment 1: Chart of Account Department
Segment 3: Subledger Accounting Supplier
Segment 4: Project - Project Number
Save the mapping. The final result is:
Segment 1: Chart of Account Department
Segment 2: Subledger Accounting Supplier
Segment 3: Project - Project Number
Use the Cash Flow Item Attribute Assignments tab on the Create Financial Information Options for China page to assign the cash flow item attributes, such as cash flow item length, cash flow item, item source, and item attribute.
After executing the Itemize Account and Journal for China process, you can append additional subsidiary account mapping information. Removing the existing mapping information will result in some unexpected errors when you execute the program again.
Use the Depreciation Method Formula tab on the Manage Enterprise Financial Data Export Options for China page to specify the text formulas for the depreciation methods defined in Oracle Fusion Assets.
Use the Depreciation Method Formula field to specify the formula in simple text. The Depreciation Method field lists all the depreciation methods defined in Assets.
For example, in the Depreciation Method Formula field, for the straight line depreciation method, specify the formula: Depreciation Method = Recoverable Amount/Life.
The depreciation method formula defined through the Manage Enterprise Financial Data Export Options for China page is used only for the financial data export.
It does not affect the behavior of the depreciation method in Oracle Fusion Assets.
The description on the Cash Flow Item Attribute Assignments tab on the Manage Enterprise Financial Data Export Options for China page must be the same as the report item defined in the cash flow statement.
The cash flow item on the Cash Flow Item Attribute Assignments tab on the Manage Enterprise Financial Data Export Options for China page must correspond to both the report item number in the cash flow statement and the cash flow items in the cash flow segment of chart of accounts.