Search Results igs_fi_control_all

Overview

The IGS_FI_CONTROL_ALL table is a critical control table within the Oracle E-Business Suite Student System (IGS) module. Its primary function is to store configuration flags and default account codes that govern the integration between the Student System and the core Oracle Financials applications. As indicated by its name suffix "_ALL," it is a multi-organization access enabled (MOAC) table, meaning it can store data for multiple operating units and is partitioned by the ORG_ID column. Its most fundamental role, as per the official documentation, is to maintain a flag indicating whether Oracle Accounts Receivable (AR) is installed, which determines the availability and behavior of integrated financial processes for student fee management.

Key Information Stored

While the core description highlights the AR installation flag, the foreign key relationships reveal the table's broader role as a repository for key system defaults. The central column is REC_INSTALLED, which holds the flag for Oracle AR. Crucially, the table stores default General Ledger account codes for various financial transactions, linked via foreign keys to the IGS_FI_ACC_ALL table. These include the Revenue Account (REV_ACCOUNT_CD), Receivables Account (REC_ACCOUNT_CD), Cash Account (CASH_ACCOUNT_CD), Unapplied Account (UNAPP_ACCOUNT_CD), and Refund Debit/Credit Accounts (REFUND_DR_ACCOUNT_CD, REFUND_CR_ACCOUNT_CD). It also stores a default CURRENCY_CD and date aliases for resolution (RES_DT_ALIAS) and refund (REFUND_DT_ALIAS) processes, linked to the IGS_CA_DA (Date Alias) table.

Common Use Cases and Queries

This table is primarily referenced by setup and transactional logic to determine system behavior. A common use case is for programs to check the AR installation status before attempting to call AR APIs or create AR transactions. Developers and administrators may query it to verify the financial configuration for an operating unit. Sample queries include checking the installation status and default currency, or listing the configured default accounts.

• Verify AR installation and defaults for a specific ORG_ID: SELECT rec_installed, currency_cd, rev_account_cd FROM igs_fi_control_all WHERE org_id = 123;
• Join with FND_CURRENCIES to get the currency name: SELECT ctrl.currency_cd, cur.name FROM igs_fi_control_all ctrl, fnd_currencies cur WHERE ctrl.currency_cd = cur.currency_code AND ctrl.org_id = 123;

Direct data manipulation in this table is rare and typically performed only during initial implementation or major reconfiguration via established setup forms.

Related Objects

The IGS_FI_CONTROL_ALL table sits at the center of a network of financial setup objects. Its primary key (IGS_FI_CONTROL_PK) is referenced by various student financial sub-modules. As documented, its most significant relationships are foreign keys to:

• IGS_FI_ACC_ALL: For all default GL account codes (revenue, receivables, cash, etc.).
• FND_CURRENCIES: For the default currency definition.
• IGS_CA_DA: For the academic calendar date aliases used in financial processes.

It is a parent table to transactional entities like IGS_FI_INV_INT_ALL and is integral to the setup of the IGS Funds Capture and Student Financials components. Any process that creates a student invoice, receipt, or refund will typically read configuration from this control table.