Search Results igf_ap_fa_setup




Overview
Explore in AI Chat

Overview

IGF_AP_FA_SETUP is an Oracle E-Business Suite view owned by the APPS schema and associated with the IGF (Financial Aid) product family, specifically the need-analysis and federal aid processing components of Oracle Student Financial Aid. The view exposes the active organization's financial aid office (FAO) setup configuration as maintained in the underlying entity table. It is a multi-org secured (organization-level) view: rather than presenting every row across all business units, it filters records using the Oracle multi-org CLIENT_INFO mechanism, so a session sees only the setup row(s) belonging to its currently selected organization.

The object's ETRM documentation describes it as "FA126_3102439_CS_DP2.doc - Obsolete," indicating the view is a legacy or superseded artifact retained for backward compatibility. It should be treated accordingly in upgrade and remediation planning for 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a single documented base object: IGF_AP_FA_SETUP_ALL, the entity table storing financial aid office setup records. The documentation lists no additional referenced base objects. The defining query selects the ROWID of the underlying table row as ROW_ID alongside all principal setup columns, and applies a WHERE predicate that compares the row's ORG_ID to the organization identifier derived from USERENV('CLIENT_INFO'). The DECODE/SUBSTRB logic returns NULL when the first character of CLIENT_INFO is a space, converting that to a numeric value, and NVL substitutes -99 when no organization can be resolved — the standard multi-org secured view pattern. Because the view reads only from the _ALL table and performs security filtering at query time, it is read-oriented and does not itself carry DML of its own.

Key Columns

Common Use Cases and Queries

Typical uses include FAO lookup for reporting, validation of Title IV identifiers before federal disbursement extracts, and reconciliation of setup rows across operating units. Because the view is org-secured, queries return only the session's organization. A representative lookup by name:

SELECT fao_id, fao_name, ope_id, pell_id, duns_id, org_id
FROM apps.igf_ap_fa_setup
WHERE fao_name LIKE :p_fao_name;

For administrative review across the base table, query IGF_AP_FA_SETUP_ALL directly with an explicit ORG_ID predicate. Given the "Obsolete" designation, confirm current object usage against your 12.1.1/12.2.2 instance before building new dependencies on it.