Oracle Fusion · Data dictionary
FA_ADDITIONS_B
Fixed AssetsUsed in 9 subject areas15 reporting columns
Fixed Assets (FA) — the asset master. One row per asset.
Primary key: ASSET_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSET_ID | PK | ○ | Identifier for the asset. |
| ASSET_NUMBER | ● | Asset number. | |
| ASSET_TYPE | ● | Type of asset. | |
| COMMITMENT | ● | Commitment. | |
| CURRENT_UNITS | ● | Current units. | |
| INVENTORIAL | ● | Inventorial. | |
| INVESTMENT_LAW | ● | Investment law. | |
| IN_USE_FLAG | ● | Indicator (Y/N) for the in use. | |
| MANUFACTURER_NAME | ● | Name of the manufacturer. | |
| MODEL_NUMBER | ● | Model number. | |
| NEW_USED | ● | New used. | |
| OWNED_LEASED | ● | Owned leased. | |
| PROPERTY_1245_1250_CODE | ● | Code identifying the property 1245 1250. | |
| PROPERTY_TYPE_CODE | ● | Code identifying the property type. | |
| SERIAL_NUMBER | ● | Serial number. | |
| TAG_NUMBER | ● | Tag number. |
15 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_ADDITIONS_B.
- Asset Addition and Cost Adjustment Report
- Asset Audit History Detail Report
- Asset Category Exceptions Report
- Asset Retirements Report
- FA to GL Reconciliation Report
- Quarterly CIP FA by Project Report
- Asset Register Report
- Asset Additions Report
- Asset Additions by Cost Center Report
- Asset Additions by Source Report
- Cost Detail Report
- Cost Summary Report
- CIP Detail Report
- CIP Summary Report
- Mass Additions 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 Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Financial Information Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Source Lines Real Time
- Fixed Assets - Asset Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for FA_ADDITIONS_B?
We ship parameterized SQL, BICC config, and dbt models you own.