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
Joins (inferred from key columns): BOOK_TYPE_CODE → FA_BOOK_CONTROLS
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.
Problems that run through this table