Search Results igi_iac_book_controls




Overview
Explore in AI Chat

Overview

IGI_IAC_BOOK_CONTROLS is a configuration and control table in the IGI (Public Sector Financials International) product family of Oracle E-Business Suite. Its documented purpose is to hold the set of General Ledger books, journal sources, and journal categories that participate in Inflation Accounting processing. Inflation Accounting, delivered through the IGI modules, provides the mechanism by which inflationary adjustments are computed and posted against General Ledger balances for public sector and international implementations that require inflation-adjusted reporting.

In the ETRM 12.2.2 physical schema the object is owned by the IGI schema and contains 12 documented columns. The primary key is IGI_IAC_CATEGORY_BOOKS_PK, defined on the BOOK_TYPE_CODE column. Under the heuristic Data Vault classification mined from the foreign key structure, this table is modelled as a standalone object rather than a hub, link, or satellite. This should be read as a modelling suggestion: because no FK relationships were mined, the table does not act as a conventional junction or dependent entity in the documented schema, and its keys are effectively local to the Inflation Accounting configuration domain.

Key Information Stored

The table stores the mapping between a General Ledger book and the journal attributes used to isolate inflation accounting entries. The most significant columns are:

  • BOOK_TYPE_CODE — the primary key of the table and the identifier of the General Ledger book (for example, a set of books or ledger) for which Inflation Accounting controls are defined. Because it is both the sole primary key column and the business discriminator, it is the leading business-key candidate for this object.
  • GL_JE_SOURCE — the General Ledger journal source that inflation accounting entries use when they are generated and posted for the configured book.
  • JE_IAC_DEPRN_CATEGORY — the journal category applied to inflation accounting adjustments relating to depreciation.
  • JE_IAC_REVAL_CATEGORY — the journal category applied to inflation accounting adjustments relating to revaluation.
  • JE_IAC_TXN_CATEGORY — the journal category applied to inflation accounting adjustments relating to transactions.
  • PERIOD_NUM_FOR_CATCHUP — the period number used to control the catch-up calculation, determining the period from which inflation accounting catch-up entries are derived.
  • ORG_ID — the operating unit (multi-org) identifier that scopes the control row to a specific organization.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS who-columns recording audit and concurrency information for each control row.

The surrogate identity of a row is established by the primary key constraint IGI_IAC_CATEGORY_BOOKS_PK on BOOK_TYPE_CODE. No secondary unique index is documented in the ETRM metadata, so BOOK_TYPE_CODE serves simultaneously as the technical key and the principal business key.

Common Use Cases and Queries

The primary use case is configuration validation: confirming which books have been enabled for Inflation Accounting and which journal source and categories each book will use. A typical query retrieves the full control definition for a book:

  • SELECT book_type_code, gl_je_source, je_iac_deprn_category, je_iac_reval_category, je_iac_txn_category, period_num_for_catchup, org_id FROM igi.igi_iac_book_controls WHERE book_type_code = :p_book_type_code;
  • To inventory every book participating in Inflation Accounting, query without a predicate and join to the General Ledger books (GL_LEDGERS or the legacy GL_SETS_OF_BOOKS) on BOOK_TYPE_CODE to obtain the book name.
  • For multi-org reporting, filter on ORG_ID to restrict results to the operating unit in scope.
  • Reconciliation reporting compares the configured JE_IAC_* categories against actual journal lines generated with GL_JE_SOURCE, to confirm that catch-up, revaluation, and depreciation entries were posted to the intended categories.
  • Audit queries can use CREATION_DATE and LAST_UPDATE_DATE to determine when a book's inflation accounting controls were last changed.

Related Objects

Because the ETRM metadata classifies this table as standalone with no mined foreign keys, related objects are identified by shared business keys and functional dependency rather than declared constraints. The most significant are:

  • GL_LEDGERS / GL_SETS_OF_BOOKS — joined on BOOK_TYPE_CODE; supplies the book name and ledger attributes for the configured control row.
  • GL_JE_SOURCES — joined on GL_JE_SOURCE; validates the journal source configured for inflation entries.
  • GL_JE_CATEGORIES — joined on JE_IAC_DEPRN_CATEGORY, JE_IAC_REVAL_CATEGORY, and JE_IAC_TXN_CATEGORY; validates that each configured category is a valid General Ledger journal category.
  • IGI_IAC_* transaction and adjustment tables — the Inflation Accounting processing tables that consume the source and category settings defined here.
  • HR_OPERATING_UNITS — joined on ORG_ID; resolves the operating unit that owns a given control row.