Oracle Fusion/Financials/Fixed Assets

FA_ADDITIONS_B

Asset header — description, category, and unique asset identifier.

Key Columns

ASSET_IDASSET_NUMBERASSET_CATEGORY_ID

Child Tables

FA_BOOKS

Assigns an asset to a depreciation book — cost, life, method, and in-service date for that book.

FA_DISTRIBUTION_HISTORY

Where an asset is assigned over time — expense account, location and employee, with effective date ranges.

FA_RETIREMENTS

Asset retirements — full and partial retirements with cost retired, proceeds of sale and cost of removal.

Common Joins

FA_BOOKSvia ASSET_ID

The depreciation book(s) this asset is assigned to — cost, life, method, and in-service date per book.

Used In

Fixed AssetsSubledger Accounting

Notes

Exact column set varies by release — verify against your instance before relying on anything beyond ASSET_ID.

Fixed Assets data model

An asset is added (FA_ADDITIONS_B), assigned to one or more depreciation books (FA_BOOKS) with a cost/life/method, and depreciation runs post expense to FA_DEPRECIATION_HISTORY, which Subledger Accounting then turns into GL journals.