Search Results generate_aggregate_data




Overview
Explore in AI Chat

Overview

IGF_AW_FISAP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name associates it with the IGF (Financial Aid / Student Systems) application family and, more specifically, with the "AW" (Award) sub-module and the FISAP reporting process. FISAP (Fiscal Operations Report and Application to Participate) is the annual reporting vehicle through which institutions participating in Title IV federal student aid programs report prior-year expenditures and request funding for the coming year. This package encapsulates the extraction, aggregation, and report-generation logic required to populate the FISAP report from the institution's award, disbursement, and payment data. The package is classified under the ETRM API classification "OTHER," meaning it is an internal, process-oriented package rather than a public, supported application programming interface. It is version-independent in the sense that its documented structure and dependencies apply to both EBS 12.1.1 and 12.2.2 environments, since the underlying IGF data model is unchanged across those releases.

Key Procedures and Functions

The ETRM repository documents three procedures or functions within IGF_AW_FISAP_PKG:

  • MAIN — The primary entry point and driver of the package's processing. It is presumed to orchestrate the overall FISAP data preparation sequence, invoking the aggregation and reporting routines in the correct order and applying the applicable reporting parameters (such as reporting year and range definitions).
  • GENERATE_AGGREGATE_DATA — Populates the aggregate data required for FISAP reporting. This routine consolidates award, disbursement, and payment records into the summary form required by the FISAP report structure.
  • GENERATE_PARTII — Produces the Part II portion of the FISAP report. Part II of the FISAP addresses the fiscal operations of the institution's Title IV programs and is generated from the aggregated disbursement and payment data prepared by the preceding routine.

Specific parameter lists are not published in the available metadata and are therefore not documented here; callers should inspect the package specification in the APPS schema for the exact signatures.

Tables Accessed

The package references a substantial set of APPS synonyms, indicating both read and write activity. Key tables include IGF_AW_FISAP_BATCH, IGF_AW_FISAP_RANGES, and IGF_AW_FISAP_REP, which store the batch control, reporting ranges, and generated report output for FISAP processing. Award and disbursement data are read from IGF_AW_AWARD_ALL and IGF_AW_AWD_DISB_ALL, with funding detail drawn from IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL. Payment and authorization information comes from IGF_SE_PAYMENT and IGF_SE_AUTH. Batch mapping and base records are handled through IGF_AP_BATCH_AW_MAP_ALL and IGF_AP_FA_BASE_REC_ALL. Academic context is sourced from IGS_CA_INST_ALL and IGS_EN_SPA_TERMS, and the generated XML output is persisted via IGF_GR_PELL_GEN_XML_S. The package also reads FND_USER, presumably for audit or created-by tracking. Dependencies are otherwise limited to SYS and STANDARD.

Usage Notes

Because IGF_AW_FISAP_PKG is an internal "OTHER"-class package with no dependent packages, it is not intended for direct invocation by third-party customization. It is typically called by the FISAP concurrent program or by the FISAP setup and generation forms within the Financial Aid module, which pass reporting parameters and trigger the MAIN routine. Direct custom calls should be avoided; instead, customers should use the supported FISAP concurrent programs and report templates. The package is listed as VALID in the ETRM repository, confirming it compiles cleanly against the documented 12.1.1 and 12.2.2 schemas.