Oracle Fusion · Data dictionary
FA_ADJUSTMENTS
Fixed AssetsUsed in 3 subject areas8 reporting columns
Fixed Assets (FA).
Primary key: ADJUSTMENT_LINE_ID
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.