Search Results igf_ap_efc_calc




Overview
Explore in AI Chat

Overview

The APPS.IGF_AP_EFC_CALC package body is a core component of the Oracle E-Business Suite Financial Aid module, part of the Oracle Student System (formerly Oracle Financial Aid, or IGF). Its principal business function is to calculate the Expected Family Contribution (EFC) for a student applicant based on the data captured on the processed ISIR (Institutional Student Information Record) and the institution's configured need-analysis assumptions. The EFC is the central figure used by financial aid offices to determine a student's eligibility for need-based aid; consequently, this package sits at the heart of the need-analysis engine.

The package encapsulates the rules, formulas, and institutional parameters used to derive EFC values. It reads the matched ISIR data, applies cost-of-attendance and assumption terms, handles alternate EFC factor configurations, and consistently returns an EFC value and an associated number of enrollment months. In Oracle EBS 12.1.1 and 12.2.2, the object is documented as VALID and classified as an OTHER API, meaning it is an internal engine rather than a formally published public API.

Key Procedures and Functions

The ETRM metadata documents two program units within this package body:

  • GET_EFC_NO_OF_MONTHS — Returns the number of months to be used in the EFC calculation. This value reflects the enrollment period for which the EFC is applicable and is typically derived from institutional cost-of-attendance terms and ISIR data.
  • CALCULATE_EFC — The primary routine that performs the actual Expected Family Contribution computation. It draws upon the matched ISIR record, institutional assumptions, and alternate EFC factor configurations to produce the EFC result.

No parameter lists are reproduced here, consistent with ETRM documentation practice; the procedures should be referenced through their documented signatures in the database.

Tables Accessed

The documented tables referenced via APPS synonyms are:

  • IGF_AP_ISIR_MATCHED_ALL — Stores all ISIR records matched to student applicants. The EFC engine reads this table to obtain the needs-analysis inputs from which the EFC is derived.
  • IGF_AW_COA_ITM_TERMS — Holds cost-of-attendance item terms, used to determine the enrollment months and the applicable cost basis for the EFC computation.
  • IGF_FC_EFC_ALT_FAC — Contains alternate EFC factor configurations, allowing institutions to apply different need-analysis parameters where applicable.

The package additionally depends on supporting objects such as IGF_AP_EFC_SUBF (EFC sub-functions), IGF_AP_FA_BASE_REC (base financial aid record), IGF_AP_ISIR_MATCHED, IGF_AP_EFC_V (EFC view), IGF_AP_ASSUMPTION_REJECT_EDITS, and IGS_CA_INST, reflecting its integration with the wider need-analysis subsystem.

Usage Notes

IGF_AP_EFC_CALC is an internal engine package. It is invoked indirectly by higher-level financial aid processing — typically during ISIR load, need-analysis batch runs, and award-year packaging — rather than called directly from a form or concurrent program by end users. The metadata records that the package is referenced by seven other database objects, confirming that other PL/SQL units within the Financial Aid schema depend on it. Because it is classified as OTHER rather than a public API, customizations should avoid direct invocation and instead reuse the standard need-analysis processing that calls it. Institutions modifying EFC rules should do so through supported configuration (assumptions, alternate EFC factors, and cost terms) rather than by editing this package, preserving upgrade safety across 12.1.1 and 12.2.2.