Oracle Fusion · Data dictionary
FA_CATEGORIES_B
Fixed AssetsUsed in 10 subject areas5 reporting columns
Fixed Assets (FA) — asset category master (controls default accounts and depreciation rules).
Primary key: CATEGORY_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CAPITALIZE_FLAG | ● | Indicator (Y/N) for the capitalize. | |
| CATEGORY_ID | PK | ○ | Identifier for the category. |
| CATEGORY_TYPE | ● | Type of category. | |
| OWNED_LEASED | ● | Owned leased. | |
| PROPERTY_1245_1250_CODE | ● | Code identifying the property 1245 1250. | |
| PROPERTY_TYPE_CODE | ● | Code identifying the property type. |
11 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_CATEGORIES_B.
- Asset Category Book Report
- Asset Addition and Cost Adjustment Report
- Asset Category Exceptions Report
- Asset Register Report
- Reserve Detail Report
- Journal Entry Reserve Ledger Report
- Asset Additions Report
- Asset Reclassification Reconciliation Report
- Cost Detail Report
- CIP Detail Report
- What-If Depreciation Analysis 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 Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Procurement - Spend Real Time
Need the extract + dbt staging for FA_CATEGORIES_B?
We ship parameterized SQL, BICC config, and dbt models you own.