Oracle Fusion · Financials · Master data

    Oracle Fusion Fixed Asset Data Migration

    Migrate fixed assets into Oracle Fusion, covering asset master data, cost and accumulated depreciation, asset books, categories, locations, assignments and depreciation continuity.

    Object overview

    Fixed assets are the object where getting the data right is only half the job. The other half is that depreciation must continue correctly from the cutover date — which means Fusion needs not just the cost but the accumulated depreciation, the in-service date, the method, the life and the remaining position, all consistent with each other.

    Assets also carry a reconciliation obligation in two directions: the asset register must agree with the GL cost and accumulated depreciation control accounts, and the depreciation Fusion calculates in the first period after go-live must match what the legacy system would have calculated.

    What data is typically migrated

    Scope is agreed in discovery; this is the shape of the object.

    Data areaTypical information
    Asset masterAsset number, description, tag, category, in-service date, status
    FinancialOriginal cost, salvage value, accumulated depreciation, net book value
    DepreciationMethod, life, prorate convention, depreciation to date
    BooksCorporate and tax books, each with their own values
    AssignmentCost centre, location, employee assignment, distribution percentages
    CategoryAsset category driving default accounts and depreciation rules

    Object relationships

    Dependency drives load sequence: a child cannot exist before its parent.

    Asset category (accounts + rules)
    └─ Asset
    └─ Asset in corporate book
    └─ Cost + accumulated depreciation
    └─ Asset in tax book
    └─ Assignment → cost centre / location

    Object migration flow

    Source Fixed AssetsDataMoveMap & transformValidateOracle Fusion Fixed AssetsDataVault reconciliationSign-off

    Before you migrate this object

    Confirm each of these before the first migration cycle.

    Asset categories are configured with accounts and default rules
    Depreciation method crosswalk is approved, with differences quantified
    Asset books (corporate and tax) are defined
    Locations and cost centres exist
    The disposal cut-off rule for the cutover window is agreed
    CIP handling is agreed
    The GL control account reconciliation method is agreed

    Common source systems

    Production-proven means we have delivered this object from that source. Supported and custom-mapping describe capability, not delivery history.

    Oracle EBS Production-provenSAP ECC Production-provenSAP R/3 SupportedMicrosoft Dynamics 365 SupportedOracle JD Edwards Supported

    Source-to-target mapping examples

    Object-level equivalence. Field-level mapping is produced per engagement.

    Source systemSource entityTarget object
    Oracle EBSFA Asset + Books + AssignmentsFusion Asset + Books + Assignments
    SAP ECCAsset master (ANLA) + values (ANLC)Fusion Asset + Book values
    Dynamics 365Fixed asset + booksFusion Asset + Books

    Migration methods for this object

    Mass Additions FBDI for the asset population

    Separate load per asset book (corporate, then tax)

    Prior-period accumulated depreciation loaded as an opening position rather than recalculated

    Extraction considerations

    Per book, not per assetAn asset exists in several books with different cost, life and accumulated depreciation. Extracting only the corporate book loses the tax position.
    Fully depreciated but still heldAssets at zero net book value still belong on the register until disposal, and are frequently and wrongly excluded.
    Disposals in the cutover windowAssets disposed between extraction and go-live need an agreed handling rule or the register will not agree with the GL.
    Construction in progressCIP assets have no in-service date and different accounting; they are extracted as their own category.

    Transformation rules

    Category mappingSource asset classes map to Fusion categories, which carry the default accounts and depreciation rules — so this mapping determines accounting behaviour, not just classification.
    Depreciation method and lifeSource methods are crosswalked to Fusion methods. Where no exact equivalent exists the difference is quantified and approved rather than silently substituted.
    Accumulated depreciation as an opening valueLoaded as-is rather than recalculated, so the asset's position matches the legacy system at cutover.
    Assignment distributionCost centre and location assignments must total 100% per asset.

    Data quality and validation

    Cost, accumulated depreciation and NBV are consistent

    Cost less accumulated depreciation equals net book value on every record.

    Category exists and is configured

    With its accounts and default rules in place.

    In-service date is not in the future

    And falls within an open or prior period.

    Assignment totals 100%

    Distribution percentages across cost centres sum correctly.

    Accumulated depreciation does not exceed depreciable base

    Cost less salvage.

    Load sequence and dependencies

    What has to exist before this object can load.

    1. 1Chart of accounts and GL periods
    2. 2Asset categories with their accounts
    3. 3Locations and cost centres
    4. 4Assets into the corporate book
    5. 5Assets into tax books
    6. 6Assignments
    7. 7Depreciation run and comparison

    Common migration errors

    What actually fails on this object, and why.

    NBV does not reconcileCost minus accumulated depreciation does not equal the supplied net book value.
    Category not foundThe mapped Fusion asset category does not exist.
    Accumulated depreciation exceeds costUsually a sign or currency error in extraction.
    Assignment does not total 100%Distribution percentages are incomplete.
    Invalid depreciation method for the categoryThe method is not permitted by the category's configuration.
    First-period depreciation mismatchFusion's calculated depreciation disagrees with the legacy figure, usually a prorate convention or life difference.

    Reconciliation

    Counts alone rarely prove this object migrated correctly.

    Total cost and total accumulated depreciation against the GL control accounts

    Asset count by category, including fully depreciated assets still held

    Net book value in total and by category

    First-period depreciation after go-live compared to the legacy expectation — the check that proves depreciation continuity

    Tax book position reconciled separately from the corporate book

    Related enterprise migration experience

    We have not published a case study whose scope specifically covered this object. Explore delivered projects across ERP, HCM, payroll and CRM data.

    Frequently asked questions

    Is accumulated depreciation migrated or recalculated?
    Migrated as an opening value. Recalculating from the in-service date almost never reproduces the legacy figure exactly, because conventions and method changes over the asset's life are not fully reconstructable.
    Should fully depreciated assets be migrated?
    Yes, if the organisation still holds them. They remain on the register until disposal, and excluding them breaks the reconciliation against the GL cost control account.
    How are tax books handled?
    As separate loads. An asset carries different cost, life and accumulated depreciation per book, so each book is loaded and reconciled independently.
    How do you prove depreciation will continue correctly?
    By running depreciation in the first period after load and comparing the result to what the legacy system would have produced. A matching register with mismatched depreciation means the method, life or prorate convention did not map correctly.

    Planning a similar data migration?

    Tell us your source application, target system, object scope, volume and migration timeline. We can discuss the recommended migration approach and relevant Syntra ETL project experience.