Search Results disb_process

Overview

IGF_DB_DISB is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System / Financial Aid (IGF) product family. Its name derives from the functional area it addresses: disbursement (DISB) processing for student financial aid awards and loan funds. In the Oracle EBS 12.1.1 and 12.2.2 releases, the package acts as the back-end processing engine that translates an approved award or loan into an actual disbursement transaction against the student's account and the institution's funds.

Its documented dependencies confirm this role: it reads award, fund, and disbursement tables, writes disbursement schedule records, and integrates with receivables/funds management structures (IGF_GR_RFMS_ALL) and student loan records (IGF_SL_LOANS_ALL). Because the ETRM metadata marks the object status VALID and lists the package body as the primary artifact, IGF_DB_DISB is an operational (non-API) package rather than a public interface; it is invoked by other EBS components rather than by end users directly.

Key Procedures and Functions

The package exposes three documented procedures. The naming convention follows the IGF module standard of verb-noun action names, and each procedure corresponds to a stage in the disbursement lifecycle:

• DISB_PROCESS — The primary driver procedure. It performs the bulk disbursement run: selecting eligible awards, applying fund and disbursement-schedule rules, and creating the disbursement transactions that constitute the actual release of funds.
• PROCESS_STUDENT — The single-student variant. It executes the same disbursement logic scoped to one student, supporting on-demand or student-level re-processing without a full batch run.
• REVERT_DISB — The reversal procedure. It undoes a previously created disbursement, rolling back the associated disbursement and fund records when an award is cancelled, returned, or corrected.

The ETRM record does not publish parameter lists for these procedures; they should be treated as internal interfaces and inspected in the database before use. No public API classification is assigned (OTHER), reinforcing that the package is intended for internal module use.

Tables Accessed

The documented table references cover the three data domains the package must reconcile: awards, funds, and students/parties.

• Award and disbursement tables — IGF_AW_AWARD_ALL and IGF_AW_AWD_DISB_ALL supply the award header and the award disbursement schedule that determine what amount is due and when.
• Fund management tables — IGF_AW_FUND_MAST_ALL, IGF_AW_FUND_CAT_ALL, IGF_AW_FUND_TD_MAP_ALL, IGF_AW_FUND_TP_ALL, and IGF_GR_RFMS_ALL provide fund definitions, fund categories, and the awards-to-funds mapping required to source the money being disbursed.
• Student and party tables — HZ_PARTIES and IGS_CA_INST_ALL identify the recipient and the academic calendar instance, while IGF_SL_LOANS_ALL, IGF_AP_TD_ITEM_MST_ALL, IGF_AP_TD_ITEM_INST_ALL, and IGF_AP_FA_BASE_REC_ALL carry loan and term-level item detail used in eligibility and calculation.
• Staging and messaging — IGF_DB_PAYS_PRG_T acts as the payees/progress staging table for the disbursement run, and FND_NEW_MESSAGES records processing outcome messages for user notification.

Usage Notes

IGF_DB_DISB is referenced by only one other package, IGF_AW_CANCEL_AWD, which calls it when an award cancellation requires disbursement reversal. It also references itself internally, consistent with a package body that calls its own subroutines. Typical invocation paths are the Financial Aid disbursement concurrent programs and the award maintenance forms, both of which operate through the package rather than issuing direct DML against the disbursement tables.

Because the package is not classified as a public API, customizations should avoid invoking it directly in place of the supported concurrent programs; doing so risks bypassing validation, message logging in FND_NEW_MESSAGES, and fund reconciliation. When debugging disbursement discrepancies, examine IGF_DB_PAYS_PRG_T for staging state and FND_NEW_MESSAGES for the diagnostics the package writes during DISB_PROCESS.