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.
Problems that run through this table