Search Results igf_aw_fund_tp




Overview
Explore in AI Chat

Overview

IGF_AW_FUND_TP is a security-enabled (multirow) view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the IGF product family, Financial Aid, and presents fund-to-teaching-period percentage distribution data. The view exposes rows from its underlying table, IGF_AW_FUND_TP_ALL, after applying an organization-level (multi-org) filter built around the ORG_ID column and the USERENV('CLIENT_INFO') session context.

Its role in EBS reporting and integration is to provide a filtered, ORG-aware access point to fund teaching-period percentage records without requiring callers to re-implement the multi-org predicate. Standard Oracle multi-org views are typically consumed by concurrent programs, Oracle Reports, Oracle Forms, and custom SQL that runs under an APPS session that has its organization context set. Because it returns only rows whose ORG_ID matches the caller's current operating unit, it enforces data segregation at the database layer rather than relying solely on application logic. In the case of financial aid fund setups, this ensures a user assigned to one operating unit cannot read percentage distributions belonging to another. The object is reported as VALID, confirming that it compiles against the referenced base table in the documented environment.

Underlying Base Objects

The view is defined over a single documented base object, IGF_AW_FUND_TP_ALL, aliased as FTP in the ETRM view text. No additional joined tables, synonyms, or secondary objects are documented. The underlying table follows the standard EBS "_ALL" naming convention, meaning it physically stores rows for all operating units, with each row carrying an ORG_ID. The view applies the following predicate to that table:

  • The ORG_ID column is compared against a value derived from USERENV('CLIENT_INFO').
  • The expression NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99) is applied to both sides of the comparison.
  • The default value of -99 is used when CLIENT_INFO is unset, so records without a matching context are not returned unless they correspond to that sentinel.

In practice this is the familiar Oracle multi-org security pattern: the view retrieves the operating unit identifier from the client information string that the application sets at connect time, and only rows matching that identifier are visible.

Key Columns

  • ROW_ID — The ROWID pseudocolumn from the base table, exposed for row-level addressing.
  • FUND_ID — Identifier of the financial aid fund to which the teaching-period distribution belongs.
  • TP_CAL_TYPE — Calendar type associated with the teaching period.
  • TP_SEQUENCE_NUMBER — Sequence number identifying the specific teaching period within the calendar type.
  • TP_PERCT — The percentage of the fund attributed to the teaching period.
  • ORG_ID — Operating unit owning the record; drives the multi-org filter.
  • CREATED_BY, CREATION_DATE — Audit columns for record creation.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns for the most recent change.

Common Use Cases and Queries

Typical scenarios include validating that the teaching-period percentages for a fund total 100 percent, and joining fund teaching-period distributions to fund and calendar reference data for financial aid reporting.

  • Retrieving all distributions for a fund: SELECT fund_id, tp_cal_type, tp_sequence_number, tp_perct FROM igf_aw_fund_tp WHERE fund_id = :fund_id ORDER BY tp_sequence_number;
  • Checking percentage totals per fund and teaching period: SELECT fund_id, tp_cal_type, SUM(tp_perct) FROM igf_aw_fund_tp GROUP BY fund_id, tp_cal_type HAVING SUM(tp_perct) <> 100;
  • Listing recent changes: SELECT fund_id, tp_perct, last_updated_by, last_update_date FROM igf_aw_fund_tp WHERE last_update_date > SYSDATE - 30;

Because the view is ORG-filtered, any session querying it must have a valid operating unit context set; otherwise no rows are returned. Where unrestricted access across organizations is required, the base table IGF_AW_FUND_TP_ALL should be queried instead.