Search Results igs_fi_fund_src




Overview
Explore in AI Chat

Overview

IGS_FI_FUND_SRC is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It exposes funding source reference data used by the Student System financials modules, allowing institutions to define and maintain the funding bodies and programmes that underwrite student tuition, sponsorships, grants, and related financial aid arrangements. The view is documented as VALID in ETRM across both release 12.1.1 and 12.2.2.

Functionally, the view presents a filtered, organization-aware projection of the underlying funding source entity. Because it applies a multi-org security predicate derived from the USERENV('CLIENT_INFO') session attribute, it is the reporting-safe access path for the transactional tables and forms that store funding source references. Reporting tools, concurrent programs, and integration interfaces that need to resolve a funding source identifier to its descriptive text should query the view rather than the base table directly, so that the caller inherits the same operating unit security context enforced by the application.

Underlying Base Objects

The view is defined over a single documented base object, IGS_FI_FUND_SRC_ALL. The "_ALL" suffix follows standard EBS multi-org convention: the base table stores rows for every operating unit, with the organization identifier carried in the ORG_ID column. The view reduces this superset to the rows visible to the current session by comparing ORG_ID against the organization identifier decoded from the CLIENT_INFO value registered by the application. The predicate uses the form NVL(A.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99), which treats a blank or absent CLIENT_INFO prefix as the sentinel value -99. Rows whose ORG_ID is null are therefore mapped to the same sentinel and remain visible in sessions that have not registered an operating unit, preserving access for global or setup-level data.

No other referenced base objects are documented in the ETRM metadata. The view does not join to lookup or institution tables; descriptive values such as the funding source name are carried directly in the base table.

Key Columns

The view projects twelve columns, of which the following are of principal interest:

  • ROW_ID — the base table ROWID, exposed to support updatable-view and lock semantics for forms and programmatic DML.
  • FUNDING_SOURCE — the primary business key identifying the funding source. This is the value stored on downstream student financial records.
  • DESCRIPTION — the user-facing name or narrative for the funding source, used in reports and enquiry screens.
  • GOVT_FUNDING_SOURCE — a flag or classification indicating whether the funding source is a government body, which drives statutory reporting treatment.
  • CLOSED_IND — an availability indicator; closed funding sources should generally be excluded from new awards and from selection lists.
  • ORG_ID — the operating unit that owns the record, and the driving column of the view's security predicate.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording creation and last modification context.

Common Use Cases and Queries

Typical uses include current-day validation of funding source values during data entry, populating selection lists in custom forms and OAF pages, driving financial aid and sponsorship reporting, and resolving codes to descriptions in outbound interfaces. Because the view enforces operating unit security, it is also appropriate for multi-org aware extracts.

To retrieve all funding sources visible in the current session:

  • SELECT funding_source, description, govt_funding_source, closed_ind, org_id FROM apps.igs_fi_fund_src ORDER BY funding_source;

To restrict an enquiry or list of values to active funding sources only:

  • SELECT funding_source, description FROM apps.igs_fi_fund_src WHERE NVL(closed_ind, 'N') = 'N' ORDER BY description;

To identify government-funded sources for statutory reporting:

  • SELECT funding_source, description, org_id FROM apps.igs_fi_fund_src WHERE govt_funding_source = 'Y';

Because the view returns only rows matching the session's operating unit context, callers running outside a registered CLIENT_INFO (for example, certain concurrent programs or SQL*Plus sessions) will see only rows whose ORG_ID maps to the -99 sentinel. Where a full cross-organization extract is required, the base table IGS_FI_FUND_SRC_ALL should be queried instead, with the appropriate organization security logic applied by the calling program.