How You Export General Ledger Data for China

The Export General Ledger Data for China: Enterprise process exports data from Oracle Fusion General Ledger for an enterprise. On successful execution of the process, data is exported in an XML file.

Run the process from the Scheduled Processes Overview page from the Navigator > Tools.

Settings That Affect Data Export

Set these parameters before running the process:

Parameter	Description
Data Access Set	Specify the data access set associated with your data role.
Ledger	Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.
Legal Entity	When the selected ledger is a primary ledger, specify the legal entities assigned to it. When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.
Accounting Year	Specify the accounting years associated with the accounting calendar of the selected ledger.
From Period	Specify the beginning of a range of general ledger periods to be included for exporting data.
To Period	Specify the end of a range of general ledger periods to be included for exporting data.
Oracle Hyperion Reports	Specify these Oracle Hyperion reports: Cash Flow Statement Report Balance Sheet Report Profit Statement Report Statement of Changes in Owner's Equity Report

How Data Is Exported

The XML file includes these sections:

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

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

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

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

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

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

  • Cash-related account for China: For cash-related accounts, such as Cash or Bank.

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

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

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

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

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

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

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

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

  • Subsidiary value number: The value number depends on the subsidiary item sources.

  • Account balance: The balance is obtained after the itemize account and journal for China process and is summarized based on the entered currency.

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

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

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

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

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

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

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

• General Ledger journals information: Displays these values after itemization:

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

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

  • Journal number: The journal sequence number.

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

  • Journal source: The source defined for the journal.

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

  • Entered Currency: The code of the entered currency.

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

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

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

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

  • Settlement method number: The settlement method used.

  • Creator, reviewer, and poster: The name of the creator, reviewer, and poster is the employee name of the user. If there is no employee name for this user, it displays the user name.

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

    Note: When a journal doesn't need to be approved, the name of the poster is displayed in the reviewer.

• Information on journals related to cash flow item segment: Displays these values:

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

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

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

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

  • Journal category number: The category of the journal.

  • Entered currency: The entered currency is obtained from the journal header.

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

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

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

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

  • Balance Sheet

  • Income Statement

  • Cash Flow Statement

  • Statement of Change in Equity

  Note: These reports are exported from Oracle Hyperion.

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

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