Oracle Fusion · Data dictionary
FA_ADJUSTMENTS
Fixed AssetsUsed in 3 subject areas8 reporting columns
Fixed Assets (FA).
Primary key: ADJUSTMENT_LINE_ID
Joins (inferred from key columns): TRANSACTION_HEADER_ID → FA_TRANSACTION_HEADERS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADJUSTMENT_AMOUNT | ● | Adjustment amount. | |
| ADJUSTMENT_LINE_ID | PK | ○ | Identifier for the adjustment line. |
| ADJUSTMENT_TYPE | ● | Type of adjustment. | |
| DEBIT_CREDIT_FLAG | ● | Indicator (Y/N) for the debit credit. | |
| DEPRN_OVERRIDE_FLAG | ● | Indicator (Y/N) for the deprn override. | |
| SOURCE_DEST_CODE | ● | Code identifying the source dest. | |
| SOURCE_TYPE_CODE | ● | Code identifying the source type. | |
| TRACK_MEMBER_FLAG | ● | Indicator (Y/N) for the track member. | |
| TRANSACTION_HEADER_ID | ● | Identifier for the transaction header. |
4 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_ADJUSTMENTS.
- Asset Addition and Cost Adjustment Report
- Asset Reclassification Reconciliation Report
- Cost Adjustments Report
- Reserve Adjustments 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.
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Transactions Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for FA_ADJUSTMENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table