Oracle Fusion · Data dictionary
FA_BOOKS
Fixed AssetsUsed in 2 subject areas20 reporting columns
Fixed Assets (FA) — asset-by-book records. Cost, salvage, life, and method per depreciation book.
Primary key: ASSET_ID, BOOK_TYPE_CODE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADJUSTED_RECOVERABLE_COST | ● | Adjusted recoverable cost. | |
| ALLOWED_DEPRN_LIMIT | ● | Allowed deprn limit. | |
| ALLOWED_DEPRN_LIMIT_AMOUNT | ● | Allowed deprn limit amount. | |
| ASSET_ID | PK | ○ | Identifier for the asset. |
| BOOK_TYPE_CODE | PK | ○ | Code identifying the book type. |
| CAPITALIZE_FLAG | ● | Indicator (Y/N) for the capitalize. | |
| CONVERSION_DATE | ● | Conversion date. | |
| COST | ● | Cost. | |
| DATE_INEFFECTIVE | ● | Date ineffective. | |
| DEPRECIATE_FLAG | ● | Indicator (Y/N) for the depreciate. | |
| DEPRN_START_DATE | ● | Deprn start date. | |
| OLD_ADJUSTED_COST | ● | Old adjusted cost. | |
| ORIGINAL_COST | ● | Original cost. | |
| ORIGINAL_DEPRN_START_DATE | ● | Original deprn start date. | |
| PERCENT_SALVAGE_VALUE | ● | Percent salvage value. | |
| PRORATE_DATE | ● | Prorate date. | |
| RECOVERABLE_COST | ● | Recoverable cost. | |
| SALVAGE_TYPE | ● | Type of salvage. | |
| SALVAGE_VALUE | ● | Salvage value. | |
| SHORT_FISCAL_YEAR_FLAG | ● | Indicator (Y/N) for the short fiscal year. | |
| TRANSACTION_HEADER_ID_IN | ● | Transaction header id in. | |
| TRANSACTION_HEADER_ID_OUT | ● | Transaction header id out. |
21 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to FA_BOOKS.
- Asset Addition and Cost Adjustment Report
- Asset Audit History Detail Report
- Asset Category Exceptions Report
- Asset Retirements Report
- Asset Register Report
- Reserve Detail Report
- Reserve Summary Report
- Journal Entry Reserve Ledger Report
- Account Reconciliation Reserve Ledger Report
- Asset Additions Report
- Asset Additions by Cost Center Report
- Asset Additions by Source Report
- Asset Transfers Report
- Asset Reclassification Reconciliation Report
- Cost Adjustments Report
- Reserve Adjustments Report
- Cost Detail Report
- Cost Summary Report
- CIP Detail Report
- CIP Summary Report
- What-If Depreciation Analysis Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for FA_BOOKS?
We ship parameterized SQL, BICC config, and dbt models you own.