Results for “fa_mass_revaluations”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_MASS_REVALUATIONS is an Oracle E-Business Suite Assets (OFA) table that stores mass revaluation request status information. It resides in the FA schema and is documented as VALID in both EBS 12.1.1 and 12.2.2. In the Oracle Assets mass revaluation process, users often need to revalue an entire group of assets — for example, applying across-the-board inflation adjustments, life extensions, or partial revaluations tied to a specific revaluation rule. Rather than processing each asset individually, Oracle Assets collects the request criteria and tracks the progress and outcome of that bulk operation against records in this table.

Each row in FA_MASS_REVALUATIONS represents a single mass revaluation request. The table therefore acts as the controlling header record that binds a set of revaluation rules to a particular asset book, a revaluation date, and an Oracle concurrent program request. From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite recording attributes and status about an entity, rather than functioning as a pure hub or junction link. The classification is heuristic and should be treated as a modeling suggestion rather than a definitive architectural designation.

Key Information Stored

The table contains 54 documented columns in the 12.2.2 physical schema. The most significant columns are:

• MASS_REVAL_ID — The surrogate primary key. It is the single column of the primary key constraint FA_MASS_REVALUATIONS_PK and is also the sole column of the unique index FA_MASS_REVALUATIONS_U1, making it the definitive business-key candidate as well.
• BOOK_TYPE_CODE — Identifies the asset book against which the revaluation is performed; foreign key to FA_BOOK_CONTROLS.
• DESCRIPTION — Free-text description of the mass revaluation request.
• REVAL_DATE — The date on which the revaluation is applied.
• STATUS — Tracks the lifecycle state of the request (for example, pending, in progress, or completed).
• LAST_REQUEST_ID — Links the row to the concurrent request that processed it; foreign key to FND_CONCURRENT_REQUESTS.
• DEFAULT_REVAL_FULLY_RSVD_FLAG — Default indicator for whether fully reserved assets are revalued.
• DEFAULT_LIFE_EXTENSION_FACTOR and DEFAULT_LIFE_EXTENSION_CEILING — Default life-extension parameters applied to affected assets.
• DEFAULT_MAX_FULLY_RSVD_REVALS — Default cap on revaluations for fully reserved assets.
• REVALUE_CIP_ASSETS_FLAG and PERIOD_END_REVAL_FLAG — Flags controlling whether CIP assets are revalued and whether the revaluation occurs at period end.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–15 — Flexfield descriptive attributes for extensibility.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 — Global descriptive flexfield columns reserved for localization and country-specific extensions.

Common Use Cases and Queries

Typical uses center on operational monitoring and audit of mass revaluation runs. Common patterns include:

• Listing all mass revaluation requests for a given book to review history and status.
• Correlating a request to its concurrent program run to retrieve completion outcome and log information.
• Reporting on revaluation activity by date for period-close and audit purposes.
• Auditing the default parameters (life extension, fully reserved handling, CIP flags) applied to each request.

A representative query joining to the book and concurrent request tables:

SELECT mr.mass_reval_id, mr.book_type_code, mr.description,
  mr.reval_date, mr.status, mr.last_request_id,
  fcr.phase_code, fcr.status_code
FROM fa.fa_mass_revaluations mr,
  fa.fa_book_controls bc,
  apps.fnd_concurrent_requests fcr
WHERE mr.book_type_code = bc.book_type_code
  AND mr.last_request_id = fcr.request_id(+)
  AND mr.book_type_code = :book_type_code
ORDER BY mr.reval_date DESC;

To inspect the rules associated with a request, join FA_MASS_REVALUATION_RULES on MASS_REVAL_ID.

Related Objects

The most significant objects related to FA_MASS_REVALUATIONS, based on the documented foreign-key relationships, are:

• FA_BOOK_CONTROLS — Referenced by FA_MASS_REVALUATIONS.BOOK_TYPE_CODE; identifies the asset book.
• FND_CONCURRENT_REQUESTS — Referenced by FA_MASS_REVALUATIONS.LAST_REQUEST_ID; links to the processing concurrent request.
• FA_MASS_REVALUATION_RULES — References FA_MASS_REVALUATIONS.MASS_REVAL_ID; holds the individual revaluation rules for the request.
• FA_MASS_REVAL_REP_ITF — References FA_MASS_REVALUATIONS.MASS_REVAL_ID; the report interface used when producing mass revaluation reports.
• IGI_MHC_MCPP_RUN, IGI_MHC_REVALUATION_DETAIL, IGI_MHC_REVALUATION_SUMMARY, IGI_MHC_IDX_REVALUATIONS, and IGI_MHC_IDX_REVALUATION_RULES — EBS public-sector (IGI) tables that reference MASS_REVAL_ID, integrating mass revaluation data into those localization processes.

Together these relationships place FA_MASS_REVALUATIONS at the center of the Assets mass revaluation control structure, tying request metadata to books, concurrent processing, detailed rules, and downstream reporting interfaces.