Oracle Fusion/Financials/Fixed Assets

FA_BOOKS

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

Key Columns

ASSET_IDBOOK_TYPE_CODEDATE_PLACED_IN_SERVICECOST

Parent Table

FA_ADDITIONS_B

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

Child Tables

FA_DEPRECIATION_HISTORY

Depreciation expense recorded for an asset in a given period, by depreciation run.

Common Joins

FA_DEPRECIATION_HISTORYvia ASSET_ID + BOOK_TYPE_CODE

The depreciation expense recorded for this asset/book over time.

Used In

Fixed Assets

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.