Results for “igs_fi_fund_src_hist”

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

Overview

The view IGS_FI_FUND_SRC_HIST belongs to the Oracle E-Business Suite product family IGS – Student System (formerly Oracle Student System, or OSF/IGS). In the ETRM documentation for Release 12.1.1 and 12.2.2, the object is explicitly flagged as Obsolete and is documented as Not implemented in this database. This designation indicates that the view forms part of the historical Oracle Student System financials schema, which predates the incorporation of student-records functionality into the Oracle Student Cloud and legacy EBS footprints, and that the object is not seeded or supported in a standard EBS installation.

Functionally, the view exposes historical funding-source information used to track changes to the funding sources attached to a student financial record over time. The name components — IGS (the product schema), FI (financials), FUND_SRC (funding source), and HIST (history) — confirm that it is a dated-history (row-versioned) reporting artifact. Its role was to provide a read-only, organization-secured projection of the underlying history table so that concurrent programs, reports, and integrations could retrieve point-in-time funding-source data without direct access to the base table.

Underlying Base Objects

Per the documented view text, IGS_FI_FUND_SRC_HIST is defined over a single base object: IGS_FI_FUND_SRC_HIST_ALL. The ETRM metadata records no other referenced base objects. The "_ALL" suffix and the presence of an ORG_ID filter column establish that the base object is a multi-organization (partitioned by operating unit) table, and that this view applies a row-level security predicate rather than the "_ALL" unrestricted form. This pattern is the standard EBS Multi-Org construct in which the base "_ALL" object holds data across all operating units while the secured view returns only rows belonging to the current organization.

The view text selects every significant attribute column from the "_ALL" table and adds A.ROWID ROW_ID as a surrogate identifier, because the view itself does not expose a single natural primary key. The ORG_ID security predicate derives the current organization from the USERENV('CLIENT_INFO') session value, using the conventional substring and DECODE technique to strip the leading partitioned identifier and coerce it to a numeric comparison; the NVL(…,-99) wrapper provides a default organization of -99 when the client context is unavailable. Because the base table is not implemented, the view exists only as metadata and will not resolve in a delivered environment.

Key Columns

• ROW_ID — The base-table ROWID, exposed as a pseudo identifier for the funding-source history row.
• FUNDING_SOURCE — The funding source code whose historical versions are tracked.
• HIST_START_DT / HIST_END_DT — The effective date range of the history record, defining the period during which this funding-source version was active.
• HIST_WHO — The user or process that created the historical version.
• DESCRIPTION — Descriptive text for the funding source at that point in time.
• GOVT_FUNDING_SOURCE — Indicator or code distinguishing government-funded sources from other sources.
• CLOSED_IND — Flag denoting whether the funding source was closed.
• ORG_ID — The operating unit to which the record belongs; drives the Multi-Org security predicate.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording creation and last modification actors and timestamps.

Common Use Cases and Queries

Because the object is obsolete and not implemented, it will not normally be queried in a current 12.1.1 or 12.2.2 environment. Should it appear, its historical purpose was to support audit and point-in-time reporting on funding sources. A representative query would be:

SELECT funding_source, hist_start_dt, hist_end_dt, govt_funding_source, closed_ind FROM igs_fi_fund_src_hist WHERE funding_source = :p_source ORDER BY hist_start_dt;

A validity-at-date query, useful for reconstructing the funding-source state on a given date, would filter on the history period:

SELECT funding_source, description FROM igs_fi_fund_src_hist WHERE :p_effective_dt BETWEEN hist_start_dt AND NVL(hist_end_dt, :p_effective_dt);

Organizations migrating off the legacy IGS schema should treat this view strictly as reference metadata; any active funding-source history requirement must be redirected to the supported successor objects.