Results for “igf_ap_adm_setup”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AP_ADM_SETUP is a view owned by the APPS schema within the IGF – Financial Aid product family of Oracle E-Business Suite. The ETRM documentation for release 12.2.2 classifies this object with the description "Obsolete," indicating that Oracle no longer actively supports or enhances it as part of the current Financial Aid data model. In release 12.1.1 and 12.2.2, the view remains in a VALID state, meaning it is compiled and queryable even though it is functionally superseded.

At a structural level, the view presents admissions setup information for financial aid processing. It exposes a narrow, non-key-preserving projection of the underlying setup data, including the admissions process sequence, application status, outcome status, fee status, offer response status, standard audit columns, and the multi-org ORG_ID. Because the definition applies organization-level filtering, the view behaves as an org-secured reporting surface: a query returns only rows matching the organization identifier derived from the session context.

The view's role in EBS reporting and integration is therefore limited. It may still be referenced by custom reports, legacy interfaces, or downstream code written before the object was deprecated, but new development should target the supported replacement objects rather than this view.

Underlying Base Objects

The documented view text defines IGF_AP_ADM_SETUP over a single base object: IGF_AP_ADM_SETUP_ALL, aliased as ADMSETUP in the SQL statement. The ETRM metadata does not document any additional referenced base objects, and the view text confirms a direct, single-table projection. The presence of the _ALL suffix on the base table is significant: it denotes a multi-organization table that stores setup rows partitioned by ORG_ID, with the base table typically paired with an _ALL synonym and an org-restricted view for each operating unit.

IGF_AP_ADM_SETUP supplies the organization-restricted counterpart to that base table. Its WHERE clause compares an NVL-derived value from the ADMSETUP.ORG_ID column against a value decoded from the USERENV('CLIENT_INFO') session variable. The DECODE and SUBSTRB logic extracts the first ten characters of CLIENT_INFO, treats a leading blank as NULL, and defaults to -99 when no organization context is present. This is the classic Oracle EBS multi-org security pattern (sometimes described as the org_id = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')...))) predicate) applied to the setup table, and it ensures that only the current operating unit's admissions setup row is visible.

Key Columns

• ROW_ID – The physical ROWID of the underlying IGF_AP_ADM_SETUP_ALL row, exposed as a stable row locator.
• ADM_PROCESS_SEQ – The admissions process sequence, identifying the processing stage or step associated with the setup record.
• ADM_APPL_STAT – The admissions application status value used in the setup configuration.
• ADM_OUTCOME_STAT – The admissions outcome status configured for the setup record.
• ADM_FEE_STAT – The admissions fee status configured for the setup record.
• ADM_OFFER_RESP_STAT – The offer response status value used in the setup configuration.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit and concurrency columns tracing record creation and modification.
• ORG_ID – The operating unit identifier that drives the view's multi-org filtering.

Common Use Cases and Queries

Because the view is marked obsolete, its practical use is confined to legacy reporting and diagnostics. A typical query retrieves the setup row for the current operating unit session context, which is applied automatically by the view predicate:

• SELECT ADM_PROCESS_SEQ, ADM_APPL_STAT, ADM_OUTCOME_STAT, ADM_FEE_STAT, ADM_OFFER_RESP_STAT FROM IGF_AP_ADM_SETUP; — returns the current organization's admissions setup configuration.
• SELECT ROW_ID, ORG_ID, LAST_UPDATE_DATE FROM IGF_AP_ADM_SETUP ORDER BY ADM_PROCESS_SEQ; — diagnostic listing of setup rows and their audit stamps.
• SELECT COUNT(*) FROM IGF_AP_ADM_SETUP; — sanity check that organization context is populated, since the predicate defaults to -99 when CLIENT_INFO is empty.

Because the view text does not expose CLIENT_INFO filtering as a bindable parameter, reports must ensure the correct operating unit is initialized before querying; otherwise the default -99 comparison may return no rows. Given the obsolete status and the absence of documented referenced base objects beyond IGF_AP_ADM_SETUP_ALL, integration code should be migrated to the current Financial Aid setup objects, and any continued dependence on this view should be treated as technical debt requiring remediation.