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