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