Search Results grdp_set_gr_gst




Overview

IGSGRJ02 is an Oracle E-Business Suite concurrent program belonging to the IGS – Student System product family, historically one of the core modules within the Oracle Student System (OSS) and, in later releases, the Student Information Management component of Oracle E-Business Suite. The program is exposed to end users under the user-facing name Assign Graduand Status, and its documented purpose is to assign graduand status to eligible students as part of the graduation and conferral lifecycle. In the ETRM 12.2.2 documented metadata the owning product is listed as IGS – Student System (Obsolete), with the program still flagged as Enabled: Yes. The term graduand is used in the Student System to describe a student who is eligible for, or actively proceeding toward, the award of a degree or other qualification — that is, a student who has completed or is completing all academic requirements but has not yet had the award formally conferred. The program populates or updates the graduand status field on the relevant student record, which in turn drives downstream processes such as graduation eligibility, ceremony attendance, and award conferral processing.

Execution Details

The concurrent program is configured with a PL/SQL Stored Procedure execution method and uses the Standard argument method. Its executable name is IGSGRJ02 (the same as the short name), and the documented execution file reference is:

The execution file notation IGS_GR_GEN_002.GRDP_SET_GR_GST identifies the PL/SQL package IGS_GR_GEN_002 and the stored procedure GRDP_SET_GR_GST within it. The GRDP_ prefix is characteristic of the graduation-processing layer of the Student System, while the _SET_ portion indicates that the procedure performs an assignment or update operation rather than a validation or report. This is the routine the concurrent manager invokes when the request runs, and the standard argument method means the program’s parameters are defined in the usual way in the concurrent program definition and passed positionally to the stored procedure. As a PL/SQL stored procedure submission, no executable binary or report template is involved; the work is performed entirely inside the database.

How to Run

Because this object is a concurrent program, it is normally submitted through the Standard Request Submission (SRS) window, or, in newer user interfaces, through the Submit Request page. A user with access to the Graduation and Conferral responsibility — or the relevant IGS responsibility containing this request group — navigates to the Submit Request screen, queries or selects Assign Graduand Status, and submits the request to the concurrent manager. When the user searched for grdp_set_gr_gst, that string corresponds precisely to the stored procedure invoked by this program, which is why the concurrent program is the correct object match. Parameter definitions are not itemised in the ETRM excerpt supplied; the argument method is Standard, so any parameters defined against IGSGRJ02 in the Concurrent Programs form are passed, in order, to IGS_GR_GEN_002.GRDP_SET_GR_GST. Typical practice in the Student System is to provide a graduation term or period, a career or program identifier, and possibly a student identifier or range, so that the graduand assignment can be restricted to the cohort being processed. Users should confirm the active parameter list against their system’s concurrent program definition before submission, since the ETRM metadata does not enumerate them.

Related Objects

The program operates within the graduation-processing schema of the Student System and is closely associated with the following kinds of objects:

  • Graduation processing package: IGS_GR_GEN_002, the package containing the invoked procedure GRDP_SET_GR_GST.
  • Graduation and conferral request group: the SRS request group that typically exposes IGSGRJ02 alongside related graduation programs.
  • Student and graduation interface tables: the graduand and graduation application records held in the IGS graduation tables, which the procedure updates when assigning graduand status.
  • Related graduation concurrent programs: other IGSGRJ programs in the same family that handle graduation eligibility, graduation application processing, and award conferral.
  • Award and conferral processes: downstream logic that consumes graduand status to determine award eligibility and ceremony inclusion.

Because the product is documented as obsolete, organisations still running this program should treat it as legacy functionality and review Oracle’s current student-system replacement guidance for the equivalent business process.