Search Results igs_fi_control_pk

Overview

The IGS_FI_CONTROL table is a control table within the Oracle E-Business Suite (EBS) Student System (IGS) module, which is documented as obsolete in releases 12.1.1 and 12.2.2. Its primary role is to store a single system-level configuration flag indicating whether the Oracle Accounts Receivable (AR) module is installed and integrated within the EBS instance. This flag is critical for determining the availability of AR functionality for financial transactions processed by the Student System, such as invoicing and receipting. As a control table, it typically contains only one row of data that governs the operational mode for related financial processes.

Key Information Stored

The table's structure is minimal, designed to hold a single Boolean or character-based indicator. Based on the provided metadata, the primary and likely sole significant column is REC_INSTALLED. This column acts as the flag, presumably storing a value such as 'Y' or 'N' to denote the installation status of Oracle Accounts Receivable. The table's primary key constraint, IGS_FI_CONTROL_PK, is defined on this column, enforcing the table's design to contain only one row of configuration data. It is important to note the documented disclaimer that this table is "Not implemented in this database," suggesting it may not be present or populated in all EBS instances running the specified versions.

Common Use Cases and Queries

The primary use case is for program logic within the IGS module to conditionally execute code paths based on AR's availability. Before initiating any AR-specific API calls or processes, a PL/SQL package or form would query this table to check the flag. A common query pattern would be a simple SELECT statement to retrieve the control value. For example:

• SELECT rec_installed FROM igs_fi_control;

This value would then be evaluated within application code. In reporting or diagnostic scripts, administrators might query this table to verify the system's financial module configuration. Given the table's "obsolete" status, a key operational use case in later versions may involve data migration or validation scripts checking for the existence and value of this flag during upgrades.

Related Objects

The table's main documented relationship is through its primary key constraint, IGS_FI_CONTROL_PK. While the provided metadata does not list explicit foreign key relationships from other tables, the REC_INSTALLED flag is logically referenced by numerous financial processes and program units within the IGS module. Code in packages, forms, and reports related to student invoicing, payment processing, and financial interfaces would conditionally depend on this setting. It may also be referenced by other control or setup tables within the IGS financials sub-module that govern the behavior of AR-integrated features. The table's status as obsolete indicates its function may have been superseded by a more centralized or standard EBS configuration mechanism in later implementations.