Results for “igf_aw_fund_excl”

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

Overview

IGF_AW_FUND_EXCL is an Oracle E-Business Suite view belonging to the IGF (Financial Aid) product family. In the ETRM metadata it is explicitly flagged as obsolete and is recorded with the status "Not implemented in this database." The view is the organization-secured (multi-tenant) counterpart of the IGF_AW_FUND_EXCL_ALL table, and it is designed to expose only those fund exclusion rows that are visible to the currently connected organization. Its principal role is to serve as the reporting and integration surface through which fund exclusion records are queried within the Financial Aid module.

A fund exclusion identifies a fund that must be excluded from a particular award or eligibility calculation. Rather than permitting callers to read the _ALL table directly and risk returning data for organizations they are not authorized to see, application logic and reports are expected to query this view, leaving the row-level filtering to the database.

Underlying Base Objects

The metadata documents a single referenced base object: the table IGF_AW_FUND_EXCL_ALL, aliased as FEXC in the view definition. The view is therefore a thin, security-enforcing projection over that table and contains no joins, aggregations, or derived business logic. This one-to-one relationship means every column exposed by the view originates directly from IGF_AW_FUND_EXCL_ALL, and all inserts, updates, and deletions must be directed at the base table rather than the view.

The organization filter is implemented in the WHERE clause by comparing FEXC.ORG_ID with the value returned from the USERENV('CLIENT_INFO') session parameter. The view parses the first ten characters of CLIENT_INFO, converts them to a number, and treats both blank and NULL client information as the sentinel value -99. A row is returned only when its ORG_ID matches that resolved value, which is the standard Oracle Application Object Library multi-org security pattern used throughout EBS 12.1.1 and 12.2.2.

Key Columns

• ROW_ID — the physical row identifier from the base table, selected as FEXC.ROWID; used for positioned updates and row-level addressing.
• FUND_ID — the surrogate key identifying the excluded fund.
• FUND_CODE — the user-facing code of the fund, used in reports and validation logic.
• ORG_ID — the operating unit to which the exclusion record belongs; this is the column that drives the multi-org security predicate.
• CREATED_BY, CREATION_DATE — standard audit columns recording the creating user and timestamp.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns capturing the most recent modification, its author, and the login session.

Common Use Cases and Queries

The view is typically consumed by Financial Aid reports, concurrent programs, and interfaces that need to resolve which funds are excluded for the active operating unit without hard-coding organization logic. A simple retrieval of exclusions for the current organization takes the form:

SELECT fund_id, fund_code, org_id FROM igf_aw_fund_excl ORDER BY fund_code;

A more specific lookup retrieves the exclusions for a single fund code:

SELECT fund_id, fund_code FROM igf_aw_fund_excl WHERE fund_code = :p_fund_code;

Because the view has no ORG_ID restriction available to the caller beyond the CLIENT_INFO mechanism, any query issued from a session whose client information is not initialized resolves ORG_ID to -99 and generally returns no rows. This behavior should be expected and is not a defect.

Given the obsolete classification and the "Not implemented in this database" note in the ETRM record, consultants should confirm the object's presence in the target instance before relying on it. Where the view is absent, equivalent results can be obtained directly from IGF_AW_FUND_EXCL_ALL, provided the query applies its own ORG_ID predicate. Oracle recommends migrating any dependent custom code away from this obsolete view in favor of supported Financial Aid data access paths.