Results for “last_reval_date”

50+ results




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

Overview

IGI_IAC_ASSET_BALANCES is a table owned by the IGI schema, part of the IGI - Public Sector Financials International product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It holds the periodic asset balance position for fixed assets processed through the IGI asset lifecycle. Where Oracle Assets (FA) maintains transactional and depreciable detail for corporate books, this table captures the period-end snapshot of balances required by public sector accounting conventions, including revaluation and general fund attributions. The table carries a composite primary key, IGI_IAC_ASSET_BALANCES_PK, defined over ASSET_ID, BOOK_TYPE_CODE, and PERIOD_COUNTER, and is documented with 19 columns at the 12.2.2 schema level.

From a dimensional modeling perspective, the mined foreign-key metadata classifies this object as standalone; no explicit hub, link, or satellite designation is asserted. As a modeling suggestion, the composite key of ASSET_ID, BOOK_TYPE_CODE, and PERIOD_COUNTER behaves as a natural business key, and the descriptive financial measures (NET_BOOK_VALUE, ADJUSTED_COST, DEPRN_RESERVE) suggest a satellite-style fact structure keyed by asset, book, and accounting period rather than a pure hub.

Key Information Stored

The most significant columns of the table fall into three groups: the composite business key, the core asset balance measures, and the revaluation and audit attributes.

  • ASSET_ID — identifier of the fixed asset; part of the primary key.
  • BOOK_TYPE_CODE — the depreciation book under which the balance is reported; part of the primary key.
  • PERIOD_COUNTER — the accounting period for which the balance position is recorded; part of the primary key.
  • NET_BOOK_VALUE — net book value of the asset at period end.
  • ADJUSTED_COST — adjusted cost basis of the asset.
  • OPERATING_ACCT — operating account attribution associated with the asset balance.
  • DEPRN_AMOUNT — depreciation expense amount for the period.
  • DEPRN_RESERVE — accumulated depreciation reserve.
  • BACKLOG_DEPRN_RESERVE — backlog depreciation reserve component.
  • REVAL_RESERVE — revaluation reserve balance.
  • GENERAL_FUND — general fund classification for the asset position.
  • LAST_REVAL_DATE — date of the most recent revaluation.
  • CURRENT_REVAL_FACTOR and CUMULATIVE_REVAL_FACTOR — current and cumulative revaluation factors applied to the asset.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking record creation and modification.

No secondary unique index beyond the composite primary key is documented in the ETRM metadata; the documented surrogate/business key is IGI_IAC_ASSET_BALANCES_PK.

Common Use Cases and Queries

Typical scenarios for this table include period-end asset reporting, revaluation reserve analysis, general fund reconciliation, and depreciation trend reporting by book.

  • Period balance retrieval for a specific asset:
    SELECT ASSET_ID, BOOK_TYPE_CODE, PERIOD_COUNTER,
           NET_BOOK_VALUE, ADJUSTED_COST, DEPRN_RESERVE
    FROM   IGI.IGI_IAC_ASSET_BALANCES
    WHERE  ASSET_ID = :p_asset_id
    AND    BOOK_TYPE_CODE = :p_book
    ORDER BY PERIOD_COUNTER;
  • Revaluation reserve reporting across periods:
    SELECT PERIOD_COUNTER, SUM(REVAL_RESERVE) REVAL_RESERVE
    FROM   IGI.IGI_IAC_ASSET_BALANCES
    WHERE  BOOK_TYPE_CODE = :p_book
    GROUP BY PERIOD_COUNTER;
  • Depreciation and net book value comparison by period for a book, using DEPRN_AMOUNT, DEPRN_RESERVE, and NET_BOOK_VALUE.
  • General fund disclosure extracts joining GENERAL_FUND and OPERATING_ACCT for public sector statutory reporting.

Because the primary key spans asset, book, and period, queries filtering on all three columns return a single row, making point-in-time reconstruction of asset position straightforward.

Related Objects

The ETRM metadata classifies this table as standalone with no explicit FK dependencies. In practice, the following objects are the most significant for integration and reporting:

  • FA_ADDITIONS_B / FA_BOOKS — provide asset and book definitions joined through ASSET_ID and BOOK_TYPE_CODE.
  • FA_DEPRN_PERIODS — supplies PERIOD_COUNTER context for depreciation period mapping.
  • FA_DEPRN_SUMMARY — the operational depreciation balances that parallel the periodic IGI balance snapshot.
  • IGI_IAC_ASSET_BALANCES_PK — the composite primary key constraint enforcing uniqueness on ASSET_ID, BOOK_TYPE_CODE, and PERIOD_COUNTER.
  • IGI_IAC Interfaces / concurrent programs — the IGI asset processes that populate and refresh this table.
  • IGI period-close reporting views and public sector financial statement extracts that consume NET_BOOK_VALUE and REVAL_RESERVE.