Search Results genst_id




Overview
Explore in AI Chat

Overview

IGF_AP_GEN_SETUP is a multiorganization (MOAC) security view owned by the APPS schema within the IGF – Financial Aid product family. Its documented purpose is to retrieve general setup information for the IGF application. In Oracle EBS 12.1.1 and 12.2.2, the view serves as an org-striped reporting and integration interface over the underlying setup table IGF_AP_GEN_SETUP_ALL, exposing a single row per operating unit (ORG_ID) for the configuration flags that govern financial aid processing behavior.

The view is registered in ETRM as a VALID database object. It is commonly referenced by concurrent programs, forms, and custom reports that must resolve the current operating unit's financial aid setup without directly querying the _ALL table. Because the row filter is driven by USERENV('CLIENT_INFO'), the view returns only the setup record belonging to the operating unit currently established in the session.

Underlying Base Objects

The view is defined over a single documented base object: IGF_AP_GEN_SETUP_ALL. No additional referenced base objects are documented in the ETRM metadata. The defining query selects GENST_ID, ORG_ID, SSN_REQUIRED, AUTO_NA_COMPLETE, three literal NULL columns, and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) from the _ALL table.

The WHERE clause implements the MOAC pattern typical of 12.1.1 and 12.2.2: it extracts the first ten bytes of USERENV('CLIENT_INFO') — the session's current operating unit identifier — converts it to a number, substitutes -99 when the value is blank, and compares it against NVL(ORG_ID, -99). Rows with a NULL ORG_ID (global or seed data) therefore remain visible, while operating-unit-specific rows are limited to the active org. The three NULL placeholders in the SELECT list indicate columns documented at the _ALL level (AUTO_CORRECTION, TRIGGER_WF, UPDATE_AWARD_STATUS) that are not projected through this view.

Key Columns

  • GENST_ID — Primary key of the financial aid general setup record; the unique identifier users most frequently search on when locating the setup row for a given operating unit.
  • ORG_ID — Operating unit identifier. NULL indicates the record is not organization-specific and applies across all operating units.
  • SSN_REQUIRED — Flag indicating whether a Social Security Number is mandatory during financial aid data entry.
  • AUTO_NA_COMPLETE — Flag controlling whether needs analysis records are automatically completed by the system.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle WHO audit columns recording record creation and last modification metadata.

Common Use Cases and Queries

The view is most often queried to verify configuration for the active operating unit, to drive conditional logic in concurrent programs, or to diagnose why a financial aid process behaved unexpectedly. Typical access patterns include:

  • Looking up setup by primary key when investigating a specific GENST_ID.
  • Confirming whether SSN capture or automatic needs analysis completion is enabled for the current org.
  • Auditing who last changed the setup record and when.

Sample queries:

SELECT genst_id, org_id, ssn_required, auto_na_complete
FROM  apps.igf_ap_gen_setup;

SELECT genst_id, org_id, ssn_required
FROM  apps.igf_ap_gen_setup
WHERE  genst_id = :genst_id;

Because access is filtered by CLIENT_INFO, results depend on the operating unit initialized in the session; queries executed without an established org context return only the global (NULL ORG_ID) setup row.