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