Search Results igf_ap_gen_setup_all




Overview
Explore in AI Chat

Overview

The IGF_AP_GEN_SETUP_ALL table resides in the IGF schema and belongs to the Oracle Financial Aid (IGF) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. According to the ETRM documentation, the table "holds the general setup information" and is explicitly flagged as Obsolete. This status designation is significant: while the object remains VALID in the data dictionary, Oracle no longer actively maintains or supports it in current release configurations, and its functional purpose has been superseded by other setup mechanisms within the Financial Aid module.

The heuristic Data Vault classification mined from the foreign key structure identifies this table as standalone. In modeling terms, a standalone classification suggests the table behaves as an isolated reference or configuration entity rather than participating in a hub-and-link topology with dependent child tables. Practitioners designing historical or analytical models around EBS Financial Aid setup data may therefore treat it as a self-contained satellite-like store of organization-scoped configuration flags.

Key Information Stored

The table contains twelve documented columns. The surrogate primary key is GENST_ID, enforced by the index IGF_AP_GEN_SETUP_PK, which is also the sole documented unique index and therefore the only business-key candidate identified in the ETRM metadata. The primary key constraint IGF_AP_GEN_SETUP_ALL_PK is defined on GENST_ID.

The remaining columns capture setup and processing behavior:

  • ORG_ID — the operating unit or organization context to which the setup row applies, enabling multi-org partitioning of configuration.
  • SSN_REQUIRED — a flag governing whether Social Security Numbers are mandatory for the associated financial aid processing.
  • AUTO_NA_COMPLETE — controls automatic completion of needs analysis processing.
  • AUTO_CORRECTION — governs whether the system automatically applies corrections during processing.
  • TRIGGER_WF — determines whether workflow events are initiated by the relevant transactions.
  • UPDATE_AWARD_STATUS — controls automatic updates to award status records.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO-column audit trail capturing record creation and modification provenance.

The combination of ORG_ID with the various boolean-style control flags indicates the table was intended to store one setup row per operating unit.

Common Use Cases and Queries

Because the object is obsolete, primary use cases center on legacy reporting, migration validation, and historical auditing rather than live transactional processing. A typical query retrieves current setup flags for a given organization:

  • SELECT GENST_ID, ORG_ID, SSN_REQUIRED, AUTO_NA_COMPLETE, AUTO_CORRECTION, TRIGGER_WF, UPDATE_AWARD_STATUS FROM IGF.IGF_AP_GEN_SETUP_ALL WHERE ORG_ID = :p_org_id;
  • Audit-trail extraction: SELECT GENST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGF.IGF_AP_GEN_SETUP_ALL ORDER BY LAST_UPDATE_DATE DESC;
  • Migration reconciliation, comparing legacy rows against the successor configuration tables to confirm that all organizations have been transitioned.

Reporting against this table should be treated as read-only and time-boxed, given its obsolete designation in 12.1.1 and 12.2.2.

Related Objects

The ETRM metadata documents no foreign key relationships, consistent with the standalone Data Vault classification—no child tables reference GENST_ID, and the table references no parent keys other than the implicit ORG_ID link to the organization definition. Related objects are therefore best understood functionally rather than through documented FK joins:

  • HR_OPERATING_UNITS / HR_ALL_ORGANIZATION_UNITS — joined via ORG_ID to resolve organization names.
  • Successor Financial Aid setup and needs-analysis configuration tables within the IGF schema that replaced this obsolete structure.
  • IGF award and disbursement processing tables whose behavior was formerly governed by the AUTO_NA_COMPLETE and UPDATE_AWARD_STATUS flags.
  • Standard EBS audit and WHO-column reporting views that consume CREATED_BY and LAST_UPDATED_BY.

Consultants should verify current configuration ownership against the active IGF setup objects before relying on this table in any 12.1.1 or 12.2.2 implementation.