Oracle Fusion · Data dictionary
FA_TRANSACTION_HEADERS
Fixed AssetsUsed in 5 subject areas7 reporting columns
Fixed Assets (FA) — header table — one row per transaction or event (with detail in the paired _LINES table).
Primary key: TRANSACTION_HEADER_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMORTIZATION_START_DATE | ● | Amortization start date. | |
| SOURCE_TRANSACTION_HEADER_ID | ● | Identifier for the source transaction header. | |
| TRANSACTION_HEADER_ID | PK | ● | Identifier for the transaction header. |
| TRANSACTION_KEY | ● | Transaction key. | |
| TRANSACTION_NAME | ● | Name of the transaction. | |
| TRANSACTION_SUBTYPE | ● | Transaction subtype. | |
| TRANSACTION_TYPE_CODE | ● | Code identifying the transaction type. |
7 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_TRANSACTION_HEADERS.
- Asset Accounting and Location Report
- Asset Audit History Detail Report
- Asset Category Exceptions Report
- Asset Retirements Report
- Asset Register Report
- Asset Reclassification Reconciliation Report
- Cost 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 Assignments Real Time
- Fixed Assets - Asset Financial Information Real Time
- 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_TRANSACTION_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.