Search Results rfms_load

Overview

IGF_GR_PELL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, part of the Financial Aid module within the Oracle Student System / Grants product family. The package supports the Pell Grant processing lifecycle, specifically the RFMS (Recipient Financial Management System) integration used by institutions to receive and reconcile federal Pell Grant disbursement funding. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it is classified as an "OTHER" API, meaning it is an internal processing package rather than a public, supported extension API. The package name suggests a Grants (GR) submodule role: it aggregates Pell-specific logic for loading RFMS files, deriving origination identifiers, and determining enrollment dates for award and disbursement calculations.

Key Procedures and Functions

Three documented procedures and functions constitute the package's public interface:

• RFMS_LOAD — Loads and processes RFMS data, mapping external funding and disbursement records into the IGF Grants tables. This is the primary driver for importing RFMS-returned Pell funding information into EBS.
• GENERATE_ORIGINATION_ID — Produces the origination identifier used to uniquely tag a Pell award or disbursement for reporting and reconciliation against the RFMS system.
• GET_ENROLLMENT_DATE — Retrieves the applicable enrollment date for a student, used to drive Pell award periods and attendance-based calculations against institution calendar data.

No parameter lists are documented; the signatures should not be inferred. All three procedures act on IGF Grants data and are invoked internally during Pell processing.

Tables Accessed

IGF_GR_PELL reads and writes a defined set of Grants and Financial Aid tables via APPS synonyms:

• IGF_AP_FA_BASE_REC_ALL — the financial aid base record, providing the core student award record the package anchors to.
• IGF_AW_AWARD_ALL and IGF_AW_AWD_DISB_ALL — award and disbursement headers/lines, where Pell amounts are attributed.
• IGF_GR_ATTEND_PELL — Pell attendance/enrollment data used by GET_ENROLLMENT_DATE.
• IGF_GR_PELL_SETUP_ALL — Pell setup and configuration records controlling processing behavior.
• IGF_GR_REPORT_PELL — Pell reporting records populated during RFMS_LOAD.
• IGF_GR_RFMS_ALL — the RFMS staging/import table, the target of RFMS_LOAD.
• IGS_CA_INST_ALL — institution/calendar data supporting enrollment date derivation.

Usage Notes

Because IGF_GR_PELL is an OTHER-classified internal package, it is not intended for direct customer invocation. It is referenced by IGF_GR_LI_IMPORT, indicating it is called from the Grants Pell import flow, and it also references itself internally. Typical invocation is through concurrent programs or batch processing that ingest RFMS files: RFMS_LOAD parses the inbound funding file, GENERATE_ORIGINATION_ID tags records, and GET_ENROLLMENT_DATE resolves the enrollment period used for award calculation. Customers customizing or extending Pell processing should do so at the supported interface boundaries rather than modifying this package, since its internals may change with patching. For troubleshooting, the dependency list provides the effective trace path when diagnosing load or reconciliation errors.