Oracle Fusion · Data dictionary
FA_METHODS
Fixed AssetsUsed in 2 subject areas8 reporting columns
Fixed Assets (FA).
Primary key: METHOD_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DEPRN_BASIS_RULE | ● | Deprn basis rule. | |
| EXCLUDE_SALVAGE_VALUE_FLAG | ● | Indicator (Y/N) for the exclude salvage value. | |
| LIFE_IN_MONTHS | ● | Life in months. | |
| METHOD_CODE | ● | Code identifying the method. | |
| METHOD_ID | PK | ○ | Identifier for the method. |
| NAME | ● | Name. | |
| RATE_SOURCE_RULE | ● | Rate source rule. | |
| STL_METHOD_FLAG | ● | Indicator (Y/N) for the stl method. | |
| USE_LIFE_IN_PERIODS_FLAG | ● | Indicator (Y/N) for the use life in periods. |
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_METHODS.
- Asset Category Book Report
- Asset Accounting and Location Report
- Asset Audit History Detail Report
- Asset Category Exceptions 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 Financial Information Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
Need the extract + dbt staging for FA_METHODS?
We ship parameterized SQL, BICC config, and dbt models you own.