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. 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_ASSET_RETIREMENTS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table