Results for “igf_sp_prg”

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

Overview

IGF_SP_PRG is a Multi-Org (MO) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF (Financial Aid) product. Its status is VALID in both 12.1.1 and 12.2.2. The view presents fee classification program setup data — specifically the relationship between a fee classification and the academic program (course/program of study) to which a fee percentage or maximum amount applies. It is documented as an "MO view based on IGF_SP_PRG_ALL table," which identifies it as a reporting and integration layer rather than a base data-entry object. In an EBS Multi-Org context, the *_ALL table stores rows across all operating units, while the view filters that data to the operating unit of the current session, so applications, reports, and interfaces querying IGF_SP_PRG see only their organization's records without having to code the ORG_ID predicate themselves.

Underlying Base Objects

Per the ETRM metadata, the view is defined over a single base table, IGF_SP_PRG_ALL, aliased SFCLP in the view text. No additional referenced base objects are documented. The defining predicate is the standard EBS Multi-Org security construct:

• ORG_ID filter: The WHERE clause compares NVL(SFCLP.ORG_ID, ...) against the value derived from USERENV('CLIENT_INFO'), using NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99). This decodes the first ten characters of CLIENT_INFO — the operating unit identifier set by the Multi-Org initialization — and matches it to the row's ORG_ID. Rows with a NULL ORG_ID are treated as belonging to the "no org" bucket and are returned only when the session context resolves to -99.
• ROWID passthrough: The view exposes SFCLP.ROWID as ROW_ID, enabling updatable-view behavior through the Instead-Of triggers typically defined on MO views in EBS.

Key Columns

• ROW_ID — ROWID of the underlying IGF_SP_PRG_ALL row; supports update/delete through the view.
• FEE_CLS_PRG_ID — Primary key identifying a fee-class/program association record.
• FEE_CLS_ID — Foreign key to the fee classification to which the program-specific percentage or cap applies.
• COURSE_CD — Program or course code to which the fee classification is tied.
• VERSION_NUMBER — Version of the fee classification program record, supporting effective-dating style versioning.
• FEE_PERCENT — Percentage of the fee applied to the program.
• MAX_AMOUNT — Maximum fee amount applicable to the program.
• ORG_ID — Operating unit that owns the row; the column driving the Multi-Org filter.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN record who created and last changed each row.

Common Use Cases and Queries

Typical uses include fee classification reporting per program, validation of setup before financial aid processing, and integration extracts that must be operating-unit specific. Because the view applies the ORG_ID predicate automatically, queries return only data for the operating unit in the current session context.

Sample query returning fee percentages and caps for a given program:

• SELECT FEE_CLS_PRG_ID, FEE_CLS_ID, COURSE_CD, VERSION_NUMBER, FEE_PERCENT, MAX_AMOUNT, ORG_ID FROM IGF_SP_PRG WHERE COURSE_CD = :course_code;

Sample join to the fee classification for descriptive reporting:

• SELECT P.COURSE_CD, P.FEE_PERCENT, P.MAX_AMOUNT FROM IGF_SP_PRG P WHERE P.FEE_CLS_ID = :fee_cls_id AND P.ORG_ID = :org_id;

Note that explicitly supplying ORG_ID in the predicate is optional for the Multi-Org filter but useful for documentation and for predictable plans when querying outside a properly initialized session (for example, in SQL*Plus where CLIENT_INFO is unset). Because the object is a view, DML should be performed with the associated Multi-Org view triggers in place; direct table maintenance against IGF_SP_PRG_ALL bypasses the operating unit security enforced by this view.