Search Results igf_gr_rfms_disb_orig




Overview
Explore in AI Chat

Overview

The IGF_GR_RFMS_DISB_ORIG package is a member of the Oracle E-Business Suite Financial Aid (IGF) module, which is part of the Oracle Student System / Grants and Awards functionality. Within this framework it belongs to the Grants Reporting sub-component, as indicated by the GR token in its name, while the RFMS and DISB_ORIG tokens associate it with the RFMS Disbursement Origination process.

RFMS (the Records, Files and Management System used for federal grant disbursement-file exchange) requires institutions to originate, transmit, and acknowledge disbursement records for grant and loan awards. This package encapsulates the PL/SQL logic that generates the outbound RFMS disbursement originator file and processes the corresponding acknowledgement returned by RFMS. It is a standalone integration package rather than a general-purpose API: the ETRM metadata classifies it as OTHER and records it as being referenced by no other packages and by no other application code.

The package is documented under schema APPS with status VALID in both EBS 12.1.1 and 12.2.2, and its interface consists of exactly two documented program units: MAIN and MAIN_ACK.

Key Procedures and Functions

The ETRM record documents two procedures only. Parameter signatures are not published in the metadata and are therefore not reproduced here.

  • MAIN — the primary driver for the RFMS disbursement origination process. It is the entry point that selects eligible award disbursement records, applies the RFMS formatting and validation rules, and produces the outbound originator output. It is the program unit invoked when an institution runs the RFMS disbursement origination step.
  • MAIN_ACK — the counterpart routine that handles the RFMS acknowledgement (response) file. It consumes the returned file, matches acknowledgement records back to the originating disbursement rows, and records the acceptance or rejection outcome together with any error detail.

Both units operate against the Grants Reporting data model and are the only publicly documented programs in the package; no supporting private functions are exposed in the metadata.

Tables Accessed

The following objects are referenced through APPS synonyms:

  • IGF_GR_RFMS_ALL — the core RFMS control/processing table; referenced directly by the package and listed as a package-level dependency.
  • IGF_AW_AWD_DISB_ALL — award disbursement records; the source of the disbursement data that is transmitted in the originator file.
  • IGF_GR_LOAD_FILE_T — the staging structure used to load the inbound acknowledgement file contents.
  • IGF_GR_RFMS_ERROR — error repository for records that fail RFMS validation or are rejected in the acknowledgement.
  • IGF_GR_ATTEND_PELL — Pell attendance/enrollment data used to validate or derive disbursement eligibility.
  • IGF_GR_REPORT_PELL — Pell reporting data supporting the grant reporting extract.
  • IGS_PE_PERSID_GROUP_ALL — person identification data (student identifiers) needed to key RFMS records to the correct student.
  • FND_NEW_MESSAGES — the Oracle Application Object Library message table, used to resolve translatable message text for user-facing notifications and error output.

The package also depends on the STANDARD package from SYS.

Usage Notes

Because it is referenced by no other package, IGF_GR_RFMS_DISB_ORIG is not an internal utility called from other PL/SQL. It is invoked as a top-level integration routine, typically from a concurrent program registered against the package in the Grants Reporting responsibility, or from a wrapper program that prepares the RFMS batch before calling MAIN and subsequently calls MAIN_ACK to reconcile the returned response file. Institutions running RFMS in 12.1.1 and 12.2.2 should treat the package as a scheduled, file-driven process rather than an interactive one; its natural operating window is the RFMS reporting/disbursement cycle, and its outcome is recorded in IGF_GR_RFMS_ALL and IGF_GR_RFMS_ERROR. Any customization should respect the fact that the package exposes only these two entry points and that its dependencies are limited to the tables listed above.