Search Results fa_mass_reclass_itf




Overview
Explore in AI Chat

Overview

The FA_MASS_RECLASS_ITF table is a core interface table within the Oracle E-Business Suite Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to serve as the staging and data transfer mechanism for the Report eXchange (RX) reporting framework. This table facilitates the bulk processing of asset reclassification data, enabling users to generate and review detailed reports on proposed mass asset reclassifications before final posting to the primary asset transaction tables. It acts as a critical intermediary, ensuring data integrity and auditability during complex asset accounting operations.

Key Information Stored

The table stores transactional data required to process and report on mass asset reclassifications. Key columns, as indicated by its foreign key relationships, include identifiers for the asset and the reclassification batch, along with the proposed accounting changes. Essential columns are MASS_RECLASS_ID, which links to the parent reclassification batch; ASSET_ID and ASSET_NUMBER, identifying the specific asset; and BOOK, specifying the asset book. The table also holds columns for proposed new depreciation rules, such as METHOD, CONVENTION, and CEILING. The REQUEST_ID column links the interface data to a specific concurrent request, providing process tracking and lifecycle management within the EBS environment.

Common Use Cases and Queries

The primary use case is the generation and validation of the Mass Reclassification Report via the Report eXchange process. Data is populated into this interface table by the relevant reclassification program, after which reports can be run to review the proposed changes. Common queries involve checking the status of records for a specific reclassification batch or identifying records with potential data issues before final submission. A typical validation query would join to master tables to ensure referential integrity.

  • Reviewing pending interface records for a batch: SELECT * FROM fa_mass_reclass_itf WHERE mass_reclass_id = :p_batch_id AND request_id = :p_request_id;
  • Validating interface data against master tables: SELECT itf.rowid, itf.* FROM fa_mass_reclass_itf itf WHERE NOT EXISTS (SELECT 1 FROM fa_additions_b fa WHERE fa.asset_id = itf.asset_id) AND itf.request_id = :p_req_id;

Related Objects

FA_MASS_RECLASS_ITF has defined foreign key relationships with several key Fixed Assets tables, as documented in the ETRM metadata. These relationships are fundamental for data validation and process flow.

  • FA_MASS_RECLASS: Linked via MASS_RECLASS_ID. This is the parent table defining the mass reclassification batch header.
  • FA_ADDITIONS_B: Linked via ASSET_ID and ASSET_NUMBER. This is the core asset master table.
  • FA_BOOK_CONTROLS: Linked via BOOK. This table defines the asset book controlling the reclassification.
  • FA_METHODS, FA_CONVENTION_TYPES, FA_CEILING_TYPES: Linked via METHOD, CONVENTION, and CEILING columns, respectively. These are reference tables for depreciation rules.
  • FND_CONCURRENT_REQUESTS: Linked via REQUEST_ID. This standard EBS table tracks the concurrent manager job executing the process.