Search Results fa_mass_changes




Overview
Explore in AI Chat

Overview

The FA_MASS_CHANGES table is a core transactional table within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the central repository for storing the definition and status of mass change requests. A mass change is a critical business process that allows for the bulk modification of asset attributes—such as depreciation method, life, or category—across a defined range of assets. This table holds the request parameters before they are processed by a concurrent program, enabling efficient, batch-level updates to asset accounting rules and classifications, which is essential for managing large asset portfolios and implementing accounting policy changes.

Key Information Stored

The table's primary key is MASS_CHANGE_ID, which uniquely identifies each mass change request. Critical columns define the scope and nature of the change. These include BOOK_TYPE_CODE to specify the asset book, and FROM_ASSET_NUMBER/TO_ASSET_NUMBER or FROM_GROUP_ASSET_ID/TO_GROUP_ASSET_ID to define the asset range. The table stores both the original (FROM) and target (TO) values for key attributes, such as METHOD_CODE, LIFE_IN_MONTHS, CONVENTION, and CATEGORY_ID. Status and control are managed via columns like CONCURRENT_REQUEST_ID, which links to the FND_CONCURRENT_REQUESTS table to track the execution of the mass change job, and a STATUS column (implied by standard practice, though not explicitly listed).

Common Use Cases and Queries

The primary use case is the creation, review, and audit of mass change operations. Common queries involve identifying pending or processed requests, verifying the parameters of a specific change, or troubleshooting failed concurrent requests. For example, to review all mass changes for a specific book, a query would join to FA_BOOK_CONTROLS. To see which assets were affected by a completed change, one would join the FA_MASS_CHANGES_ITF interface table. A typical reporting query might be:

  • SELECT fmc.mass_change_id, fmc.book_type_code, fmc.from_method_code, fmc.to_method_code, fcr.request_id, fcr.status_code FROM fa_mass_changes fmc, fnd_concurrent_requests fcr WHERE fmc.concurrent_request_id = fcr.request_id AND fmc.book_type_code = 'CORP';

Related Objects

FA_MASS_CHANGES has integral relationships with numerous other Fixed Assets tables, as documented by its foreign keys. It is a parent to the FA_MASS_CHANGES_ITF table via MASS_CHANGE_ID, which holds the detailed list of assets selected for the change. It references master and control tables to validate input: FA_BOOK_CONTROLS (BOOK_TYPE_CODE), FA_ADDITIONS_B (FROM/TO_ASSET_NUMBER, FROM/TO_GROUP_ASSET_ID), FA_METHODS (FROM/TO_METHOD_CODE with life), FA_CONVENTION_TYPES (FROM/TO_CONVENTION), and FA_CATEGORIES_B (CATEGORY_ID). The link to FND_CONCURRENT_REQUESTS (CONCURRENT_REQUEST_ID) integrates the request with the EBS concurrent manager framework for processing.

  • 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_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_CONVENTION_TYPES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CONVENTION_TYPES,  object_name:FA_CONVENTION_TYPES,  status:VALID,  product: OFA - Assets ,  description: Names and descriptions for prorate conventions ,  implementation_dba_data: FA.FA_CONVENTION_TYPES , 

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

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CONVENTION_TYPES,  object_name:FA_CONVENTION_TYPES,  status:VALID,  product: OFA - Assets ,  description: Names and descriptions for prorate conventions ,  implementation_dba_data: FA.FA_CONVENTION_TYPES , 

  • 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 , 

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

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

  • Table: FA_MASS_CHANGES_ITF 12.2.2

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

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

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS , 

  • Table: FA_BOOK_CONTROLS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS ,