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