Results for “igi_imp_iac_interface_py_add”

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

Overview

IGI_IMP_IAC_INTERFACE_PY_ADD is a transient interface table owned by the IGI schema (Public Sector Financials International) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores asset information for each asset processed by the Inflation Accounting Prior Year Addition program, which supports inflation-adjusted accounting for public sector organizations. Rows are populated during program execution and consumed by downstream inflation accounting processing, distinct from the base Oracle Assets tables.

From a Data Vault modeling perspective, the mined foreign key structure suggests this table leans toward a satellite classification, carrying descriptive and derived measures keyed to an asset-book grain. It is best treated as a descriptive satellite attached to an asset/book business key rather than as an independent hub or a link resolving many-to-many relationships.

Key Information Stored

The table has 34 documented columns. The composite primary key is defined as IGI_IMP_IAC_PY_ADD_PK over (BOOK_TYPE_CODE, ASSET_ID), establishing the grain of one row per asset per depreciation book. The most significant columns are:

• BOOK_TYPE_CODE — depreciation book identifier; part of the primary key.
• ASSET_ID — asset identifier; part of the primary key and the principal business-key candidate.
• ASSET_NUMBER — user-facing asset number for reporting reconciliation.
• CATEGORY_ID — asset category referenced in the foreign key relationship.
• PERIOD_COUNTER — accounting period identifier for the processed row.
• NET_BOOK_VALUE — net book value used in inflation adjustment.
• ADJUSTED_COST — inflation-adjusted cost basis.
• DEPRN_AMOUNT and DEPRN_RESERVE — period and accumulated depreciation amounts.
• BACKLOG_DEPRN_RESERVE — backlog depreciation reserve carried into the adjustment.
• CURRENT_REVAL_FACTOR and CUMMULATIVE_REVAL_FACTOR — revaluation factors applied to the asset.
• HIST_COST, HIST_DEPRN_EXPENSE, HIST_ACCUM_DEPRN, HIST_NBV, HIST_LIFE_IN_MONTHS, HIST_SALVAGE_VALUE — historical cost and depreciation reference values.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program audit columns identifying the originating run.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) support auditability.

Common Use Cases and Queries

Primary uses include verifying the Inflation Accounting Prior Year Addition run output, reconciling adjusted values against base Oracle Assets, and driving downstream inflation postings.

• Reviewing processed assets for a book and period:

  SELECT asset_number, book_type_code, period_counter, net_book_value, adjusted_cost
  FROM   igi.igi_imp_iac_interface_py_add
  WHERE  book_type_code = :book AND period_counter = :period;

• Reconciling by concurrent request: filter on REQUEST_ID to isolate rows from a specific run.
• Comparing historical versus adjusted figures using HIST_NBV against NET_BOOK_VALUE.
• Aggregating revaluation impact by category using CATEGORY_ID and the revaluation factor columns.

Because this is an interface table, queries should generally be scoped by request or period to avoid mixing successive program runs.

Related Objects

• IGI_IMP_IAC_INTERFACE_PY_ADD — self-referenced in the documented FK mapping for BOOK_TYPE_CODE and CATEGORY_ID resolution.
• Oracle Assets base tables (FA_ADDITIONS, FA_BOOKS) — joined via ASSET_ID and BOOK_TYPE_CODE to compare source asset records with interface output.
• FA_CATEGORIES — joined on CATEGORY_ID for category descriptions.
• FA_DEPRN_PERIODS / FA_PERIODS — joined on PERIOD_COUNTER for accounting period context.
• FND_CONCURRENT_REQUESTS — joined on REQUEST_ID to trace the program execution.
• FA_DEPRN_SUMMARY — compared against DEPRN_AMOUNT and DEPRN_RESERVE for reconciliation.
• Inflation Accounting posting programs — consume rows from this interface table to create adjusted accounting entries.