Results for “reval_calculation_code”

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

Overview

The IGI_MHC_REVALUATION_SUMMARY table is a core data object within the IGI – Public Sector Financials International module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores the summarized financial outcome of the Extended Mass Revaluation program as applied to fixed assets. When that program executes — whether in Preview Mode or Live Mode — the revaluation engine inserts a row into the IGI_MHC_REVALUATION_DETAIL table for every distribution line of an affected asset. Those detailed figures are subsequently aggregated and persisted in IGI_MHC_REVALUATION_SUMMARY, producing one consolidated record per asset per mass revaluation run.

The table therefore acts as the auditable financial snapshot of a revaluation event at the asset level. It captures the before-and-after cost, accumulated depreciation, revaluation reserve, and operating expense positions, enabling public sector organizations to review the impact of revaluation before committing it, and to retain a permanent record once posted. Based on heuristic analysis of its foreign key structure, the table is classified as a standalone Data Vault object; a modeling suggestion would be to treat it as a satellite, since it holds descriptive and financial measures keyed to a parent revaluation event and asset.

Key Information Stored

The table is physically documented with 34 columns in the ETRM 12.2.2 schema, owned by the IGI schema. Its most significant columns fall into three groups.

• Identifiers and context: MASS_REVAL_ID (foreign key to FA_MASS_REVALUATIONS), ASSET_ID, CATEGORY_ID, and BOOK_TYPE_CODE establish which asset, category, and depreciation book the summarized revaluation applies to. PERIOD_COUNTER and CURRENT_MHC_PERIOD_COUNTER anchor the record to the accounting period.
• Pre-revaluation values: ORIGINAL_COST, ORIGINAL_LIFE, PREVIOUS_LIFE, OLD_ACCUM_DEPRN, and OLD_REVAL_RESERVE capture the asset's position before the revaluation is applied.
• Post-revaluation values: NEW_ASSET_COST, NEW_SALVAGE_VALUE, CURRENT_LIFE, NEW_ACCUM_DEPRN, NEW_REVAL_RESERVE, NEW_CURR_YR_EXPENSE, NEW_BACKLOG_DEPRN, NEW_CURR_YR_OP_EXPENSE, NEW_PRIOR_YR_OP_EXPENSE, NEW_GENERAL_FUND, and NEW_ACCUM_GENERAL_FUND record the recalculated figures. REVAL_MODE, RUN_MODE, REVAL_CALCULATION_CODE, LAST_TXN_EVENT, and ACTIVE_FLAG describe how the calculation was performed.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are also present. The composite of MASS_REVAL_ID and ASSET_ID functions as the effective business-key candidate for a given run and asset; no separate surrogate primary key column is documented beyond these identifiers.

Common Use Cases and Queries

Typical uses include reviewing the projected versus actual financial impact of a mass revaluation, reconciling summarized totals back to IGI_MHC_REVALUATION_DETAIL, and feeding revaluation reports for fixed asset and general ledger analysis. A common query pattern joins the summary to the parent event table:

• List all summarized revaluations for a book: SELECT * FROM IGI.IGI_MHC_REVALUATION_SUMMARY WHERE BOOK_TYPE_CODE = :book AND PERIOD_COUNTER = :period;
• Compare cost movement: SELECT ASSET_ID, ORIGINAL_COST, NEW_ASSET_COST, NEW_ASSET_COST - ORIGINAL_COST delta FROM IGI.IGI_MHC_REVALUATION_SUMMARY WHERE MASS_REVAL_ID = :id;
• Join to the parent run: SELECT s.*, m.* FROM IGI.IGI_MHC_REVALUATION_SUMMARY s JOIN FA.FA_MASS_REVALUATIONS m ON s.MASS_REVAL_ID = m.MASS_REVALUATION_ID;

Because RUN_MODE distinguishes Preview from Live execution, reports should filter on that column to avoid mixing projected and posted outcomes.

Related Objects

The most significant related objects, grounded in the documented foreign key relationship and IGI module dependencies, include:

• FA_MASS_REVALUATIONS — parent table referenced by MASS_REVAL_ID; identifies the mass revaluation run.
• IGI_MHC_REVALUATION_DETAIL — source detail table from which summary figures are aggregated.
• FA_ADDITIONS — the asset master, joined via ASSET_ID.
• FA_CATEGORIES_B — asset category definition, joined via CATEGORY_ID.
• FA_BOOK_CONTROLS — depreciation book definition, joined via BOOK_TYPE_CODE.
• FA_DEPRN_SUMMARY — depreciation balances relevant to accumulated depreciation reconciliation.

Together these objects support the Extended Mass Revaluation workflow from detail capture through summarized reporting.