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