Search Results fa_book_controls_sec




Overview
Explore in AI Chat

Overview

APPS.IGI_IAC_BOOK_CONTROLS_V is a reporting view in the Oracle E-Business Suite (EBS) Financials product family, owned by the APPS schema. It is documented in ETRM for both 12.1.1 and 12.2.2. The view combines the IAC (Intelligent Accounting Center / Global Accounting Engine-related asset configuration) book control attributes stored in IGI_IAC_BOOK_CONTROLS with the secured book definition records held in FA_BOOK_CONTROLS_SEC. Its principal function is to expose IAC book control setup information only for those depreciation books to which the querying responsibility or user has secured access, by enforcing an inner join between the two underlying objects on the book type code.

Because FA_BOOK_CONTROLS_SEC is the security-aware repository of depreciation book controls in Oracle Assets, restricting a IAC book control record through this join ensures that users querying or reporting through the view can only see book-level IAC configuration for books they are authorized to use. This makes the view suitable for Oracle Assets and subledger accounting reporting, extensions, and integrations where book-level IAC parameters must be surfaced alongside standard book security.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed as synonyms in the APPS schema:

  • IGI_IAC_BOOK_CONTROLS (SYNONYM) — the primary table storing IAC book control configuration, aliased as IBC in the view definition.
  • FA_BOOK_CONTROLS_SEC (SYNONYM) — the Oracle Assets book controls security table, aliased as FBC.

The join condition is IBC.BOOK_TYPE_CODE = FBC.BOOK_TYPE_CODE. The view is therefore a single-table projection of IGI_IAC_BOOK_CONTROLS with an inner join to FA_BOOK_CONTROLS_SEC purely for access restriction. If a book type code exists in IGI_IAC_BOOK_CONTROLS but not in the security table, or if the security table does not grant access, the corresponding row is excluded from the view result. The view exposes the ROWID of IGI_IAC_BOOK_CONTROLS as the column ROW_ID, along with the stacked book type code and audit columns.

Key Columns

Common Use Cases and Queries

Typical uses include diagnosing IAC journal creation setup for a specific book, verifying which journal categories and GL source are configured, and building reports that respect book security. A simple retrieval by book type code:

  • SELECT book_type_code, gl_je_source, je_iac_deprn_category, je_iac_reval_category, je_iac_txn_category, period_num_for_catchup FROM apps.igi_iac_book_controls_v WHERE book_type_code = :book;
  • SELECT book_type_code, gl_je_source FROM apps.igi_iac_book_controls_v ORDER BY book_type_code;
  • SELECT v.book_type_code, v.gl_je_source, v.je_iac_txn_category, v.last_update_date FROM apps.igi_iac_book_controls_v v WHERE v.org_id = :org_id;

Because the view already restricts results through FA_BOOK_CONTROLS_SEC, queries issued from a secured responsibility automatically reflect only accessible books, avoiding the need to re-implement book security logic in custom reports and integrations.