The National Audit Office of the People's Republic of China (CNAO) has released a new accounting auditing filing standard (GB/T 24589-2010 Financial Information Technology - Data Interface of Accounting Software). Oracle is one of the main contributors involved in the standard definition. This new standard mandates the filing format, expands the scope of filing information required, and requires additional organizations to file their accounting information.
State-owned enterprises and joint ventures in China are required to report information to CNAO via the standard for banking (GB/T 24589.1-2010). The key process is to generate compliant XML documentation that meets the CNAO standards.
The Solution for China Accounting Software Data Interface Standard, referred to as Solution in this section, allows you to export data from the Oracle E-Business Suite to meet the requirements of the China National Auditing Office Standard. The solution enhances the capabilities of Oracle E-Business Suite, for China, by generating files with the requested formats. The data exported from the Oracle E-Business Suite is based on legal entity and not ledgers. You can define the reports by using the existing Financial Statement Generator and XML Publisher. You can also generate the reports with different outputs by modifying the XML Publisher templates. The Solution provides the cash flow statement function, which covers cash related flows of general ledger and subledgers. You can define the reports by using the existing Financial Statement Generator and XML Publisher. You can also generate the reports with different outputs by modifying the XML Publisher templates.
This section introduces you to financial data export and the cash flow statement.
Financial data export includes the following data export and financial report exports.
China General Ledger Data Export (Enterprise)
China Shared Information Data Export (Enterprise)
China Receivables and Payables Data Export (Enterprise)
China Fixed Assets Data Report (Enterprise)
You can use the Financial Statement Generator in the Oracle E-Business Suite to define and design reports and statements, and export financial data.
The cash flow statement reflects the sources and uses of money (in hard cash) in an accounting period for an enterprise. 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 contains two parts: a main statement and a supplementary statement respectively.
The Solution allows you to define and export the Cash Flow Statement from Oracle E-Business Suite. It covers the related cash flow businesses, including general ledger and subledgers.
This section provides detailed instructions on how to set up the banking solution. You can define the categories and output formats for the financial data and cash flow items to suit your enterprise's needs.
The following setup steps must be completed before setting up the Solution. Refer to the corresponding product user or implementation guides for detailed instructions.
See: General Ledger Setup, Oracle General Ledger Implementation Guide.
See: Define organizations (single organization or multiple organizations) in Oracle HRMS.
See: Payrolls, Oracle HRMS Payroll Processing Management Guide.
See: Accounting Methods Builder (AMB), Oracle Subledger Accounting Implementation Guide.
See: Payables Setup, Oracle Payables Implementation Guide.
See: Entering Supplier Information, Oracle iSupplier Portal Implementation Guide.
See: Setting Up, Oracle Receivables Implementation Guide.
See: Asset Setup, Oracle Assets User Guide.
The following table lists the setup steps to implement the Enterprise Solution for China Accounting Software Data Interface Standard. Each required setup step must be completed before you implement the solution.
| Step Number | Step |
|---|---|
| Step 1 | Define and Set Up Flexfield |
| Step 2 | Define Cash Flow Items |
| Step 3 | Define Responsibility and Setup Profile |
| Step 4 | Set Up System Options |
| Step 5 | Set Up Cash-Related Options |
| Step 6 | Set Up Cash Flow Statement Assignments |
| Step 7 | Set Up Journal Category |
| Step 8 | Define Flexfield Assignments |
| Step 9 | Define Cash Flow Item Mapping |
| Step 10 | Define FSG Reports |
All setups for Cash Flow Statement should also be completed for Financial Data Export, along with the following additional setups.
| Step Number | Step |
|---|---|
| Step 1 | Define and Set Up Flexfield |
| Step 2 | Set Up Subsidiary Account Sources |
| Step 8 | Define Flexfield Assignments |
| Step 9 | Define FSG Reports |
| Step 10 | Define Depreciation Method Assignments |
If indicated, repeat the step for each ledger, legal entity, and balance segments.
You must define and set up the key flexfield and descriptive flexfield. You must define the flexfield structure for the key flexfield, which is set up once. .
For Chinese accounting, you must define the key flexfields listed in the following table. These key flexfield definitions are only required for Financial Data Export.
| Application | Title Value Set | Segment | Digits |
|---|---|---|---|
| Asia/Pacific Localizations | Account Structure | Level 1 | 2 Digits |
| Asia/Pacific Localizations | Account Structure | Level 2 | 2 Digits |
| Asia/Pacific Localizations | Account Structure | Level 3 | 2 Digits |
To define the key asset flexfield:
From the System Administrator responsibility, navigate to the Key Flexfield Segments window.
In the Application field, select Assets (Asset Key Flexfield).
Select an existing structure or define a new structure.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any three segments to define Asset Usages and Asset Unit of Measure.
Save your work.
Freeze the flexfield and compile.
To define the account structure:
From the System Administrator responsibility, navigate to the Key Flexfield Segments window.
In the Application field, select Asia/Pacific Localizations (Account Structure).
Select an existing structure or define a new structure.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any three segments to define levels of account structure.
Tip: You should define account structure depending on your organization's requirements and you must enable at least one segment for the account structure key flexfield.
Save your work.
Freeze the flexfield and compile.
See: Key Flexfields, Oracle Applications Flexfields Guide.
See: Additional Terms and Concepts for Key Flexfields, Oracle Applications Flexfields Guide.
See: Planning Your Key Flexfield, Oracle Applications Flexfields Guide.
Define the descriptive flexfield to enter information that cannot be entered in the standard forms. A descriptive flexfield may have a context-sensitive segment. For China, you must define the descriptive flexfields listed in the following table.
| Application | Title | Segment | Value Set |
|---|---|---|---|
| Application Object Library | Flexfield segment value | Account Level | 2 Digits |
| Application Object Library | Flexfield segment value | Balance Side | JA_CN_DEBIT_CREDIT |
| Payables | Payment Information | Remittance Bill Number | User must create manually |
| Receivables | Receipt Information | Remittance Bill Number | User must create manually |
| General Ledger | Journal Categories | Cash Related | YES_NO |
| General Ledger | Enter journals: journals | Settlement Method | JA_CN_SETTLEMENT_METHOD |
| Financials Common Modules | Intercompany: transaction headers | Settlement Method | JA_CN_SETTLEMENT_METHOD |
| Financials Common Modules | Intercompany: transaction distributions | Cash Flow Item | JA_CN_CASHFLOW_ITEMS |
Tip: After you define the descriptive flexfields, you must complete the natural accounts including account level and balance side information.
To define the Application Object Library Flexfield Segment Value descriptive flexfield:
Additional Information: This definition is only required for Financial Data Export.
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select Application Object Library (Flexfield Segment Value).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any two attributes to define Balance Side and Account Level.
Save your work.
Freeze the flexfield and compile.
To define the Payables Payment Information descriptive flexfield:
Additional Information: This definition is only required for Financial Data Export.
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select Payables (Payment Information).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Remittance Bill Number.
Save your work.
Freeze the flexfield and compile
To define the Receivables Receipt Information descriptive flexfield:
Additional Information: This definition is only required for Financial Data Export.
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select Receivables (Receipt Information).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Remittance Bill Number.
Save your work.
Freeze the flexfield and compile.
To define the General Ledger Journal Categories descriptive flexfield:
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select General Ledger (Journal Categories).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Cash Related.
Save your work.
Freeze the flexfield and compile.
To define the General Ledger Enter Journals: Journals descriptive flexfield:
Additional Information: This definition is only required for Financial Data Export.
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select General Ledger (Enter Journals: Journals).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Settlement Method.
Save your work.
Freeze the flexfield and compile.
To define the Financials Common Modules Intercompany Transaction Headers descriptive flexfield:
Additional Information: This definition is only required for Financial Data Export.
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select Financials Common Modules (Intercompany Transaction Headers) .
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Settlement Method.
Save your work.
Freeze the flexfield and compile.
To define the Financials Common Modules Intercompany Transaction Distributions descriptive flexfield:
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select Financials Common Modules (Intercompany Transaction Distributions).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Cash Flow Item.
Save your work.
Freeze the flexfield and compile.
See: Descriptive Flexfields, Oracle Applications Flexfields Guide.
See: Planning Your Descriptive Flexfield, Oracle Applications Flexfields Guide.
See: Descriptive Flexfield Segments Window, Oracle Applications Flexfields Guide.
See: Defining Segment Values, Oracle Applications Flexfields Guide.
See: Defining Journal Categories, Oracle General Ledger Implementation Guide.
Cash flow item is the smallest unit used to calculate cash flow activities. Define the cash flow item for the following reasons:
Divide each cash flow transaction into different category
Map the cash flow item to the payables invoice category, receivables transaction type, receivables activity, the sources that you want the cash flow to track
Assign the cash flow item to the corresponding cash flow statement lines
Enter the cash flow item in the predefined descriptive flexfield when you enter cash related general ledger journals and intercompany transactions
Note: Do not define the cash flow item hierarchy. The application only supports detailed cash flow items. You can define the subtotal and detailed relationship between different lines when defining the cash flow statement assignments. You can also use the seeded value set: JA_CN_CASHFLOW_ITEMS.
To define Cash Flow Items value set:
From System Administrator responsibility, navigate to the Segment Values window.
In the name field, select JA_CN_CASHFLOW_ITEMS. You can also define a new value set for Cash Flow Items by navigating to the Value Sets window.
Add new values.
Save your work.
See: Defining Segment Values, Oracle Applications Flexfields Guide.
You can use the predefined responsibility China Accounting Data Interface (Enterprise), or you can define a new responsibility as described below.
When defining a responsibility, assign the following elements to the responsibility:
Data group
Request group
Menu (the predefined value is JA_CN_GL_SUPERUSER)
Function and menu exclusion
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
As a system administrator, you can control Oracle Applications by creating profile options with different values. You define profile options at the following levels: site, application, responsibility, user, server and organization.
The following table describes the profile options that must be set for China localizations:
| Profile Option Name | Value | Level |
|---|---|---|
| JG: Application | General Ledger | Responsibility |
| JG: Product | Asia/Pacific Localizations | Site |
| JG: Territory | China | Site |
| JA: CN Legal Entity | Legal Entity you defined | Responsibility |
| GL: Data Access Set | Data Access Set you defined | Responsibility |
| MO: Default Operating Unit | Default Operating Unit you defined | Responsibility |
| MO: Operating Unit | Single Operating Unit you defined | Responsibility |
| MO: Security Profile | Multiple Operating Units you defined | Responsibility |
Additional Information: For the setup of operating unit profiles, you can set up either MO: Operating Unit or MO: Security Profile based on your business requirement.
To define profile:
From System Administrator responsibility, navigate to the Find System Profile Values window.
Choose the responsibility China Accounting Data Interface (Enterprise) and enter profile JG: %.
Click Find. System displays the System Profile Values window. In the System Profile Values window, you can assign proper values shown in the table above to the corresponding profiles.
Repeat the steps 2 and 3 to complete the setup of other profiles shown in the table above.
Save your work.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
You must define the basic information for your legal entity using the System Options window. Before you set up the system options, you must define the following:
Balance Segment
Responsibility
Profile
Use the System Options window to enter information about the accounting book and the rounding rule.
Note: A corresponding balance segment related to the current responsibility is displayed in the Balance Segment field. The accounting book information corresponding to the current balance segment is displayed in the Accounting Book Information block.
Repeat this step for each balance segment.
To define System Options:
From the China Accounting Data Interface (Banking) responsibility, navigate to the System Options window.
Enter supplementary information for the Accounting Book and choose the proper rounding rule for Miscellaneous Options.
Ledger:The corresponding ledger of the current responsibility. Field cannot be updated once entered.
Legal Entity: The corresponding legal entity of the current responsibility. Field cannot be updated once entered.
Balance Segment:: The corresponding balance segment of the current responsibility. Field cannot be updated once entered.
Other fields: Organization ID, Enterprise Quality, Enterprise Industry, Standard Version, and Account Structure are all mandatory fields that require manual entry.
Save your work.
See: Defining Ledgers, Oracle General Ledger Implementation Guide.
See: Designing Your Accounting Flexfield, Oracle General Ledger Implementation Guide.
See: Defining Legal Entities Using the Legal Entity Configurator, Oracle Financials Implementation Guide.
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
You must define the accounting structure and subsidiary account source based on your chart of accounts using the Subsidiary Account Sources window.
In the Subsidiary Account Mapping region, you can assign the detailed context information to a maximum of thirty separate subsidiary accounts.
Note: Setting up subsidiary account sources is only required for Financial Data Export. You must define the account structure before completing this set up.
To define Subsidiary Account Sources:
From the China Accounting Data Interface (Enterprise) responsibility, navigate to the Subsidiary Account Sources window.
Enter the account structure.
Account Structure Code: Indicate which key flexfield segment code is used for the account structure definition.
Structure: Indicate the natural account structure per account hierarchy.
Define the subsidiary account mapping.
Subsidiary Segment: Indicate which subsidiary segment is used. This is a view-only field with serially-numbered segments.
Sources: Indicate which subsidiary segment source will be itemized, including the three values: COA, SLA and Project Module.
COA source: All segments defined in the current Chart of Accounts except natural account are available.
SLA source: Customer, Supplier and Employee Supplier are available.
Project Module source: Only the seeded supporting reference code PROJECT_NUMBER is available.
Context: List of values from which you can select detailed context based on the sources. Context can only be selected once before being removed from the list of values.
Save your work.
Use the Cash Related Options window to define common cash related setup, which includes accounting classes, cash accounts, and the cash flow item value set based on the chart of accounts. Before you set up the cash related accounts, you must define the following:
Chart of accounts
Legal entity
Responsibility
Profile
Cash flow item value set
Repeat this step for each legal entity.
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
See: Define Cash Flow Items..
To define Cash Related Options:
From the China Account Data Interface (Enterprise) responsibility, navigate to the Cash Related Options window.
In the Accounting Class tab, define Accounting Classes.
Accounting classes are used to identify accounting lines with cash related accounting classes for subledger journals.
The Cash Flow Statement Program - Data Collection program collects the cash related amount from general ledger, advanced global intercompany, and subledger.. If the accounting class of subledger journals is not specified as cash related, the Cash Flow Statement Program - Data Collection program will not collect the journals.
Note: There is a seeded accounting class named Cash.
Define cash accounts.
Define cash accounts to identify the cash accounting line in a cash related transaction. After defining the cash related accounts, the Cash Flow Statement - GL Journal Validation and Cash Flow Statement - Intercompany Transaction Validation programs validate the mapping relation to ensure that the cash related journal lines correspond to the relevant cash flow items. The Cash Flow Statement – Data Collection program identifies cash related accounting lines according to cash accounts.
Note: The Cash Flow Statement - GL Journal Validation program checks cash related account lines for journals entered manually in general ledger. This program also calculates the amount upon finding the related cash accounts.
Specify Cash Flow Item Value Set
Assign the cash flow item value set as values of cash flow items. You can define many cash flow item value sets for any kind of business. However, you can only select one cash flow item value set for one chart of account. The global flexfield in journal lines and descriptive flexfield in the intercompany transaction lines use the cash flow items set up in this window, which is also used by the Cash Flow Item Mapping window.
Note: You cannot change the cash flow item value set once you save it.
Save your work.
Use the Cash Flow Statement Assignments window to assign cash flow items to related rows of the cash flow statement and define the cash flow item source and attribute for each row of the cash flow statement. Cash flow statement assignments are set up based on the chart of accounts. Before you set up the cash flow statement assignments, you must define the following:
Chart of Accounts
Cash Flow Statement
Cash Flow Items
To define Cash Flow Statement Assignments:
From the China Accounting Data Interface (Enterprise) responsibility, navigate to the Cash Flow Statements window.
Row Set: Choose the row set of the cash flow statement you want to set up.
Cash Flow Item Rule: View only field which indicates the cash flow item rule structure.
Define Cash Flow Item Assignments.
Line: Choose the row for which you will assign cash flow items.
Line Item: The row description of the cash flow statement.
Cash Flow Item: Choose the cash flow item to assign to the row of cash flow statement.
Description: A view-only field which describes the cash flow item.
Define the source and attribute of the cash flow items.
Line: Choose the row for which you will define the cash flow item source and attribute.
Line Item: A view-only field which is the row description of the cash flow statement.
Item Source: Select the item source for each row: Main Statement or Supplementary Schedule.
Item Attribute: Select the item attribute for each row: Inflow, Outflow, or Others.
Save your work.
Set related journal categories as cash flow related.
To define Journal Category as Cash Related:
From the China Accounting Data Interface (Enterprise) responsibility, navigate to the Journal Categories window.
Select journal categories you want to set as cash related and set up them in the corresponding descriptive flexfields.
Context: Select the context you defined to indicate which journal category is cash related.
Cash Related: Set the value to Yes if the journal category is cash related.
Save your work.
You must define the prescribed descriptive and key flexfields and the flexfield assignments to specify usages of the descriptive and key flexfields. Information is obtained and processed from the specified location by referencing the flexfield assignments.
Before defining the flexfield assignments, you must define descriptive flexfields for flexfield segment values, payment information, receipt information, GL journals, journal category and intercompany transaction, key flexfields for asset key flexfield.
To define Flexfield Assignments:
From the China Accounting Data Interface (Enterprise), navigate to the Flexfield Assignments window.
Define context and column usages of flexfields. Flexfield assignments for balance side, account level, remittance bill number, asset usage, asset unit of measure and settlement are only required for Financial Data Export.
Select the context and attribute columns for balance side and account level.
Select the context and attribute columns for remittance bill number, which would be entered on payment header and receipt header.
Select the context and segment columns for asset usages and asset unit of measure.
Select the context and attribute columns for settlement method, which would be entered on journal header and intercompany transaction header.
Select the context and attribute column for cash flow item, which would be entered in intercompany transaction distributions.
Select the context and attribute column for journal categories.
Save your work.
See: Descriptive Flexfield Concepts, Oracle Applications Flexfields Guide.
See: Descriptive Flexfield Segments Window, Oracle Applications Flexfields Guide.
Tip: Skip this step if you are not using Oracle subledgers.
Use the Cash Flow Items Mapping window to map any supporting reference values to cash flow items for the cash flow statement. Using the mapping information, the Cash Flow Statement Program - Data Collection categorizes the different types of cash flow by detailed cash flow items in subledger.
Before you map the cash flow items, you must define the following:
Subledger accounting methods (optional)
Supporting reference (required)
Cash flow item value set (required)
Value set invoice category for descriptive flexfield on invoice header or distributions (optional)
Item category: cash flow category for inventory items to mark cash flow messages for Evaluated Receipt Settlement [ERS] (optional)
Note: Value set of invoice category is predefined as JA_CN_AP_INV_CATEGORY.
Note: Evaluated Receipt Settlement (ERS) or Payment on Receipt refers to automatic payment to the suppliers on delivery of goods. The invoices are automatically created in purchases and transferred to payables for payment.
To help users quickly implement and export the cash flow statement report, there is a seeded subledger accounting method: China Account Accrual, which supports the following supporting references that are assigned to the Cash Related Journal Lines for subledger accounting:
Check ID - Must be assigned to every cash related journal line type in the Journal Lines Definition window.
Cash Related SR - For Payables, Payable Customer Source is seeded. For Receivables, Transaction Type, Receipt Application Status, Receivable Activities, and Distribution Source Type are seeded.
You can create new supporting references if the seeded supporting references do not support your cash flow business. To do this, you can copy an existing subledger accounting method for update or create a new subledger accounting method, and complete the related setup. When you assign a supporting reference, the following rules apply:
The supporting reference is only assigned to journal line types that are cash offset lines.
Assign the Check ID supporting reference and cash related supporting references to journal line types, except liability lines that match invoices to which supporting references cannot be assigned.
Repeat this step for each subledger accounting method.
The following table details the seeded cash related supporting references.
| Application | Event Class | Journal Line Type | Supporting Reference Name |
|---|---|---|---|
| Payables | Credit Memos | liability, basic | Payables Custom Source |
| Payables | Credit Memos | Liability with Automatic Offsets Balancing Segment | Payables Custom Source |
| Payables | Credit Memos | Liability with Automatic Offsets Account Segment | Payables Custom Source |
| Payables | Debit Memos | Liability, Basic | Payables Custom Source |
| Payables | Debit Memos | Liability with Automatic Offsets Balancing Segment | Payables Custom Source |
| Payables | Debit Memos | Liability with Automatic Offsets Account Segment | Payables Custom Source |
| Payables | Invoices | Liability, Basic | Payables Custom Source |
| Payables | Invoices | Liability with Automatic Offsets Balancing Segment | Payables Custom Source |
| Payables | Invoices | Liability with Automatic Offsets Account Segment | Payables Custom Source |
| Payables | Prepayments | Liability, Basic | Payables Custom Source |
| Payables | Prepayments | Liability with Automatic Offsets Balancing Segment | Payables Custom Source |
| Payables | Prepayments | Liability with Automatic Offsets Account Segment | Payables Custom Source |
| Receivables | Receipt | Receipt Bank Charges | Distribution Source Type |
| Receivables | Receipt | Receipt Unidentified Cash | Distribution Source Type |
| Receivables | Receipt | Receipt On Account Application | Distribution Source Type |
| Receivables | Receipt | Receipt Unapplied Cash | Receipt Application Status |
| Receivables | Receipt | Unapplied Cash | Receipt Application Status |
| Receivables | Receipt | Receipt Default Application | Transaction Type |
| Receivables | Receipt | Receipt Refund Application | Receivable Activity |
| Receivables | Receipt | Receipt Write-Off Application | Receivable Activity |
| Receivables | Miscellaneous Receipt | Miscellaneous Receipt Miscellaneous Cash | Miscellaneous Cash Activity |
You can define Cash Flow Item Mapping records by operating unit or not associated with any operating unit.
If you need to cancel all Cash Flow Item Mapping records for some Supporting Reference, you enter the End Date in the Effective Date column.
If you only need to cancel one record in the Cash Flow Item Mapping line, you can enter “End Date” in the corresponding line.
To define Cash Flow Item Mapping:
From the China Accounting Data Interface (Enterprise), navigate to the Cash Flow Item Mapping window.
Application: Applications from Subledger will be listed. Currently, only support cash flow activities from Payables and Receivables are in Subledger.
Supporting Reference: All Supporting References defined for the Application are available. For Receivables, you can predefine supporting references by themselves or select the ones seeded in the system, such as Transaction Type, Receivable Activity, , and others. For Payables, you can predefine supporting references by themselves or select Payables Custom Sources seeded in the system.
Operating Unit: All operating units belonging to ledgers in current data access set are available.
Cash Flow Item: Cash flow items defined in cash flow item value set, which is assigned in Cash Related Options.
Define cash flow item mapping for payables.
Cash Flow Value From: You can enter values from the supporting reference Payable Custom Source.
Define cash flow item mapping for receivables.
Define cash flow item mapping rules for supporting reference Transaction Type.
Define cash flow item mapping rules for supporting reference Distribution Source Type.
Define cash flow item mapping rules for supporting reference Receipt Application Status.
Define cash flow item mapping rules for supporting reference Receivable Activity.
Save your work.
Repeat this step for each chart of accounts.
You must define the exported financial statements by using the financial statement generator (FSG), including the following FSG reports.
Cash Flow Statement Report
Balance Sheet Report
Profit Statement Report
Statement of Changes In Owners' Equity Report
For cash flow statement, you must assign the cash flow items for the corresponding lines in the Cash Flow Statement Assignments window to define the statement templates, accounting assignments, and calculate the formulas in the financial statement generator. The other three FSG reports are only required for Financial Data Export.
See: Overview of the Financial Statement Generator, Oracle General Ledger User's Guide.
To define Cash Flow Statement:
Define the Row Set. From the China Accounting Data Interface (Enterprise) responsibility, navigate to the Row Set window.
Define the name and description for row set.
Define Rows
Display Zero option should be selected for each row.
At least one row is assigned to an account.
Save your work.
Define Column Set. Navigate to the Column Set window.
Define the name and description for column set.
Define columns. Display Zero option should be selected for each column.
Save your work.
Define Report. Navigate to the Report window.
Choose the row set and the column set you have defined for cash flow statement.
Repeat above steps for other three FSG reports if need. Save your work.
Note: When defining the account assignment (or calculation formula) and cash flow statement assignment at the same time, for one of the rows in the cash flow statement, the priority of account assignment (or calculation formula) takes priority over the cash flow statement assignment. When the account assignment (or calculation formula) is not defined, the application processes the cash flow item based on the cash flow statement assignment.
You must specify depreciation methods using the Depreciation Method Assignments window. The setup of depreciation method assignments is only required for Financial Data Export.
To define depreciation method assignments:
From China Account Data Interface (Enterprise) responsibility, navigate to the Depreciation Method Assignments window.
Define Depreciation Methods. Depreciation Methods are defined based on the legal entity.
Legal Entity: View-only field, which is derived from profile JA: CN Legal Entity.
Method: Choose depreciation methods from the list of values, which are defined in the Depreciation Method Window in Fixed Assets.
Description: The description of depreciation method.
Depreciation Formula: Enter depreciation formula of the depreciation method based on your business requirement, no specified format is required.
Effective Dates From/To: Enter effective date duration for the depreciation method.
Save your work.
This section describes the cash flow statement, the daily transaction process, and the steps to generate the Cash Flow Statement.
The cash flow statement is the financial report required by the Ministry of Finance, China. The cash flow statement describes the cash inflow and outflow of an enterprise.
The cash flow statement provides the following information for a specific period:
Financial status of the enterprise
Influence of operating activities, investing activities and financing activities on cash and cash equivalents
Increase in cash and cash equivalents
The cash flow statement 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.
There is a seeded XML Publisher template for the cash flow statement, which you can customize according to your requirements.
Note: Ensure that you define the XML Publisher templates in Chinese to export the statement. However, you can define cash flow statements in any language.
You must mark cash flow items for each daily transaction before generating the cash flow statement.
When entering journals in general ledger, choose the cash flow item in the journal line descriptive flexfields if the journal line account is cash related. On defining the cash related account, run the Cash Flow Statement program - GL Journal validation program before posting the journal to validate that the journal lines accounts are cash related and correspond to the relevant cash flow items, and to prevent you from choosing cash flow items for non-cash related journal lines.
You can transfer intercompany transactions to the general ledger or create invoices in subledgers. When entering transactions in AGIS, select the cash flow item in the descriptive flexfields of the distribution line, if the distribution line account is cash related. Do not enter the cash flow items in the descriptive flexfields if transactions must be associated with invoices. The Cash Flow Statement - Collection Program collects the cash related transactions from subledgers. On defining the cash related account, run the Cash Flow Statement program - Intercompany Transaction validation program to validate that the transaction lines accounts are cash related and correspond to the relevant cash flow items, and to prevent you from choosing cash flow items for non-cash related journal lines.
Note: Run the Cash Flow Statement program - Intercompany Transaction Validation program before transferring the transactions to general ledger. You can enter the cash flow items in the journal lines after transferring the transactions to general ledger. You cannot import transactions to general ledger in summary.
The Solution collects subledger cash related activities, that depend on the supporting reference values from subledger journal entries tables. There are seeded subledger accounting methods that the Solution supports when creating the subsequent supporting reference on related journal entries. Therefore, there is no requirement to add cash flow items manually on the subledger transactions window since the mapping relations between supporting reference values and the cash flow items are defined. However, you must know how to create cash related transactions of subledger journal entries and ensure all supporting references are added to subledger journal lines and mapped to related cash flow items. Otherwise, the Cash Flow Statement - Collection program miscalculates the cash flow amount.
Note: After creating subledger journal entries, you cannot add or modify the supporting references. Therefore, ensure that the supporting references are created and assigned to the subledger journal line type.
Before you generate the cash flow statement, you must define the following:
Cash flow items
Cash related options
Cash flow item mappings
Cash flow statement report
Cash flow statement assignments
Completed daily transactions
You can generate cash flow statements using the following concurrent programs:
Cash Flow Statement Program - GL Journal Validation: This program validates cash related journals. Run this program before posting a journal.
Cash Flow Statement Program - Intercompany Transaction Validation: This program validates intercompany transactions to ensure that all cash related journals are marked as cash flow item and display the exception in the output file.
Cash Flow Statement Program - Data Collection: This program gathers the cash related transactions from general ledger, AGIS, and subledgers. After running the program, the application stores cash related transactions and original transaction information by cash flow items and the cash flow statement program - Generate Statement program generates the report based on the data table.
Cash Flow Statement Program - Generation: This program generates the main and supplementary statements of the cash flow statement, exports the data to a text file, and saves the file in the specified directory on the server.
Due to complex calculations in the supplementary statement, you must define three columns when using the predefined XML publisher template. The amount in the second column is YTD-Actual and offset is -1. The third column is YTD-Actual. The amount in the first column is obtained by subtracting the amount in the third column from the amount in the second column.
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
This section explains the programs used to export financial data to the appropriate format and file naming conventions as specified by the Chinese standards. The files are exported based on the legal entities.
Before you run the programs, you must:
Complete daily transactions entry in current month.
Run Account and Journal Itemization Program.
Run Cash Flow Statement Program - Data Collection.
Close accounting period of Fixed Assets and General Ledger.
The Solution offers the following data exports for Enterprise and Public Sector::
China Shared Information Data Export (Enterprise)
China General Ledger Data Export (Enterprise)
China Fixed Assets Data Export (Enterprise)
China Receivables and Payables Data Export (Enterprise)
China Payroll Data Export
This section describes the standard reports available for China, and explains selected parameters and the rows-columns settings in the reports.
The Account and Journal Itemization concurrent program populates the subsidiary account and journal line description for all journals. Subsidiary account is populated based on the subsidiary account setup in Subsidiary Account window, and the journal line description is populated for journals derived from the subledger in the SLA journal line description. The journal line can be itemized into multiple lines dependent on the Subsidiary Account setup.
To run the Account and Journal Itemization program:
From the predefined responsibility China Accounting Data Interface (Enterprise) or the responsibility you defined for financial data export, navigate to Data Export window.
Select the concurrent program Account and Journal Itemization program.
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Period: Select the period for which you will itemize journals and generate a balance. If you don't specify a period, the range is from the first period to the current date. If the data volume is large, it is recommend to run this program when you are not processing the daily transactions.
Submit the request
This concurrent program exports General Ledger information, including the following sections:
Electronic Accounting Book Export
Accounting Period Export
Exchange Rate Type Export
Currency Export
Settlement Method Export
Department Records Export
Employee Records Export
User-defined Records Export
User-defined Record Values Export
Supplier Records Export
Customer Records Export
To run China Shared Information Data Export (Enterprise):
From the predefined responsibility China Accounting Data Interface (Enterprise) or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China Shared Information Data Export (Enterprise).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Submit the request and view the output.
This concurrent program exports General Ledger information, including the following sections:
GL Basic Information Export
Chart of Accounts Export
Subsidiary Item of Account Export
Cash Flow Items Export
Accounting Period Amount and Balance Export
Journal Export
Exception Handling
Journal Related with Cash Flow Items Export
Report Item Data Export
To run China General Ledger Data Export (Enterprise):
From the predefined responsibility China Accounting Data Interface or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China General Ledger Data Export.
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year:: Select the accounting year for which you want to export the financial data.
Period Range: Select the period range for which you export the financial data.
FSG Reports: Defined by FSG based on Chart of Accounts..
Currency Unit:To indicate which currency unit the FSG reports use.
Balance Type:Select a balance type.
Submit the request and view the output.
This concurrent program exports fixed assets information, including the following sections:
Basic Information of Fixed Asset
Fixed Asset Category Setting
Modification Method
Fixed Asset Usage
Fixed Asset Card
Fixed Asset Card- Real Asset Information
Fixed Asset Card Usage Information
Fixed Asset Decreasing Information
Fixed Asset Decreasing Information- Real Asset Information
Fixed Asset modification Information
To run China Fixed Assets Data Export (Enterprise):
From the predefined responsibility China Accounting Data Interface or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China Fixed Asset Data Export (Enterprise).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Period Range: Select the period range for which you export the financial data.
Submit the request and view the output.
This concurrent program exports receivables and payables information, including the following sections:
Document Type
Transaction Type
Receivables Balance Detail
Payables Balance Detail
To run China Receivables and Payables Data Export (Enterprise):
From the predefined responsibility China Accounting Data Interface or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China Receivables and Payables Data Export (Enterprise).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Period Range: Select the period range for which you export the financial data.
Submit the request and view the output.
This concurrent program exports payroll information. Refer to payroll-related documentation for details.
The National Audit Office of the People's Republic of China (CNAO) has released a new accounting auditing filing standard (GB/T 24589-2010 Financial Information Technology - Data Interface of Accounting Software). Oracle is one of the main contributors involved in the standard definition. This new standard mandates the filing format, expands the scope of filing information required, and requires additional organizations to file their accounting information.
Public Sector and Government Ministry in China are required to report information to CNAO via the standard for Public Sector and Government Ministry(GB/T 24589.2-2010). The key process is to generate compliant XML documentation that meets the CNAO standards.
The Solution for China Financial Information Technology - Data Interface of Accounting Software Standard for Public Sector and Government Ministry , referred to as Solution in this section, enables you to export data with the requested formats from the Oracle E-Business Suite to meet the requirements of the China National Auditing Office Standard.
The data exported from the Oracle E-Business Suite is based on legal entity.
You can define the reports by using the existing Financial Statement Generator and XML Publisher. You can also generate the reports with different outputs by modifying the XML Publisher templates.
This section introduces you to financial data export and the cash flow statement.
Financial data export includes the following data export and financial report exports.
China General Ledger Data Export (Public Sector)
China Shared Information Data Export (Public Sector)
China Fixed Assets Data Report
China Payroll Data Export
You can use the Financial Statement Generator in the Oracle E-Business Suite to define and design reports and statements, and export financial data.
This section provides detailed instructions on how to set up the Public Sector and Government Ministry solution. You can define the categories and output formats for the financial data to suit your institution's needs.
The following setup steps must be completed before setting up the Solution. Refer to the corresponding product user or implementation guides for detailed instructions.
See: General Ledger Setup, Oracle General Ledger Implementation Guide.
See: Define organizations (single organization or multiple organizations) in Oracle HRMS.
See: Payrolls, Oracle HRMS Payroll Processing Management Guide.
See: Asset Setup, Oracle Assets User Guide.
The following table lists the setup steps to implement the Public Sector and Government Ministry Solution for China Accounting Software Data Interface Standard. Each required setup step must be completed before you implement the solution.
| Step Number | Step |
|---|---|
| Step 1 | Define and Set Up Flexfield |
| Step 2 | Define Responsibility and Set Up Profile |
| Step 3 | Set Up System Options |
| Step 4 | Set Up Subsidiary Account Sources |
| Step 5 | Define Flexfield Assignments |
| Step 6 | Define Financial Statement Generator |
If indicated, repeat the step for each ledger and legal entity.
You must define and set up the key flexfield and descriptive flexfield. You must define the flexfield structure for the key flexfield, which is set up once. You must also define the additional context and context structure for the descriptive flexfield.
For China, you must define the key flexfields listed in the following table.
| Application | Title | Segment | Value Set |
|---|---|---|---|
| Assets | Asset Key Flexfield | Asset Usages | User must create manually. |
| Assets | Asset Key Flexfield | Asset Unit of Measure | User must create manually. |
| General Ledger | Chart of Accounts Flexfield | Expenditure Function Category | User must create manually. |
| General Ledger | Chart of Accounts Flexfield | Expenditure Economy Category | User must create manually. |
| General Ledger | Chart of Accounts Flexfield | Project | User must create manually. |
| General Ledger | Chart of Accounts Flexfield | Income Category | User must create manually. |
| General Ledger | Chart of Accounts Flexfield | Income Project | User must create manually. |
| General Ledger | Chart of Accounts Flexfield | Budget Type | User must create manually. |
To define the key asset flexfield:
From the System Administrator responsibility, navigate to the Key Flexfield Segments window.
In the Application field, select Assets (Asset Key Flexfield).
Select an existing structure or define a new structure.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any three segments to define Asset Usages and Asset Unit of Measure.
Save your work.
Freeze the flexfield and compile.
To define the account structure:
From the System Administrator responsibility, navigate to the Key Flexfield Segments window.
In the Application field, select Asia/Pacific Localizations (Account Structure).
Select an existing structure or define a new structure.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any three segments to define levels of account structure.
Tip: You should define account structure depending on your organization's requirements and you must enable at least one segment for the account structure key flexfield.
Save your work.
Freeze the flexfield and compile.
To define the General Ledger Chart of Accounts Flexfield:
From the System Administrator responsibility, navigate to the Key Flexfield Segments window.
In the Application field, select General Ledger (Chart of Accounts Flexfield).
Select an existing structure or define a new structure.
Click Segments.. In the Segments window you can assign any six unused segments to define Expenditure Function Category, Expenditure Economy Category, Project, Income Category, Income Project and Budget Type.
Save your work.
Freeze the flexfield and compile.
See: Key Flexfields, Oracle Applications Flexfields Guide.
See: Additional Terms and Concepts for Key Flexfields, Oracle Applications Flexfields Guide.
See: Planning Your Key Flexfield, Oracle Applications Flexfields Guide.
Define the descriptive flexfield to enter information that cannot be entered in the standard forms. A descriptive flexfield may have a context-sensitive segment. For China, you must define the descriptive flexfields listed in the following table.
| Application | Title | Segment | Value Set |
|---|---|---|---|
| Application Object Library | Flexfield segment values | Account Level | 2 digits |
| Application Object Library | Flexfield segment values | Balance Side | JA_CN_DEBIT_CREDIT |
| Application Object Library | Flexfield segment values | Project Level | 1 char |
| Application Object Library | Flexfield segment values | Project Type | User must create manually. |
| Application Object Library | Flexfield segment values | Project Category | User must create manually. |
| Application Object Library | Flexfield segment values | Project Attribute | User must create manually. |
| Application Object Library | Flexfield segment values | Project Starting Date | FND_STANDARD_DATE |
| Application Object Library | Flexfield segment values | Project Ending Date | FND_STANDARD_DATE |
| Application Object Library | Flexfield segment values | Fund Type | User must create manually. |
| Application Object Library | Flexfield segment values | Budget Source | User must create manually. |
| Application Object Library | Flexfield segment values | Payment Method | User must create manually. |
| Application Object Library | Flexfield segment values | Budget Category | JA_CN_PS_BUDGET_CATEGORY |
| General Ledger | Enter Journals: Journals | Settlement Method | JA_CN_SETTLEMENT_METHOD |
To define the Application Object Library Flexfield Segment Value descriptive flexfield:
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select Application Object Library (Flexfield Segment Value).
Define or update context for Balance Side and Account Level,
Select an existing context or define a new context for additional project information.
Click Segments. In the Segments window you can assign any nine attributes to define additional information for project.
Select an existing context or define a new context for budget category.
Click Segments. In the Segments window you can assign any attribute to define budget category.
Save your work.
Freeze the flexfield and compile.
To define the General Ledger Enter Journals: Journals descriptive flexfield:
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Application field, select General Ledger (Enter Journals: Journals).
Select an existing context or define a new context.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any attribute to define Settlement Method.
Save your work.
Freeze the flexfield and compile.
See: Descriptive Flexfields, Oracle Applications Flexfields Guide.
See: Planning Your Descriptive Flexfield, Oracle Applications Flexfields Guide.
See: Descriptive Flexfield Segments Window, Oracle Applications Flexfields Guide.
See: Defining Segment Values, Oracle Applications Flexfields Guide.
See: Defining Journal Categories, Oracle General Ledger Implementation Guide.
You can use the predefined responsibility China Accounting Data Interface (Public Sector), or you can define a new responsibility as described below.
When defining a responsibility, assign the following elements to the responsibility:
Data group
Request group
Menu (the predefined value is JA_CN__PS_GL_SUPERUSER)
Function and menu exclusion
The predefined responsibility is China Accounting Data Interface (Public Sector).
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
As a system administrator, you can control Oracle Applications by creating profile options with different values. You define profile options at the following levels: site, application, responsibility, user, server and organization.
The following table describes the profile options that must be set for China localizations:
| Profile Option Name | Value | Level |
|---|---|---|
| JG: Application | General Ledger | Responsibility |
| JG: Product | Asia/Pacific Localizations | Site |
| JG: Territory | China | Site |
| JA: CN Legal Entity | Legal Entity you defined | Responsibility |
| GL: Data Access Set | Data Access Set you defined | Responsibility |
Additional Information: For the setup of operating unit profiles, you can set up either MO: Operating Unit or MO: Security Profile based on your business requirement.
To define profile:
From System Administrator responsibility, navigate to the Find System Profile Values window.
Choose the responsibility China Accounting Data Interface (Enterprise) and enter profile JG: %.
Click Find. System displays the System Profile Values window. In the System Profile Values window, you can assign proper values shown in the table above to the corresponding profiles.
Repeat the steps 2 and 3 to complete the setup of other profiles shown in the table above.
Save your work.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
You must define the basic information for your legal entity using the System Options window. Before you set up the system options, you must define the following:
Legal entity
Responsibility
Profile
Use the System Options window to enter information about the accounting book and the rounding rule.
Note: A corresponding legal entity related to the current responsibility is displayed in the Legal Entity field. The accounting book information corresponding to the current legal entity is displayed in the Accounting Book Information block.
Use the Miscellaneous Options block to define the rounding rule.
Repeat this step for each legal entity.
To define System Options:
From the China Accounting Data Interface (Enterprise) responsibility, navigate to the System Options window.
Enter supplementary information for the Accounting Book and choose the proper rounding rule for Miscellaneous Options.
Legal Entity: The corresponding legal entity of the current responsibility. Field cannot be updated once entered.
Book Name: Defaulted as the ledger name defined for current ledger.
Company Name: Defaulted as the legal entity name.
Rounding Rule: Indicates the round method of transactions. Refer to the currency setting for accuracy.
Other fields: Book Number, Organization ID, Enterprise Quality, Enterprise Industry, and Standard Version are all mandatory fields that require manual entry.
Save your work.
See: Defining Ledgers, Oracle General Ledger Implementation Guide.
See: Designing Your Accounting Flexfield, Oracle General Ledger Implementation Guide.
See: Defining Legal Entities Using the Legal Entity Configurator, Oracle Financials Implementation Guide.
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
You must define the accounting structure and subsidiary account source based on your chart of accounts using the Subsidiary Account Sources window.
In the Subsidiary Account Mapping region, you can assign the detailed context information to a maximum of thirty separate subsidiary accounts.
Note: Setting up subsidiary account sources is only required for Financial Data Export. You must define the account structure before completing this set up.
To define Subsidiary Account Sources:
From the China Accounting Data Interface (Public Sector) responsibility, navigate to the Subsidiary Account Sources window.
Enter the account structure.
Account Structure Code: Indicate which key flexfield segment code is used for the account structure definition.
Structure: Indicate the natural account structure per account hierarchy.
Define the subsidiary account mapping.
Subsidiary Segment: Indicate which subsidiary segment is used. This is a view-only field with serially-numbered segments.
Sources: Indicate which subsidiary segment source will be itemized, including the three values: COA, SLA and Project Module.
Context: List of values from which you can select detailed context based on the sources. Context can only be selected once before being removed from the list of values.
Save your work.
You must define the prescribed descriptive and key flexfields and the flexfield assignments to specify usages of the descriptive and key flexfields. Information is obtained and processed from the specified location by referencing the flexfield assignments.
Before defining the flexfield assignments, you must define descriptive flexfields for flexfield segment values, GL journals, and the chart of accounts flexfield for asset key flexfield.
To define Flexfield Assignments:
From the China Accounting Data Interface (Public Sector), navigate to the Flexfield Assignments window.
Define context and column usages of flexfields.
Select the context and attribute columns for budget category.
Select the context and attribute columns for additional project information, such as project attribute, project category, etc.
Select the context and segment columns for asset usages and asset unit of measure.
Select the context and segment columns for budget, such as budget type, expenditure function category, income category, etc.
Select the context and attribute columns for settlement method, which would be entered on journal header.
Save your work.
See: Descriptive Flexfield Concepts, Oracle Applications Flexfields Guide.
See: Descriptive Flexfield Segments Window, Oracle Applications Flexfields Guide.
Repeat this step for each chart of accounts.
You must define the exported financial statements by using the financial statement generator (FSG), including the following FSG reports.
Balance Sheet Report
Revenue and Expenditure Report
Expenditure Detail Report
See: Overview of the Financial Statement Generator, Oracle General Ledger User's Guide.
This section explains the programs used to export financial data to the appropriate format and file naming conventions as specified by the Chinese standards. The files are exported based on the legal entities.
Before you run the programs, you must:
Complete daily transactions entry in current month.
Run Account and Journal Itemization Program.
Close accounting period of Fixed Assets and General Ledger.
The Solution offers the following data exports for Public Sector:
China Shared Information Data Export (Public Sector)
China General Ledger Data Export (Public Sector)
China Fixed Assets Data Export (Public Sector)
China Payroll Data Export
The Solution for China Accounting Software Data Interface Standard provides the financial data export function in the Oracle E-Business suite, which includes a series of XML-Based reports required by the CNAO standards.
The Account and Journal Itemization concurrent program populates the subsidiary account and journal line description for all journals. Subsidiary account is populated based on the subsidiary account setup in Subsidiary Account window, and the journal line description is populated for journals derived from the subledger in the SLA journal line description. The journal line can be itemized into multiple lines dependent on the Subsidiary Account setup.
To run the Account and Journal Itemization program:
From the predefined responsibility China Accounting Data Interface (Public Sector) or the responsibility you defined for financial data export, navigate to Data Export window.
Select the concurrent program Account and Journal Itemization program.
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Period: Select the period for which you will itemize journals and generate a balance. If you don't specify a period, the range is from the first period to the current date. If the data volume is large, it is recommend to run this program when you are not processing the daily transactions.
Submit the request
This concurrent program exports shared information used by General Ledger, Fixed Assets, and Human Resources, including the following sections:
Electronic Accounting Book Export
Accounting Period Export
Exchange Rate Type Export
Currency Export
Settlement Method Export
Department Records Export
Employee Records Export
User-defined Records Export
User-defined Record Values Export
To run China Shared Information Data Export (Public Sector):
From the predefined responsibility China Accounting Data Interface (Public Sector) or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China Shared Information Data Export (Public Sector).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Submit the request and view the output.
This concurrent program exports General Ledger information, including the following sections:
GL Basic Information Export
Chart of Accounts Export
Journal Category Export
Subsidiary Item of Account Export
Cash Flow Items Export
Accounting Period Amount and Balance Export
Journal Export
Report Set Export
Report Item Data Export
Current Year Budget Target Export
Budget Expenditure Export
Budget Income Export
To run China General Ledger Data Export (Public Sector):
From the predefined responsibility China Accounting Data Interface (Public Sector) or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China General Ledger Data Export (Public Sector).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Period Range: Select the period range for which you export the financial data.
FSG Reports: Defined by FSG based on Chart of Accounts.
Currency Unit: To indicate which currency unit the FSG reports use.
Submit the request and view the output.
This concurrent program exports fixed assets information, including the following sections:
Basic Information of Fixed Asset
Fixed Asset Category Setting
Modification Method
Fixed Asset Usage
Fixed Asset Card
Fixed Asset Card- Real Asset Information
Fixed Asset Card Usage Information
Fixed Asset Decreasing Information
Fixed Asset Decreasing Information- Real Asset Information
Fixed Asset Modification Information
To run China Fixed Assets Data Export (Public Sector):
From the predefined responsibility China Accounting Data Interface (Public Sector) or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China Fixed Asset Data Export (Public Sector).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Period Range: Select the period range for which you export the financial data.
Submit the request and view the output.
This concurrent program exports payroll information. Refer to payroll-related documentation for details.
The National Audit Office of the People's Republic of China (CNAO) has released a new accounting auditing filing standard (GB/T 24589-2010 Financial Information Technology - Data Interface of Accounting Software). Oracle is one of the main contributors involved in the standard definition. This new standard mandates the filing format, expands the scope of filing information required, and requires additional organizations to file their accounting information.
State-owned banks in China are required to report information to CNAO via the standard for banking (GB/T 24589.1-2010). The key process is to generate compliant XML documentation that meets the CNAO standards.
The Solution for China Accounting Software Data Interface Standard, referred to as Solution in this section, allows you to export data from the Oracle E-Business Suite to meet the requirements of the China National Auditing Office Standard. The solution enhances the capabilities of Oracle E-Business Suite, for China, by generating files with the requested formats. The data exported from the Oracle E-Business Suite is based on legal entity and not ledgers. You can define the reports by using the existing Financial Statement Generator and XML Publisher. You can also generate the reports with different outputs by modifying the XML Publisher templates. The Solution provides the cash flow statement function, which covers cash related flows of general ledger and subledgers. You can define the reports by using the existing Financial Statement Generator and XML Publisher. You can also generate the reports with different outputs by modifying the XML Publisher templates.
This section introduces you to financial data export and the cash flow statement.
Financial data export includes the following data export and financial report exports.
China General Ledger Data Export (Banking)
China Shared Information Data Export (Banking)
China Fixed Assets Data Report (Enterprise)
You can use the Financial Statement Generator in the Oracle E-Business Suite to define and design reports and statements, and export financial data.
This section provides detailed instructions on how to set up the banking solution. You can define the categories and output formats for the financial data and cash flow items to suit your enterprise's needs.
The following setup steps must be completed before setting up the Solution. Refer to the corresponding product user or implementation guides for detailed instructions.
See: General Ledger Setup, Oracle General Ledger Implementation Guide.
See: Define organizations (single organization or multiple organizations) in Oracle HRMS.
See: Payrolls, Oracle HRMS Payroll Processing Management Guide.
All setups for Financial Data Export should be completed with the following setups.
| Step Number | Step |
|---|---|
| Step 1 | Define System Options by Balance Segment |
| Step 2 | Define Segment Qualifiers under the nature account segment. |
| Step 3 | Define FSG Report |
If indicated, repeat the step for each ledger, legal entity, and balance segments.
You must define and set up the key flexfield and descriptive flexfield. You must define the flexfield structure for the key flexfield, which is set up once. .
For Chinese accounting, you must define the key flexfields listed in the following table. These key flexfield definitions are only required for Financial Data Export.
| Application | Title Value Set | Segment | Digits |
|---|---|---|---|
| Asia/Pacific Localizations | Account Structure | Level 1 | 2 Digits |
| Asia/Pacific Localizations | Account Structure | Level 2 | 2 Digits |
| Asia/Pacific Localizations | Account Structure | Level 3 | 2 Digits |
To define the account structure:
From the System Administrator responsibility, navigate to the Key Flexfield Segments window.
In the Application field, select Asia/Pacific Localizations (Account Structure).
Select an existing structure or define a new structure.
Click Segments. System displays the Segments Summary window. In the Segments window you can assign any three segments to define levels of account structure.
Tip: You should define account structure depending on your organization's requirements and you must enable at least one segment for the account structure key flexfield.
Save your work.
Freeze the flexfield and compile.
See: Key Flexfields, Oracle Applications Flexfields Guide.
See: Additional Terms and Concepts for Key Flexfields, Oracle Applications Flexfields Guide.
See: Planning Your Key Flexfield, Oracle Applications Flexfields Guide.
You can use the predefined responsibility China Accounting Data Interface (Enterprise), or you can define a new responsibility as described below.
When defining a responsibility, assign the following elements to the responsibility:
Data group
Request group
Menu (the predefined value is JA_CN_GL_SUPERUSER)
Function and menu exclusion
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
As a system administrator, you can control Oracle Applications by creating profile options with different values. You define profile options at the following levels: site, application, responsibility, user, server and organization.
The following table describes the profile options that must be set for China localizations:
| Profile Option Name | Value | Level |
|---|---|---|
| JG: Application | General Ledger | Responsibility |
| JG: Product | Asia/Pacific Localizations | Site |
| JG: Territory | China | Site |
| JA: CN Legal Entity | Legal Entity you defined | Responsibility |
| GL: Data Access Set | Data Access Set you defined | Responsibility |
| MO: Default Operating Unit | Default Operating Unit you defined | Responsibility |
| MO: Operating Unit | Single Operating Unit you defined | Responsibility |
| MO: Security Profile | Multiple Operating Units you defined | Responsibility |
Additional Information: For the setup of operating unit profiles, you can set up either MO: Operating Unit or MO: Security Profile based on your business requirement.
To define profile:
From System Administrator responsibility, navigate to the Find System Profile Values window.
Choose the responsibility China Accounting Data Interface (Enterprise) and enter profile JG: %.
Click Find. System displays the System Profile Values window. In the System Profile Values window, you can assign proper values shown in the table above to the corresponding profiles.
Repeat the steps 2 and 3 to complete the setup of other profiles shown in the table above.
Save your work.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
You must define the basic information for your legal entity using the System Options window. Before you set up the system options, you must define the following:
Balance Segment
Responsibility
Profile
Use the System Options window to enter information about the accounting book and the rounding rule.
Note: A corresponding balance segment related to the current responsibility is displayed in the Balance Segment field. The accounting book information corresponding to the current balance segment is displayed in the Accounting Book Information block.
Repeat this step for each balance segment.
To define System Options:
From the China Accounting Data Interface (Banking) responsibility, navigate to the System Options window.
Enter supplementary information for the Accounting Book and choose the proper rounding rule for Miscellaneous Options.
Ledger:The corresponding ledger of the current responsibility. Field cannot be updated once entered.
Legal Entity: The corresponding legal entity of the current responsibility. Field cannot be updated once entered.
Balance Segment:: The corresponding balance segment of the current responsibility. Field cannot be updated once entered.
Other fields: Organization ID, Enterprise Quality, Enterprise Industry, Standard Version, and Account Structure are all mandatory fields that require manual entry.
Save your work.
See: Defining Ledgers, Oracle General Ledger Implementation Guide.
See: Designing Your Accounting Flexfield, Oracle General Ledger Implementation Guide.
See: Defining Legal Entities Using the Legal Entity Configurator, Oracle Financials Implementation Guide.
See: Defining a Responsibility, Oracle Applications System Administrator's Guide - Security.
See: Overview of Setting Up Profiles, Oracle Applications System Administrator's Guide - Maintenance.
Repeat this step for each chart of accounts.
You must define the exported financial statements by using the financial statement generator (FSG), including the following FSG reports.
Cash Flow Statement Report
Balance Sheet Report
Profit Statement Report
Statement of Changes In Owners' Equity Report
For cash flow statement, you must assign the cash flow items for the corresponding lines in the Cash Flow Statement Assignments window to define the statement templates, accounting assignments, and calculate the formulas in the financial statement generator. The other three FSG reports are only required for Financial Data Export.
See: Overview of the Financial Statement Generator, Oracle General Ledger User's Guide.
To define Cash Flow Statement:
Define the Row Set. From the China Accounting Data Interface (Enterprise) responsibility, navigate to the Row Set window.
Define the name and description for row set.
Define Rows
Display Zero option should be selected for each row.
At least one row is assigned to an account.
Save your work.
Define Column Set. Navigate to the Column Set window.
Define the name and description for column set.
Define columns. Display Zero option should be selected for each column.
Save your work.
Define Report. Navigate to the Report window.
Choose the row set and the column set you have defined for cash flow statement.
Repeat above steps for other three FSG reports if need. Save your work.
Note: When defining the account assignment (or calculation formula) and cash flow statement assignment at the same time, for one of the rows in the cash flow statement, the priority of account assignment (or calculation formula) takes priority over the cash flow statement assignment. When the account assignment (or calculation formula) is not defined, the application processes the cash flow item based on the cash flow statement assignment.
This section explains the programs used to export financial data to the appropriate format and file naming conventions as specified by the Chinese standards. The files are exported based on the legal entities.
Before you run the programs, you must:
Complete daily transactions entry in current month.
Complete the related setup above.
The Solution offers the following data exports for a state owned commercial bank.:
China Shared Information Data Export (Banking)
China General Ledger Data Export (Banking)
This section describes the standard reports available for China, and explains selected parameters and the rows-columns settings in the reports.
This concurrent program exports General Ledger information, including the following sections:
Electronic Accounting Book Export
Accounting Period Export
Exchange Rate Type Export
Currency Export
Settlement Method Export
Department Records Export
Employee Records Export
User-defined Records Export
User-defined Record Values Export
Supplier Records Export
Customer Records Export
To run China Shared Information Data Export (Enterprise):
From the predefined responsibility China Accounting Data Interface (Enterprise) or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China Shared Information Data Export (Enterprise).
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set and the legal entity is specified in the profile JA: CN Legal Entity.
Accounting Year: Select the accounting year for which you want to export the financial data.
Submit the request and view the output.
This concurrent program exports General Ledger information, including the following sections:
Account Detail Export
Accounting Period Amount and Balance Export
Journal Export
Report Set Export
Report Item Data Export
To run China General Ledger Data Export (Banking):
From the predefined responsibility China Accounting Data Interface or the responsibility you defined for financial data export, navigate to the Submit Request window.
Select the concurrent program China General Ledger Data Export.
Ledger: All ledgers belonging to the data access set and specified legal entity are available. The data access set is specified in the profile GL: Data Access Set.
Balance Segment: All balance segments belonging to the data access set and specified legal entity.
Accounting Year:: Select the accounting year for which you want to export the financial data.
Period Range: Select the period range for which you export the financial data.
FSG Reports: Defined by FSG based on Chart of Accounts..
Submit the request and view the output.