Results for “igi_imp_iac_interface_dtl_v”

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

Overview

IGI_IMP_IAC_INTERFACE_DTL_V is an APPS-owned, read-only database view within the IGI – Public Sector Financials International product family, which delivers the federal and public-sector asset accounting extensions layered on top of Oracle Assets. The view exposes prorated asset cost and depreciation detail derived from an interface staging table that carries historical and multi-book cost accounting (MHCA) balances into the IAC processing stream. Its principal role in Oracle EBS 12.1.1 and 12.2.2 is to present distribution-level asset accounting facts, already scaled to the units assigned on each distribution line, so that downstream IAC processes and reconciliation reports can consume them without repeating the proration arithmetic.

The view is defined over the interface table IGI_IMP_IAC_INTERFACE, joined to distribution history and asset master data, and controlled by rows in IGI_IMP_IAC_CONTROLS. Because the view performs the unit-based proration inline, it functions as the canonical reporting surface for imported asset balances and is frequently the object referenced by concurrent programs and custom extracts built for public-sector asset conversions.

Underlying Base Objects

The documented base objects referenced by the view are:

• IGI_IMP_IAC_INTERFACE (SYNONYM) – the source interface table supplying asset-level balances, aliased as II in the view text. It holds columns such as ASSET_ID, ASSET_NUMBER, BOOK_TYPE_CODE, CATEGORY_ID, HIST_SALVAGE_VALUE, LIFE_IN_MONTHS, and the HIST/MHCA/YTD/BACKLOG/GENERAL_FUND/OPERATING_ACCOUNT balance pairs.
• FA_DISTRIBUTION_HISTORY (SYNONYM) – aliased as DH, providing DISTRIBUTION_ID, CODE_COMBINATION_ID, and UNITS_ASSIGNED, which drive the proration factor applied to each interface balance.
• FA_ADDITIONS (SYNONYM) – aliased as AD, contributing CURRENT_UNITS, the denominator in the unit-proportion calculation.
• IGI_IMP_IAC_CONTROLS (SYNONYM) – the control table governing the IAC import cycle, providing the run-level context within which interface rows are valid.

The view joins the interface table to distribution history and asset additions, so a single asset-level balance is split across every distribution line belonging to that asset, weighted by the distribution's share of current units.

Key Columns

Every monetary column in the view is computed as ROUND(II.<balance> * (DH.UNITS_ASSIGNED / AD.CURRENT_UNITS), 2), meaning the values are distribution-weighted and rounded to two decimals. Business keys include ASSET_ID, ASSET_NUMBER, BOOK_TYPE_CODE, DISTRIBUTION_ID, CODE_COMBINATION_ID, CATEGORY_ID, UNITS_ASSIGNED, HIST_SALVAGE_VALUE, and LIFE_IN_MONTHS. The prorated balance pairs cover COST_HIST/COST_MHCA, DEPRN_EXP_HIST/DEPRN_EXP_MHCA, YTD_HIST/YTD_MHCA, ACCUM_DEPRN_HIST/ACCUM_DEPRN_MHCA, REVAL_RESERVE_HIST/REVAL_RESERVE_MHCA, BACKLOG_HIST/BACKLOG_MHCA, GENERAL_FUND_HIST/GENERAL_FUND_MHCA, GENERAL_FUND_PER_HIST/MHCA, and OPERATING_ACCOUNT_HIST/MHCA, with a parallel OPERATING_ACCOUNT_YTD series.

The _HIST suffix denotes the primary (historical) book stream, while _MHCA denotes the corresponding multi-book cost accounting stream, allowing both to be reported side by side for the same distribution line.

Common Use Cases and Queries

Typical uses include reconciliation of imported asset balances before and after IAC processing, distribution-level verification of prorated cost and accumulated depreciation, and extracts feeding public-sector financial statements. The searched term "transfered_flag" reflects a frequent user need to identify rows already pushed from the interface into the asset books; where a transfer flag is published it is normally sourced from the interface or control table rather than from the prorated amount columns, so filtering on it is best performed against IGI_IMP_IAC_INTERFACE or IGI_IMP_IAC_CONTROLS and then joined to this view by ASSET_ID and BOOK_TYPE_CODE.

A representative query inspecting prorated balances for a book:

• SELECT asset_number, book_type_code, distribution_id, code_combination_id, units_assigned, cost_hist, cost_mhca, accum_deprn_hist, ytd_hist FROM apps.igi_imp_iac_interface_dtl_v WHERE book_type_code = :book AND asset_id = :asset_id;

Because the view is read-only and performs no data manipulation, it should always be accessed through APPS or a reporting responsibility with appropriate grants, and never referenced by name from a custom table DDL statement.