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: TRANSACTION_HEADER_ID_IN (Oracle's FA_BOOKS_PK)
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 | ○ | Identifier for the asset. | |
| BOOK_TYPE_CODE | ○ | 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 | PK | ● | 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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