Results for “igi_imp_iac_interface”

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

Overview

IGI.IGI_IMP_IAC_INTERFACE is an Oracle E-Business Suite interface table that belongs to the IGI product family — Public Sector Financials International. Its documented purpose is to store asset details used for implementation reconciliation, meaning it acts as a staging and comparison surface for asset records extracted from, or intended for, Oracle Assets (FA) during a public-sector implementation cycle. The table is classified as VALID in the ETRM repository for release 12.2.2 and carries the same identity in 12.1.1 schemas where the IGI product is installed.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. The table does not merely anchor an entity; it carries a wide descriptive payload (49 documented columns) that records historical and MHCA (modified historical cost accounting) values, flags, and reconciliation identifiers. The primary key IGI_IMP_IAC_INTERFACE_PK is composite, defined on (BOOK_TYPE_CODE, ASSET_ID), which effectively anchors each row to a specific asset within a specific depreciation book. The single documented foreign key, BOOK_TYPE_CODE → IGI_IMP_IAC_INTERFACE_CTRL, confirms that a control (header) record governs the set of interface rows written during a given reconciliation run.

Key Information Stored

The most significant columns fall into three groups: identity, financial reconciliation values, and process control.

• Identity and business keys: ASSET_ID and BOOK_TYPE_CODE together form the primary key. ASSET_NUMBER and CATEGORY_ID are the principal business-key candidates used to reconcile staging rows back to the FA_ASSETS and FA_CATEGORIES_B records.
• Cost and depreciation values: COST_HIST, COST_MHCA, DEPRN_EXP_HIST, DEPRN_EXP_MHCA, YTD_HIST, YTD_MHCA, ACCUM_DEPRN_HIST, ACCUM_DEPRN_MHCA, NBV_HIST, and NBV_MHCA hold the paired historical and MHCA amounts compared during reconciliation.
• Fund and account allocations: GENERAL_FUND_HIST, GENERAL_FUND_MHCA, OPERATING_ACCOUNT_HIST, OPERATING_ACCOUNT_MHCA, OPERATING_ACCOUNT_COST, and OPERATING_ACCOUNT_BACKLOG capture the government-specific fund distribution required by public-sector accounting rules.
• Exception and process control: EXCEPTION_FLAG, EXCEPTION_CODE, VALID_FLAG, TRANSFERRED_FLAG, SELECTED_FLAG, GROUP_ID, REQUEST_ID, EXPORT_FILE/EXPORT_DATE, and IMPORT_FILE/IMPORT_DATE drive the interface lifecycle and trace rows to the concurrent program that populated them.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN follow standard EBS WHO conventions.

Common Use Cases and Queries

The table is primarily consumed by IGI reconciliation concurrent programs and by support analysts diagnosing implementation discrepancies between legacy asset data and Oracle Assets. Typical queries examine exception rows or compare historical versus MHCA balances:

• Listing unreconciled assets: SELECT ASSET_NUMBER, BOOK_TYPE_CODE, EXCEPTION_CODE FROM IGI_IMP_IAC_INTERFACE WHERE EXCEPTION_FLAG = 'Y' AND VALID_FLAG = 'Y';
• Comparing ledger values for a book: SELECT ASSET_ID, COST_HIST, COST_MHCA, NBV_HIST, NBV_MHCA FROM IGI_IMP_IAC_INTERFACE WHERE BOOK_TYPE_CODE = :book;
• Tracing a run back to its request: ... WHERE REQUEST_ID = :request_id;
• Confirming the controlling header: join to IGI_IMP_IAC_INTERFACE_CTRL on BOOK_TYPE_CODE.

Related Objects

• IGI_IMP_IAC_INTERFACE_CTRL — control/header table; joined on BOOK_TYPE_CODE.
• FA_ASSETS — source of ASSET_ID and ASSET_NUMBER.
• FA_BOOKS / FA_BOOK_CONTROLS — validate BOOK_TYPE_CODE.
• FA_CATEGORIES_B — resolves CATEGORY_ID.
• FA_DEPRN_SUMMARY — comparison target for depreciation figures.
• FND_CONCURRENT_REQUESTS — links via REQUEST_ID.
• FND_USER — resolves CREATED_BY and LAST_UPDATED_BY.
• IGI_IMP_IAC_INTERFACE_PK — the primary key constraint on (BOOK_TYPE_CODE, ASSET_ID).