Search Results igs_fi_control_v




Overview
Explore in AI Chat

Overview

The APPS.IGS_FI_CONTROL_V view is a reporting and integration construct within the Oracle E-Business Suite Student System (IGS) product family, specifically belonging to the Financials (FI) sub-module. Its principal role is to consolidate the single-row control record held in the IGS_FI_CONTROL table with descriptive, denormalized attributes sourced from a substantial set of lookup, account, and reference tables. Rather than requiring downstream reports, interfaces, and concurrent programs to repeatedly join low-level control configuration with lookup meanings, set-of-books names, account descriptions, and operating unit names, this view presents a single, human-readable picture of the institution's financial control parameters for a given organization.

In Oracle EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and is documented as VALID. It is an outbound-facing object: because the control table typically contains only one active row per operating unit, the view is frequently referenced by ETRM, OBIEE, and custom BI Publisher reports that need to display or export institutional Financial Aid and Student Accounts configuration without reconstructing the joins manually.

Underlying Base Objects

Although the ETRM 12.2.2 metadata lists no documented base objects, the view text itself (preserved from the 12.1.1 definition) is defined over the following objects. The driving table is IGS_FI_CONTROL CTRL, which stores the controlling setup values for the Student System financials module. Descriptive attributes are resolved through outer joins to supporting objects:

  • IGS_LOOKUP_VALUES (aliases LKV, LKV1, LKV2) — supplies lookup meanings for accounting method, fee calculation method, and refund destination.
  • IGS_CA_DA (alias DA1) — provides the description for the refund direct-debit alias.
  • IGS_FI_ACC (aliases ACC1, ACC2, ACC3, ACC5, ACC6) — provides account descriptions for the refund debit/credit accounts, receivable, revenue, cash, and unapplied accounts.
  • GL_SETS_OF_BOOKS (alias SB) — resolves the set of books name from SET_OF_BOOKS_ID.
  • FND_CURRENCIES_TL (alias CURR) — resolves the currency name from CURRENCY_CD.
  • HR_OPERATING_UNITS (alias HRO) — resolves the AP operating unit name.

Almost all joins are outer joins ((+) syntax), ensuring the control row is returned even when descriptive lookups are not defined.

Key Columns

The view exposes the following notable columns, drawn directly from the definition:

Common Use Cases and Queries

Typical usage includes confirming the set of books and account mappings applied to student financial transactions, validating AutoInvoice interface defaults prior to running the Receivables interface, and exporting configuration for audit or migration.

  • Review control settings for an operating unit: SELECT accounting_method, fee_calc_mthd_code, set_of_books_name FROM igs_fi_control_v WHERE org_id = :p_org_id;
  • Verify refund account mapping: SELECT refund_dr_account_cd, refund_cr_account_cd FROM igs_fi_control_v;
  • Confirm AutoInvoice defaults: SELECT batch_source_id, cust_trx_type_id, term_id FROM igs_fi_control_v;
  • Audit change history: SELECT last_update_date, last_updated_by FROM igs_fi_control_v;

Because the view is not a key Flexfield view and carries no documented primary key, queries should filter on ORG_ID or SET_OF_BOOKS_ID to isolate the applicable control row.