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, BOOK_TYPE_CODE (Oracle's FA_DISTRIBUTION_HISTORY_PK)
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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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