Search Results igf_sp_rollover




Overview
Explore in AI Chat

Overview

IGF_SP_ROLLOVER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an OTHER API rather than a public or private interface. Its declared purpose, as recorded in the package header comments, is the specification for the sponsor fund rollover and sponsor student relation rollover process. In practice this package supports the annual carry-forward logic used by institutions that administer Title IV and other student financial aid within the Oracle Student System / Financial Aid (IGF) product family in Release 12.1.1 and 12.2.2.

When an award year is closed and a new award year opens, sponsor funds and the relationships that tie a student to a particular sponsor program must be rolled into the new year so that disbursements, authorizations, and fund balances remain valid. IGF_SP_ROLLOVER encapsulates that batch process. The package declares AUTHID CURRENT_USER, so it executes with the privileges of the invoker rather than the definer, which is typical for internal APPS utility packages that are called by privileged batch sessions.

Key Procedures and Functions

The package exposes a single documented public procedure, SPONSOR_ROLLOVER. Based on the package specification, SPONSOR_ROLLOVER is the sole entry point for both rollover activities named in the header: sponsor fund rollover and sponsor student relation rollover. The procedure is designed to be launched as a concurrent program, which is confirmed by its first two parameters, an error buffer and a return code, both declared OUT NOCOPY, the standard signature for a PL/SQL stored procedure registered as a concurrent executable. The remaining inputs identify the award year to be processed, a rollover indicator, the specific fund to be processed, and a run mode that defaults to a committing run. No other procedures or functions are published in the specification.

Tables Accessed

IGF_SP_ROLLOVER works against a set of IGF and IGS tables resolved through APPS synonyms.

  • IGF_AW_FUND_MAST_ALL — the award fund master, the primary source and target for sponsor fund rollover rows; the fund_id parameter is typed from this table.
  • IGF_SP_FC_ALL — sponsor fund configuration/control data consulted when determining which funds are eligible for rollover.
  • IGF_SP_PRG_ALL — sponsor program definitions that group funds and drive rollover targeting.
  • IGF_SP_STDNT_REL_ALL — the sponsor student relation table, which holds the student-to-sponsor linkages that are rolled forward for the new award year.
  • IGF_SP_UNIT_ALL — sponsor unit records used to validate the organizational context of the funds being processed.
  • IGS_CA_INST_ALL — the calendar instance table, used to map award years to valid academic calendar periods.
  • IGS_FI_CONTROL_ALL — financial aid control settings that govern how the rollover behaves in a given installation.
  • FND_NEW_MESSAGES — the standard EBS message facility, used to emit diagnostic or error text to the concurrent manager log.

Usage Notes

The ETRM records that IGF_SP_ROLLOVER is referenced by zero other packages, indicating it is not a shared library consumed by other PL/SQL units. It is instead invoked at the top of the call stack, most commonly as a concurrent program submitted from the Financial Aid responsibility at the close of an award year, or by custom code reproducing that batch call for testing or remediation. Because the procedure is AUTHID CURRENT_USER and APPS-owned, any custom caller must run under a session with the appropriate IGF grants. The run mode parameter defaulting to a committing value means a production submission should be scheduled during a maintenance window, and the error buffer and return code should be checked in the concurrent request log to confirm that the rollover completed for the award year and fund specified.