Search Results fa_mass_retirements




Overview
Explore in AI Chat

Overview

The FA_MASS_RETIREMENTS table is a core transactional table within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the primary repository for tracking and managing mass retirement and mass reinstatement processes. These processes allow for the bulk retirement or reinstatement of assets based on defined criteria, such as asset number ranges, categories, or locations, rather than handling assets individually. The table is essential for maintaining an audit trail of these bulk operations, storing the parameters used for the run, the concurrent request IDs for execution, and the overall status of each mass transaction. Its role is critical for ensuring data integrity and providing a historical record of significant asset lifecycle events in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is MASS_RETIREMENT_ID, which uniquely identifies each mass retirement or reinstatement job. Key columns define the scope and status of the operation. The BOOK_TYPE_CODE links the transaction to a specific asset book. Criteria-defining columns include FROM_ASSET_NUMBER and TO_ASSET_NUMBER for specifying a range, and CATEGORY_ID and LOCATION_ID for filtering by category or location. For project-related retirements, PROJECT_ID and TASK_ID are used. The table tracks the execution via several foreign keys to FND_CONCURRENT_REQUESTS: CREATE_REQUEST_ID for the initial creation job, RETIRE_REQUEST_ID for the retirement process itself, and REINSTATE_REQUEST_ID for any subsequent reinstatement. Additional columns store the effective retirement date, retirement type (e.g., 'RETIREMENT', 'REINSTATEMENT'), and the total cost retired.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting mass retirement runs. A common query retrieves details of a specific run to verify parameters and status.

  • Audit a Specific Mass Retirement: SELECT mass_retirement_id, book_type_code, from_asset_number, to_asset_number, retirement_type, effective_retirement_date, retire_request_id FROM fa_mass_retirements WHERE mass_retirement_id = :p_mass_ret_id;
  • Find Mass Retirements for a Book: SELECT mass_retirement_id, creation_date, created_by, retire_request_id FROM fa_mass_retirements WHERE book_type_code = :p_book_code ORDER BY creation_date DESC;
  • Link to Concurrent Request Details: Reports often join this table to FND_CONCURRENT_REQUESTS to get the request status and completion details: SELECT fmr.*, fcr.request_date, fcr.completion_text FROM fa_mass_retirements fmr, fnd_concurrent_requests fcr WHERE fmr.retire_request_id = fcr.request_id AND fcr.phase_code = 'C';

Related Objects

As indicated by its foreign keys, FA_MASS_RETIREMENTS has significant relationships with other core Fixed Assets and EBS tables. It is directly linked to FA_BOOK_CONTROLS for the book definition and to FA_ADDITIONS_B for the asset number range. Filtering criteria are enforced via links to FA_CATEGORIES_B and FA_LOCATIONS. For Project Accounting integration, it references PA_PROJECTS_ALL and PA_TASKS. Crucially, its execution lifecycle is managed through multiple references to FND_CONCURRENT_REQUESTS. Downstream, the detailed results of the mass retirement—the individual asset transactions—are stored in tables like FA_RETIREMENTS and FA_ADJUSTMENTS, which are populated based on the master record created in FA_MASS_RETIREMENTS.

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

  • View: FA_RETIREMENT_REQUESTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RETIREMENT_REQUESTS_V,  object_name:FA_RETIREMENT_REQUESTS_V,  status:VALID,  product: OFA - Assets ,  description: This view displays Mass Retirements and its effect on the performed retirement transaction ,  implementation_dba_data: APPS.FA_RETIREMENT_REQUESTS_V , 

  • View: FA_RETIREMENT_REQUESTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RETIREMENT_REQUESTS_V,  object_name:FA_RETIREMENT_REQUESTS_V,  status:VALID,  product: OFA - Assets ,  description: This view displays Mass Retirements and its effect on the performed retirement transaction ,  implementation_dba_data: APPS.FA_RETIREMENT_REQUESTS_V , 

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