Search Results fa_categories_b




Overview
Explore in AI Chat

Overview

The FA_CATEGORIES_B table is a core master data table within the Oracle E-Business Suite Fixed Assets (OFA) module. It serves as the base table for storing default financial information for asset categories. As a Multi-Language Support (MLS) base table, it holds the language-independent data, while its corresponding translation table (FA_CATEGORIES_TL) stores the language-specific descriptions. Asset categories are a fundamental classification mechanism in Fixed Assets, grouping assets with similar characteristics, such as computers, vehicles, or machinery, to streamline accounting rules, depreciation methods, and reporting. This table is the primary source for defining these categories and their default accounting behavior.

Key Information Stored

The primary identifier for a category is the CATEGORY_ID, which is the table's primary key. While the provided metadata does not list all columns, based on its role as the category definition table, it typically stores critical default financial and control attributes. These commonly include the segment-separated category key, the associated asset cost account, depreciation expense account, accumulated depreciation account, and the category type (e.g., CAPITALIZED, EXPENSED). The table also defines default rules for prorate conventions, depreciation methods, and life calculations that can be inherited by assets assigned to the category, ensuring consistent accounting treatment.

Common Use Cases and Queries

This table is central to asset setup, transaction processing, and reporting. Common operational and reporting queries involve joining FA_CATEGORIES_B to asset transaction tables to analyze assets by category. For instance, to report all capitalized assets with their category details, a typical query would join to FA_ADDITIONS_B. Sample SQL patterns include retrieving a list of all active categories or analyzing default account flexfields by category for reconciliation purposes. The table is also critical for mass transaction processes, such as mass additions, mass changes, and mass reclassifications, where the category ID is used to identify groups of assets for bulk processing, as evidenced by the numerous foreign key relationships from transaction interface and processing tables.

Related Objects

FA_CATEGORIES_B is a highly referenced master table. Its primary key, CATEGORY_ID, is a foreign key in numerous critical transaction and setup tables. Key related objects include:

  • FA_ADDITIONS_B: Links an asset to its category via ASSET_CATEGORY_ID.
  • FA_CATEGORY_BOOKS: Stores category-specific depreciation rules for each asset book.
  • FA_MASS_ADDITIONS & FA_MASS_CHANGES: Reference the category for processing batched transactions.
  • FA_ASSET_HISTORY: Tracks historical changes to an asset's category.
  • MTL_SYSTEM_ITEMS_B: Links inventory items to an asset category for automatic asset creation.
  • Translation Table: FA_CATEGORIES_TL, which stores the translated category name and description.
These relationships underscore the table's integral role in ensuring data integrity and enforcing business rules across the Fixed Assets lifecycle.

  • Table: FA_CATEGORIES_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_CATEGORIES_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_MASS_RECLASS 12.2.2

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

  • Table: FA_MASS_RECLASS 12.1.1

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

  • Table: FA_MASS_REVALUATION_RULES 12.1.1

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

  • Table: FA_BUDGET_DISTRIBUTION 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BUDGET_DISTRIBUTION,  object_name:FA_BUDGET_DISTRIBUTION,  status:VALID,  product: OFA - Assets ,  description: Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table ,  implementation_dba_data: FA.FA_BUDGET_DISTRIBUTION , 

  • Table: FA_BUDGET_DISTRIBUTION 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BUDGET_DISTRIBUTION,  object_name:FA_BUDGET_DISTRIBUTION,  status:VALID,  product: OFA - Assets ,  description: Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table ,  implementation_dba_data: FA.FA_BUDGET_DISTRIBUTION , 

  • Table: FA_MASS_REVALUATION_RULES 12.2.2

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

  • Table: FA_MASS_TRANSFERS 12.2.2

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

  • Table: FA_MAINT_SCHEDULE_HDR 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MAINT_SCHEDULE_HDR,  object_name:FA_MAINT_SCHEDULE_HDR,  status:VALID,  product: OFA - Assets ,  description: Stores information about maintenance scheduling requests ,  implementation_dba_data: FA.FA_MAINT_SCHEDULE_HDR , 

  • Table: FA_ASSET_HISTORY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_HISTORY,  object_name:FA_ASSET_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Historical information about asset reclassifications and unit adjustments ,  implementation_dba_data: FA.FA_ASSET_HISTORY , 

  • Table: FA_ASSET_HISTORY 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_HISTORY,  object_name:FA_ASSET_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Historical information about asset reclassifications and unit adjustments ,  implementation_dba_data: FA.FA_ASSET_HISTORY , 

  • Table: FA_MASS_REVAL_REP_ITF 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_REVAL_REP_ITF,  object_name:FA_MASS_REVAL_REP_ITF,  status:VALID,  product: OFA - Assets ,  description: Interface table for Mass Revaluation reports ,  implementation_dba_data: FA.FA_MASS_REVAL_REP_ITF , 

  • Table: FA_MASS_REVAL_REP_ITF 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_REVAL_REP_ITF,  object_name:FA_MASS_REVAL_REP_ITF,  status:VALID,  product: OFA - Assets ,  description: Interface table for Mass Revaluation reports ,  implementation_dba_data: FA.FA_MASS_REVAL_REP_ITF , 

  • Table: FA_MASS_TRANSFERS 12.1.1

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

  • Table: FA_MAINT_SCHEDULE_HDR 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MAINT_SCHEDULE_HDR,  object_name:FA_MAINT_SCHEDULE_HDR,  status:VALID,  product: OFA - Assets ,  description: Stores information about maintenance scheduling requests ,  implementation_dba_data: FA.FA_MAINT_SCHEDULE_HDR , 

  • Table: FA_PARALLEL_WORKERS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_PARALLEL_WORKERS,  object_name:FA_PARALLEL_WORKERS,  status:VALID,  product: OFA - Assets ,  description: Used to control concurrent execution of post mass additions program. ,  implementation_dba_data: FA.FA_PARALLEL_WORKERS , 

  • 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_PARALLEL_WORKERS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_PARALLEL_WORKERS,  object_name:FA_PARALLEL_WORKERS,  status:VALID,  product: OFA - Assets ,  description: Used to control concurrent execution of post mass additions program. ,  implementation_dba_data: FA.FA_PARALLEL_WORKERS , 

  • Table: FA_MASS_RETIREMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_RETIREMENTS,  object_name:FA_MASS_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: FA_MASS_RETIREMENT contains information about your mass retirement and mass reinstatement processes. ,  implementation_dba_data: FA.FA_MASS_RETIREMENTS , 

  • 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_MASS_RETIREMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_RETIREMENTS,  object_name:FA_MASS_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: FA_MASS_RETIREMENT contains information about your mass retirement and mass reinstatement processes. ,  implementation_dba_data: FA.FA_MASS_RETIREMENTS , 

  • Table: FA_CATEGORY_BOOKS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORY_BOOKS,  object_name:FA_CATEGORY_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Default financial information for an asset category and depreciation book combination ,  implementation_dba_data: FA.FA_CATEGORY_BOOKS , 

  • 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_CATEGORY_BOOKS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORY_BOOKS,  object_name:FA_CATEGORY_BOOKS,  status:VALID,  product: OFA - Assets ,  description: Default financial information for an asset category and depreciation book combination ,  implementation_dba_data: FA.FA_CATEGORY_BOOKS , 

  • View: FA_ASSET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ASSET_V,  object_name:FA_ASSET_V,  status:VALID,  product: OFA - Assets ,  description: Asset identification and financial information ,  implementation_dba_data: APPS.FA_ASSET_V , 

  • View: FA_ASSET_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ASSET_V,  object_name:FA_ASSET_V,  status:VALID,  product: OFA - Assets ,  description: Asset identification and financial information ,  implementation_dba_data: APPS.FA_ASSET_V , 

  • Table: FA_MASS_ADDITIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_ADDITIONS,  object_name:FA_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Information about assets that you want to automatically add to Oracle Assets from another system ,  implementation_dba_data: FA.FA_MASS_ADDITIONS , 

  • Table: FA_MASS_ADDITIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_ADDITIONS,  object_name:FA_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Information about assets that you want to automatically add to Oracle Assets from another system ,  implementation_dba_data: FA.FA_MASS_ADDITIONS , 

  • View: FA_ASSET_INVOICES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ASSET_INVOICES_V,  object_name:FA_ASSET_INVOICES_V,  status:VALID,  product: OFA - Assets ,  description: Business view of asset identification, financial, and purchasing information ,  implementation_dba_data: APPS.FA_ASSET_INVOICES_V , 

  • View: FA_ASSET_INVOICES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ASSET_INVOICES_V,  object_name:FA_ASSET_INVOICES_V,  status:VALID,  product: OFA - Assets ,  description: Business view of asset identification, financial, and purchasing information ,  implementation_dba_data: APPS.FA_ASSET_INVOICES_V , 

  • View: FA_CATEGORIES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_CATEGORIES_VL,  object_name:FA_CATEGORIES_VL,  status:VALID,  product: OFA - Assets ,  implementation_dba_data: APPS.FA_CATEGORIES_VL , 

  • View: FA_CATEGORIES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_CATEGORIES_VL,  object_name:FA_CATEGORIES_VL,  status:VALID,  product: OFA - Assets ,  implementation_dba_data: APPS.FA_CATEGORIES_VL , 

  • View: FA_LEASES_WEB_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_LEASES_WEB_V,  object_name:FA_LEASES_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Information about leases assigned to assets ,  implementation_dba_data: APPS.FA_LEASES_WEB_V , 

  • View: FA_LEASES_WEB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_LEASES_WEB_V,  object_name:FA_LEASES_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Information about leases assigned to assets ,  implementation_dba_data: APPS.FA_LEASES_WEB_V , 

  • View: FA_ASSET_DISTRIBUTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ASSET_DISTRIBUTION_V,  object_name:FA_ASSET_DISTRIBUTION_V,  status:VALID,  product: OFA - Assets ,  description: Asset Identification and Distribution ,  implementation_dba_data: APPS.FA_ASSET_DISTRIBUTION_V , 

  • View: FA_ASSET_DISTRIBUTION_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ASSET_DISTRIBUTION_V,  object_name:FA_ASSET_DISTRIBUTION_V,  status:VALID,  product: OFA - Assets ,  description: Asset Identification and Distribution ,  implementation_dba_data: APPS.FA_ASSET_DISTRIBUTION_V , 

  • View: FA_TRANS_HIST_TRX_WEB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_TRANS_HIST_TRX_WEB_V,  object_name:FA_TRANS_HIST_TRX_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Asset transaction history for all books ,  implementation_dba_data: APPS.FA_TRANS_HIST_TRX_WEB_V , 

  • View: FA_ADD_INVOICE_WEB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ADD_INVOICE_WEB_V,  object_name:FA_ADD_INVOICE_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Invoice information pertaining to the asset ,  implementation_dba_data: APPS.FA_ADD_INVOICE_WEB_V , 

  • View: FA_TRANS_HIST_TRX_WEB_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_TRANS_HIST_TRX_WEB_V,  object_name:FA_TRANS_HIST_TRX_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Asset transaction history for all books ,  implementation_dba_data: APPS.FA_TRANS_HIST_TRX_WEB_V , 

  • View: FA_ADD_INVOICE_WEB_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ADD_INVOICE_WEB_V,  object_name:FA_ADD_INVOICE_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Invoice information pertaining to the asset ,  implementation_dba_data: APPS.FA_ADD_INVOICE_WEB_V , 

  • View: FA_ADDITIONS_WEB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ADDITIONS_WEB_V,  object_name:FA_ADDITIONS_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Contains asset identification information ,  implementation_dba_data: APPS.FA_ADDITIONS_WEB_V , 

  • View: FA_ADDITIONS_WEB_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ADDITIONS_WEB_V,  object_name:FA_ADDITIONS_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Contains asset identification information ,  implementation_dba_data: APPS.FA_ADDITIONS_WEB_V , 

  • Table: FA_ADDITIONS_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • Table: FA_ADDITIONS_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • View: FA_ADDITIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ADDITIONS_V,  object_name:FA_ADDITIONS_V,  status:VALID,  product: OFA - Assets ,  implementation_dba_data: APPS.FA_ADDITIONS_V , 

  • View: FA_ADDITIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_ADDITIONS_V,  object_name:FA_ADDITIONS_V,  status:VALID,  product: OFA - Assets ,  implementation_dba_data: APPS.FA_ADDITIONS_V , 

  • View: FA_RETIRED_ASSET_WEB_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RETIRED_ASSET_WEB_V,  object_name:FA_RETIRED_ASSET_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Information about retired assets ,  implementation_dba_data: APPS.FA_RETIRED_ASSET_WEB_V , 

  • View: FA_RETIRED_ASSET_WEB_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RETIRED_ASSET_WEB_V,  object_name:FA_RETIRED_ASSET_WEB_V,  status:VALID,  product: OFA - Assets ,  description: Information about retired assets ,  implementation_dba_data: APPS.FA_RETIRED_ASSET_WEB_V ,