How You Export Fixed Assets Data for China

The Export Fixed Assets Data for China: Enterprise process exports data from Oracle Fusion Assets for an enterprise. Data is exported in an XML file after successful execution of the process.

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.

How Data Is Exported

The XML file includes these sections:

• Basic fixed asset information

  This section provides basic information for assets that exist during the specified period and owned by the specified legal entity and ledger. The basic information includes: fixed asset account, accumulated impairment account, and accumulated depreciation account.

• Fixed asset category setting

  This section provides information for assets that exist during the specified period and owned by the specified legal entity and ledger. It includes information, such as fixed asset category code convention, fixed asset category code, and fixed asset category name.

  Determine the fixed asset category convention as the maximum size value of every category segment and use - to link these maximum size values. For example, 20-10-20 indicates the category has three segments, the maximum size value for the first segment is 20, the second is 10, and the last is 20.

• Modification method

  This section exports transaction types that had transactions during the specified period range. Only assets of these transaction types are exported: addition, adjustment, reclassification, reinstatement, transfer, unit adjustment, and reverse adjustment. The section includes information, such as modification method code and modification method name.

• Fixed asset depreciation method

  This section exports depreciation methods that are assigned to the assets in the selected period range. It includes information, such as depreciation method code, depreciation method name, and depreciation formula.

• Fixed asset usage

  This section only exports the usage status which is assigned to the eligible assets. It includes information, such as usage status code and usage status name.

  Oracle Fusion uses global descriptive flexfield to maintain the asset usage status code.
• Fixed asset card

  This section exports assets that exist during the specified period range. When multiple periods are specified, the asset card exports multiple times against the specified period. Fully retired assets during the specified period aren't included during export.

  When an asset is reinstated during the export period, the asset card is exported for this period and the periods afterward. This section displays information such as reinstated assets: unit, original value, accumulated depreciation value, net book value, accumulate impairment value, salvage value, and monthly depreciation amount.

  When you assign an asset to multiple balance segment values, this information along with product capacity and life to date production is displayed in a percent based on the total unit assignment for all balance segment values of the legal entity.

• Fixed asset card - real asset information

  This section only provides information on assets that exist during the specified period range. When multiple periods are specified, the asset card exports multiple times against the specified period.

  The location information is obtained from the location field on the Asset Assignment region on the Inquire Assets page. When an asset is assigned to multiple legal entities, only the locations associated with the specified legal entity are displayed.

  When an asset is assigned to multiple asset books with the same legal entity and ledger, the asset is exported multiple times.

  The section includes information, such as fixed asset card number, accounting period, fixed asset tag number, fixed asset location, and fixed asset model.

• Fixed asset card usage information

  This section only exports the usage information for assets that are associated with the specified period range. When you specify multiple periods, the asset card exports multiple times against every period.

  The location information is obtained from the location field on the Asset Assignment region on the Inquire Assets page. When an asset is assigned to multiple legal entities, only the locations associated with the specified legal entity are displayed.

  Obtain the department information from the employee assigned to the asset and derive the human resource organization from employee record as the asset department. When the asset is assigned to multiple departments, the asset card appears repeatedly with different departments in the report.

  When an asset is assigned to multiple asset books with the same legal entity and ledger, the asset is exported multiple times.

  The section includes information, such as fixed asset card number, fixed asset tag number, accounting period, fixed asset department, and depreciation prorate.

• Fixed asset decreasing information

  This section provides asset decreasing information that occurred during the specified period range. The decreasing transaction information is extracted from the Asset Transaction Inquiry page. Only fully retirement transaction type and partial retirement transaction type are considered as decreasing transactions.

  When a retired or partially retired asset is assigned to multiple legal entities with different balance segment values, the decreasing value and quantity are calculated as follows:

  • Full retirement:

    Decreasing Quantity = Unit assigned to the Legal Entity

    Decreasing Information Value = Cost Retired * Unit Assigned to the Legal Entity/Total Unit of Asset

  • Partial retirement: For cost retirement, retired unit isn't entered.

    Decreasing Quantity = Unit Assigned to the Legal Entity * Cost Retired/Current Cost

    Decreasing Information Value = Cost Retired * Unit Assigned to the Legal Entity/Total Unit of Asset

  When there are multiple partial retirement transactions during a period, the transactions are displayed repeatedly in the report.

  The section includes information, such as transaction number and date, accounting period, modification method code, fixed asset card number, fixed asset name, fixed asset number, decreased quantity, decreased original value, decreased accumulated depreciation, decreased accumulated impairment, decreased salvage value, proceeds of sale, cost of removal, and decrease reason.

• Fixed asset decreasing information - real asset information

  This section includes information such as transaction number, fixed asset card number, fixed asset tag number, and accounting period.

• Fixed asset modification information

  This section provides the asset modification information that occurred during the specified period range. The modification transaction information is extracted from the Asset Transaction Inquiry page.

  Assets with these transaction types are exported: addition, adjustment, reclassification, reinstatement, transfer, unit adjustment, and reverse adjustment.

  When the asset was assigned to multiple legal entities, the premodification value and post-modification value must be distributed within legal entities per assignment rate.

  When multiple fields are modified in one transaction, split the transaction into multiple records (one record for one change). The transaction number is displayed as Transaction Number-1, Transaction Number-2, and so on.

  These modification transactions are excluded from the export report: original cost, recoverable cost, prorate date, and salvage rate.

  The modification information export section includes information, such as transaction number, modification date, accounting period, fixed asset card number, fixed asset number, fixed asset name, modification method code, fixed asset tag number, content and amount before and after modification, and modification reason.