Results for “igi_imp_iac_controls”

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

Overview

IGI_IMP_IAC_CONTROLS is a table owned by the IGI schema within Oracle E-Business Suite, belonging to the product family IGI — Public Sector Financials International. The table stores Inflation Accounting data preparation parameters. In the Oracle EBS 12.1.1 and 12.2.2 environments, it functions as the control and setup repository that governs how inflation accounting processes are initiated and tracked for a given accounting book. Each row defines the processing context for a book type, capturing the corporate book linkage, the accounting period against which inflation preparation is run, and the status of the associated concurrent request. The table therefore acts as a persistent record of inflation accounting preparation activity rather than as a transactional detail table.

From a Data Vault modeling perspective, the heuristic classification of this table is hub-leaning. This classification reflects the fact that its primary key, BOOK_TYPE_CODE, is a single business-oriented key that uniquely identifies each record and is referenced by dependent tables. In Data Vault terms, this suggests treating IGI_IMP_IAC_CONTROLS as a hub of book-type identities, with descriptive and process-status attributes that could be modeled as satellites.

Key Information Stored

The table contains eleven documented columns. The surrogate and primary key is defined by the constraint IGI_IMP_IAC_CONTROLS_PK, which enforces uniqueness on BOOK_TYPE_CODE. Because BOOK_TYPE_CODE is also the sole component of the primary key and is referenced by a foreign key from another table, it serves as the de facto business key for this object.

• BOOK_TYPE_CODE — The primary key and business identifier for each control record; links the inflation accounting preparation setup to a specific Oracle EBS book type.
• CORP_BOOK — Identifies the corporate book associated with the inflation accounting preparation, distinguishing it from the primary book in consolidation scenarios.
• PERIOD_COUNTER — References the accounting period for which inflation accounting data preparation is performed; used to scope the process to a specific period.
• REQUEST_STATUS — The status of the concurrent request that executed or is executing the inflation accounting preparation, enabling process monitoring.
• REQUEST_ID — The concurrent request identifier, providing a direct pointer to the Oracle EBS concurrent manager record for audit and troubleshooting.
• REQUEST_DATE — The date and time the preparation request was submitted.
• CREATED_BY, CREATION_DATE — Standard WHO columns recording the user who created the control record and the creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the last modifying user, timestamp, and login session.

The foreign key relationship documented shows that IGI_IMP_IAC_INTERFACE_CTRL.BOOK_TYPE_CODE references IGI_IMP_IAC_CONTROLS.BOOK_TYPE_CODE, establishing this table as the parent in the control hierarchy.

Common Use Cases and Queries

The most frequent use case is determining whether inflation accounting data preparation has been run for a given book and period, and reviewing its processing status. A typical query retrieves the current control state for a book type:

• SELECT book_type_code, corp_book, period_counter, request_status, request_id, request_date FROM igi_imp_iac_controls WHERE book_type_code = :book_type_code;
• Join to IGI_IMP_IAC_INTERFACE_CTRL on BOOK_TYPE_CODE to reconcile control-level and interface-level preparation records.
• Report on outstanding or failed requests by filtering on REQUEST_STATUS to identify preparations that did not complete successfully.
• Audit trail queries using CREATED_BY, CREATION_DATE, and the LAST_UPDATE columns to track who configured or modified preparation controls.

These queries support period-close monitoring, troubleshooting of concurrent inflation accounting jobs, and reconciliation between control and interface staging data.

Related Objects

The following objects are the most significant in relation to IGI_IMP_IAC_CONTROLS, based on documented foreign key dependencies and the inflation accounting preparation process:

• IGI_IMP_IAC_INTERFACE_CTRL — References IGI_IMP_IAC_CONTROLS.BOOK_TYPE_CODE; holds interface-level control records for inflation accounting preparation.
• IGI_IMP_IAC_CONTROLS_PK — The primary key constraint enforcing uniqueness on BOOK_TYPE_CODE.
• Oracle EBS Book Type definitions — The underlying book type referenced by BOOK_TYPE_CODE, sourced from the financials book setup.
• Oracle EBS Accounting Calendar / Period definitions — The period referenced by PERIOD_COUNTER.
• Oracle Concurrent Manager (FND_CONCURRENT_REQUESTS) — The concurrent request repository referenced logically by REQUEST_ID and REQUEST_STATUS.

Together these objects form the control and staging framework that governs inflation accounting data preparation in the IGI Public Sector Financials International module.