Oracle Fusion · Data dictionary
FA_DISTRIBUTION_HISTORY
Fixed AssetsUsed in 2 subject areas6 reporting columns
Fixed Assets (FA) — asset distribution history. How an asset is split across expense accounts / cost centers / employees over time.
Primary key: DISTRIBUTION_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DATE_INEFFECTIVE | ● | Date ineffective. | |
| DISTRIBUTION_ID | PK | ○ | Identifier for the distribution. |
| RETIREMENT_ID | ● | Identifier for the retirement. | |
| TRANSACTION_HEADER_ID_IN | ● | Transaction header id in. | |
| TRANSACTION_HEADER_ID_OUT | ● | Transaction header id out. | |
| TRANSACTION_UNITS | ● | Transaction units. | |
| UNITS_ASSIGNED | ● | Units assigned. |
5 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_DISTRIBUTION_HISTORY.
- FA to GL Reconciliation Report
- Asset Additions Report
- Asset Additions by Cost Center Report
- Asset Transfers Report
- Cost Detail 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 Retirements and Reinstatements Real Time
Need the extract + dbt staging for FA_DISTRIBUTION_HISTORY?
We ship parameterized SQL, BICC config, and dbt models you own.