Search Results fa_methods




Overview
Explore in AI Chat

Overview

The FA_METHODS table is a core reference table within the Oracle E-Business Suite Fixed Assets (OFA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for all valid depreciation and short tax life (STL) methods available for asset accounting. This table is fundamental to the system's configuration, defining the permissible combinations of depreciation calculation logic (method) and asset useful life. It enforces data integrity across the application by being referenced extensively by transactional and setup tables, ensuring that depreciation rules applied to assets are predefined and consistent.

Key Information Stored

The table's structure centers on the unique identification of a method and life combination. Its primary key is METHOD_ID, a system-generated unique identifier. A critical unique key constraint exists on the combination of METHOD_CODE and LIFE_IN_MONTHS, which is the business key used throughout the application. The METHOD_CODE column stores the depreciation method type, such as 'STL', 'FLAT RATE', or 'FORMULA'. The LIFE_IN_MONTHS column stores the asset's useful life duration. While the provided metadata does not list all columns, typical columns in this table would include flags for method attributes (e.g., prorate convention, ceiling name) and descriptive fields. The foreign key relationships documented show that dependent tables store the METHOD_CODE and LIFE_IN_MONTHS pair to link back to this master definition.

Common Use Cases and Queries

This table is primarily queried for setup validation, reporting, and data analysis. Common scenarios include validating asset book setup, analyzing depreciation policies across asset categories, and troubleshooting data issues. A frequent query is to list all available method and life combinations for a given method type, which is essential during asset book or category default configuration. For example:

  • SELECT method_code, life_in_months FROM fa_methods WHERE method_code = 'STL' ORDER BY life_in_months;

Another critical use case is identifying assets using a specific depreciation rule, often required for impact analysis before changing system setups. A join to the FA_BOOKS table would be used:

  • SELECT ab.asset_id, ab.book_type_code FROM fa_books ab, fa_methods fm WHERE ab.deprn_method_code = fm.method_code AND ab.life_in_months = fm.life_in_months AND fm.method_code = 'FLAT RATE';

Related Objects

As indicated by the extensive foreign key relationships in the metadata, FA_METHODS is a pivotal parent table. Key dependent objects include FA_BOOKS, which links the depreciation method to each asset in a book, and FA_CATEGORY_BOOK_DEFAULTS, which defines default methods for asset categories. It is also referenced by FA_RETIREMENTS and FA_MC_RETIREMENTS for short tax life methods on retirement, and by FA_MASS_CHANGES for processing mass transactions. Other important related tables are FA_FORMULAS and FA_RATES, which store detailed calculation parameters linked via METHOD_ID, and FA_TAX_INTERFACE for tax reporting. This wide network of dependencies underscores the table's role as a cornerstone of the Fixed Assets depreciation engine.

  • Table: FA_METHODS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_METHODS,  object_name:FA_METHODS,  status:VALID,  product: OFA - Assets ,  description: Depreciation method information ,  implementation_dba_data: FA.FA_METHODS , 

  • Table: FA_METHODS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_METHODS,  object_name:FA_METHODS,  status:VALID,  product: OFA - Assets ,  description: Depreciation method information ,  implementation_dba_data: FA.FA_METHODS , 

  • Table: FA_CATEGORY_BOOK_DEFAULTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORY_BOOK_DEFAULTS,  object_name:FA_CATEGORY_BOOK_DEFAULTS,  status:VALID,  product: OFA - Assets ,  description: Default depreciation rules for asset category and book combination for a particular date placed in service range ,  implementation_dba_data: FA.FA_CATEGORY_BOOK_DEFAULTS , 

  • Table: FA_CATEGORY_BOOK_DEFAULTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORY_BOOK_DEFAULTS,  object_name:FA_CATEGORY_BOOK_DEFAULTS,  status:VALID,  product: OFA - Assets ,  description: Default depreciation rules for asset category and book combination for a particular date placed in service range ,  implementation_dba_data: FA.FA_CATEGORY_BOOK_DEFAULTS , 

  • Table: FA_MASS_CHANGES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_CHANGES,  object_name:FA_MASS_CHANGES,  status:VALID,  product: OFA - Assets ,  description: Mass change request information ,  implementation_dba_data: FA.FA_MASS_CHANGES , 

  • Table: FA_MASS_CHANGES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_CHANGES,  object_name:FA_MASS_CHANGES,  status:VALID,  product: OFA - Assets ,  description: Mass change request information ,  implementation_dba_data: FA.FA_MASS_CHANGES , 

  • Table: FA_FORMULAS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_FORMULAS,  object_name:FA_FORMULAS,  status:VALID,  product: OFA - Assets ,  description: Depreciation rates for formula-based methods ,  implementation_dba_data: FA.FA_FORMULAS , 

  • Table: FA_RESERVE_LEDGER 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RESERVE_LEDGER,  object_name:FA_RESERVE_LEDGER,  status:VALID,  product: OFA - Assets ,  description: Temporary storage area for the reserve ledger reports ,  implementation_dba_data: FA.FA_RESERVE_LEDGER , 

  • Table: FA_RESERVE_LEDGER 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RESERVE_LEDGER,  object_name:FA_RESERVE_LEDGER,  status:VALID,  product: OFA - Assets ,  description: Temporary storage area for the reserve ledger reports ,  implementation_dba_data: FA.FA_RESERVE_LEDGER , 

  • Table: FA_TAX_INTERFACE 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_TAX_INTERFACE,  object_name:FA_TAX_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Tax Book Interface table ,  implementation_dba_data: FA.FA_TAX_INTERFACE , 

  • Table: FA_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RATES,  object_name:FA_RATES,  status:VALID,  product: OFA - Assets ,  description: Annual depreciation rates for life-based depreciation methods ,  implementation_dba_data: FA.FA_RATES , 

  • Table: FA_FLAT_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_FLAT_RATES,  object_name:FA_FLAT_RATES,  status:VALID,  product: OFA - Assets ,  description: Annual depreciation rates for all flat-rate methods ,  implementation_dba_data: FA.FA_FLAT_RATES , 

  • Table: FA_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RATES,  object_name:FA_RATES,  status:VALID,  product: OFA - Assets ,  description: Annual depreciation rates for life-based depreciation methods ,  implementation_dba_data: FA.FA_RATES , 

  • Table: FA_FORMULAS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_FORMULAS,  object_name:FA_FORMULAS,  status:VALID,  product: OFA - Assets ,  description: Depreciation rates for formula-based methods ,  implementation_dba_data: FA.FA_FORMULAS , 

  • Table: FA_ACE_BOOKS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ACE_BOOKS,  object_name:FA_ACE_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information for updating ACE book ,  implementation_dba_data: FA.FA_ACE_BOOKS , 

  • Table: FA_MASS_RECLASS_ITF 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_RECLASS_ITF,  object_name:FA_MASS_RECLASS_ITF,  status:VALID,  product: OFA - Assets ,  description: Interface table for Report eXchange reports ,  implementation_dba_data: FA.FA_MASS_RECLASS_ITF , 

  • Table: FA_FLAT_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_FLAT_RATES,  object_name:FA_FLAT_RATES,  status:VALID,  product: OFA - Assets ,  description: Annual depreciation rates for all flat-rate methods ,  implementation_dba_data: FA.FA_FLAT_RATES , 

  • Table: FA_ACE_BOOKS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ACE_BOOKS,  object_name:FA_ACE_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information for updating ACE book ,  implementation_dba_data: FA.FA_ACE_BOOKS , 

  • Table: FA_RETIREMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RETIREMENTS,  object_name:FA_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: Information about asset retirements and reinstatements ,  implementation_dba_data: FA.FA_RETIREMENTS , 

  • Table: FA_RETIREMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RETIREMENTS,  object_name:FA_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: Information about asset retirements and reinstatements ,  implementation_dba_data: FA.FA_RETIREMENTS , 

  • Table: FA_TAX_INTERFACE 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_TAX_INTERFACE,  object_name:FA_TAX_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Tax Book Interface table ,  implementation_dba_data: FA.FA_TAX_INTERFACE , 

  • Table: FA_MASS_RECLASS_ITF 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_RECLASS_ITF,  object_name:FA_MASS_RECLASS_ITF,  status:VALID,  product: OFA - Assets ,  description: Interface table for Report eXchange reports ,  implementation_dba_data: FA.FA_MASS_RECLASS_ITF , 

  • Table: FA_MC_RETIREMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_RETIREMENTS,  object_name:FA_MC_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: Currency and financial information about retirements in each reporting book ,  implementation_dba_data: FA.FA_MC_RETIREMENTS , 

  • Table: FA_MC_RETIREMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_RETIREMENTS,  object_name:FA_MC_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: Currency and financial information about retirements in each reporting book ,  implementation_dba_data: FA.FA_MC_RETIREMENTS , 

  • Table: FA_BOOKS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOKS,  object_name:FA_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information of each asset ,  implementation_dba_data: FA.FA_BOOKS , 

  • Table: FA_MC_BOOKS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_BOOKS,  object_name:FA_MC_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information for each asset in the reporting currency ,  implementation_dba_data: FA.FA_MC_BOOKS , 

  • Table: FA_BOOKS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOKS,  object_name:FA_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information of each asset ,  implementation_dba_data: FA.FA_BOOKS , 

  • Table: FA_MC_BOOKS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_BOOKS,  object_name:FA_MC_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Financial information for each asset in the reporting currency ,  implementation_dba_data: FA.FA_MC_BOOKS , 

  • View: FA_BOOKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_BOOKS_V,  object_name:FA_BOOKS_V,  status:VALID,  product: OFA - Assets ,  description: Selects active financial information for an asset in a given book ,  implementation_dba_data: APPS.FA_BOOKS_V , 

  • View: FA_BOOKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_BOOKS_V,  object_name:FA_BOOKS_V,  status:VALID,  product: OFA - Assets ,  description: Selects active financial information for an asset in a given book ,  implementation_dba_data: APPS.FA_BOOKS_V ,