Oracle Fusion · Data dictionary
FA_DEPRN_DETAIL
Fixed AssetsUsed in 2 subject areas16 reporting columns
Fixed Assets (FA) — depreciation detail per asset, book, period, and distribution.
Primary key: ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, DISTRIBUTION_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDITION_COST_TO_CLEAR | ● | Addition cost to clear. | |
| ASSET_ID | PK | ○ | Identifier for the asset. |
| BONUS_DEPRN_ADJUSTMENT_AMOUNT | ● | Bonus deprn adjustment amount. | |
| BONUS_DEPRN_AMOUNT | ● | Bonus deprn amount. | |
| BONUS_DEPRN_RESERVE | ● | Bonus deprn reserve. | |
| BONUS_YTD_DEPRN | ● | Bonus ytd deprn. | |
| BOOK_TYPE_CODE | PK | ○ | Code identifying the book type. |
| COST | ● | Cost. | |
| DEPRN_ADJUSTMENT_AMOUNT | ● | Deprn adjustment amount. | |
| DEPRN_AMOUNT | ● | Deprn amount. | |
| DEPRN_RESERVE | ● | Deprn reserve. | |
| DEPRN_RUN_DATE | ● | Deprn run date. | |
| DEPRN_SOURCE_CODE | ● | Code identifying the deprn source. | |
| DISTRIBUTION_ID | PK | ○ | Identifier for the distribution. |
| PERIOD_COUNTER | PK | ● | Period counter. |
| REVAL_AMORTIZATION | ● | Reval amortization. | |
| REVAL_DEPRN_EXPENSE | ● | Reval deprn expense. | |
| REVAL_RESERVE | ● | Reval reserve. | |
| YTD_REVAL_DEPRN_EXPENSE | ● | Ytd reval deprn expense. |
6 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_DEPRN_DETAIL.
- Asset Accounting and Location Report
- Asset Retirements Report
- FA to GL Reconciliation Report
- Reserve Detail Report
- Journal Entry Reserve Ledger Report
- Account Reconciliation Reserve Ledger 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_DEPRN_DETAIL?
We ship parameterized SQL, BICC config, and dbt models you own.