Oracle Fusion · Data dictionary
FA_ASSET_RETIREMENTS_V
Fixed AssetsUsed in 1 subject areas15 reporting columns
Fixed Assets (FA), denormalized view.
Primary key: not yet catalogued for FA_ASSET_RETIREMENTS_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): TRANSACTION_HEADER_ID → FA_TRANSACTION_HEADERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| GAIN_LOSS_TYPE_CODE | ● | Code identifying the gain loss type. | |
| RECOGNIZE_GAIN_LOSS | ● | Recognize gain loss. | |
| REFERENCE_NUM | ● | Reference number. | |
| RETIREMENT_ID | ● | Identifier for the retirement. | |
| RETIREMENT_TYPE_CODE | ● | Code identifying the retirement type. | |
| SOLD_TO | ● | Sold to. | |
| STATUS | ● | Status. | |
| STL_DEPRN_AMOUNT | ● | Stl deprn amount. | |
| TRANSACTION_HEADER_ID | ● | Identifier for the transaction header. | |
| TRANSACTION_HEADER_ID_OUT | ● | Transaction header id out. | |
| TRANSACTION_KEY | ● | Transaction key. | |
| TRANSACTION_NAME | ● | Name of the transaction. | |
| TRANSACTION_SUBTYPE | ● | Transaction subtype. | |
| TRANSACTION_TYPE_CODE | ● | Code identifying the transaction type. | |
| UNITS | ● | Units. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
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_ASSET_RETIREMENTS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table