Search Results igf_gr_alt_exp

Overview

The IGF_GR_ALT_EXP view is a reporting and data-access object within the IGF — Financial Aid product family of Oracle E-Business Suite (documented against ETRM 12.2.2, and applicable to 12.1.1). It presents the Alternate Schedule Expense ranges that define the Alternate Pell Payment Schedule. In the context of Pell grant processing, institutions and the U.S. Department of Education use alternate schedules to determine award amounts for students enrolled in non-standard programs or in clock-hour/correspondence coursework. The view exposes the valid expense (cost-of-attendance) brackets — defined by a start and end value — against which the alternate payment schedule is applied.

The object is owned by the APPS schema and is documented as VALID. It is a security-enabled (Multi-Org) view: the underlying table is IGF_GR_ALT_EXP_ALL, and the view applies an operating-unit filter using the standard ORG_ID pattern driven by USERENV('CLIENT_INFO'). Because it is a view rather than a base table, no direct DML should be issued against it; modifications must target the underlying _ALL table through the appropriate application forms or APIs.

Underlying Base Objects

Per the documented view text, IGF_GR_ALT_EXP is defined over a single base object:

• IGF_GR_ALT_EXP_ALL — the multi-org base table holding the alternate schedule expense range rows across all operating units. No other referenced base objects are documented in the ETRM metadata.

The view selects every column from the base table and enforces row-level operating unit security through the predicate on ORG_ID. The USERENV('CLIENT_INFO') expression extracts the first ten characters as the current operating unit; where the value is blank, it resolves to -99 (an unassigned/global context). This means a query executed within an operating unit context returns only that unit's rows (plus any rows stored with the sentinel value).

Key Columns

• ROW_ID — the pseudo-rowid of the base table row.
• ORG_ID — operating unit identifier; the driver of the Multi-Org security filter.
• ALTEXP_ID — primary/surrogate key identifying the expense range record.
• ALTCOA_ID — foreign key linking the range to its parent Alternate Cost-of-Attendance / schedule definition.
• EXP_START — lower bound of the expense range.
• EXP_END — upper bound of the expense range.
• CREATED_BY, CREATION_DATE — audit columns capturing record creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns capturing the most recent change and login session.

Common Use Cases and Queries

Typical scenarios include validating that configured expense brackets are contiguous and complete, integrating alternate Pell schedule data into custom reports, and reconciling cost-of-attendance ranges across operating units.

• List all expense ranges for the current operating unit:

SELECT alteexp_id, altcoa_id, exp_start, exp_end
FROM   igf_gr_alt_exp
ORDER BY altcoa_id, exp_start;

• Find gaps or overlaps within a schedule:

SELECT a.altcoa_id, a.exp_end, b.exp_start
FROM   igf_gr_alt_exp a, igf_gr_alt_exp b
WHERE  a.altcoa_id = b.altcoa_id
AND    b.exp_start > a.exp_start
AND    b.exp_start > a.exp_end + 1;

• Audit recently modified ranges:

SELECT alteexp_id, exp_start, exp_end, last_updated_by, last_update_date
FROM   igf_gr_alt_exp
WHERE  last_update_date >= SYSDATE - 30;

Because the view is Multi-Org secured, queries return only rows visible to the operating unit established by the session's CLIENT_INFO context; use FND_CLIENT_INFO or the standard initialization routines when running outside the EBS form/OCM environment.