Search Results fa_mass_reclass




Overview
Explore in AI Chat

Overview

The FA_MASS_RECLASS table is a core transaction table within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the primary repository for storing all requests for the mass reclassification of assets. The mass reclass process is a critical batch operation that allows users to change key asset attributes—such as category, location, or asset key—for a large number of assets simultaneously, based on defined selection criteria. This table holds the definition and parameters of each reclass request, acting as a staging and control point before the transaction is processed and posted to the primary asset transaction tables. Its role is essential for maintaining audit trails and ensuring data integrity during bulk asset modifications.

Key Information Stored

The table's structure captures the complete specification of a mass reclass request. Its primary key is MASS_RECLASS_ID, which uniquely identifies each request. Critical columns define the scope and target of the reclassification: FROM_ASSET_NUMBER and TO_ASSET_NUMBER can define an asset range, while FROM_CATEGORY_ID and TO_CATEGORY_ID specify the source and destination asset categories. The BOOK_TYPE_CODE indicates the asset book for the transaction. The LOCATION_ID and ASSET_KEY_ID columns store the new location and asset key assignments. The CONCURRENT_REQUEST_ID links the request to the Oracle Concurrent Manager job that executes it, enabling users to monitor the request's status. Additional columns typically track the request's status, creation date, and the user who submitted it.

Common Use Cases and Queries

The primary use case is generating reports on pending or historical mass reclass jobs for audit or troubleshooting purposes. A common query involves joining with FA_ADDITIONS_B and FA_CATEGORIES_B to translate IDs into meaningful names. For example, to review recent reclass requests:

  • SELECT fmr.MASS_RECLASS_ID, fmr.BOOK_TYPE_CODE, fc1.SEGMENT1 AS FROM_CAT, fc2.SEGMENT1 AS TO_CAT, fmr.CREATION_DATE FROM FA.FA_MASS_RECLASS fmr, FA.FA_CATEGORIES_B fc1, FA.FA_CATEGORIES_B fc2 WHERE fmr.FROM_CATEGORY_ID = fc1.CATEGORY_ID (+) AND fmr.TO_CATEGORY_ID = fc2.CATEGORY_ID (+) ORDER BY fmr.CREATION_DATE DESC;

Technical support often queries this table to investigate failed or incomplete concurrent requests by joining with FND_CONCURRENT_REQUESTS. Developers may also reference it when writing custom interfaces or extensions that need to log or verify mass reclass transactions initiated outside the standard forms.

Related Objects

As indicated by its foreign keys, FA_MASS_RECLASS has strong relationships with several fundamental Fixed Assets tables. It references FA_ADDITIONS_B for asset numbers, FA_CATEGORIES_B for categories, FA_BOOK_CONTROLS for the book, FA_LOCATIONS for the location, and FA_ASSET_KEYWORDS for the asset key. The link to FND_CONCURRENT_REQUESTS provides the execution context. A key dependent object is the FA_MASS_RECLASS_ITF (Interface) table, which holds the detailed list of individual assets selected for a given mass reclass request, as defined by the parent record in FA_MASS_RECLASS. This relationship is governed by the foreign key from FA_MASS_RECLASS_ITF.MASS_RECLASS_ID to FA_MASS_RECLASS.MASS_RECLASS_ID.

  • 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_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_ASSET_KEYWORDS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_KEYWORDS,  object_name:FA_ASSET_KEYWORDS,  status:VALID,  product: OFA - Assets ,  description: Asset key flexfield segment combinations ,  implementation_dba_data: FA.FA_ASSET_KEYWORDS , 

  • Table: FA_ASSET_KEYWORDS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_KEYWORDS,  object_name:FA_ASSET_KEYWORDS,  status:VALID,  product: OFA - Assets ,  description: Asset key flexfield segment combinations ,  implementation_dba_data: FA.FA_ASSET_KEYWORDS , 

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

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID,  product: OFA - Assets ,  description: Location flexfield segment value combinations ,  implementation_dba_data: FA.FA_LOCATIONS , 

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

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID,  product: OFA - Assets ,  description: Location flexfield segment value combinations ,  implementation_dba_data: FA.FA_LOCATIONS , 

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

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