Search Results grdp_del_gr_gac

Overview

Concurrent Program IGSGRJ03, presented to users under the name Clean Up Graduand Records, belongs to the Oracle Student System (product code IGS) — the module that supports the administration of student records, admissions, enrollment, and graduation processing. In the ETRM 12.2.2 catalog the product is flagged as obsolete, and the program itself is marked Enabled: Yes, meaning it may still be submitted in an environment where the legacy Student System objects remain deployed.

The program performs administrative maintenance on graduand data. A graduand is a student who has completed all academic requirements and is pending the conferral of an award. Over time, incomplete or superseded graduand records accumulate — for example, when a graduation application is withdrawn, a curriculum is revised, or a set of award records is regenerated. IGSGRJ03 provides a batch mechanism for removing such records so that the graduand and graduation-award tables remain consistent with the current academic state. It is a housekeeping utility rather than a functional transaction, and it is normally executed after the graduation cycle has been finalised and audited.

Execution Details

The documented execution metadata for this program is as follows:

• Concurrent Program: IGSGRJ03
• User-facing name: Clean Up Graduand Records
• Product: IGS — Student System (Obsolete)
• Enabled: Yes
• Execution Method: PL/SQL Stored Procedure
• Argument Method: Standard
• Executable: IGSGRJ03
• Execution File: IGS_GR_GEN_001.GRDP_DEL_GR_GAC

The execution file designation IGS_GR_GEN_001.GRDP_DEL_GR_GAC identifies the PL/SQL package IGS_GR_GEN_001 and the stored procedure GRDP_DEL_GR_GAC within it. This is the routine that the Concurrent Manager invokes when the program runs, and the procedure name corresponds to the search string grdp_del_gr_gac that users frequently associate with this concurrent program. Because the Argument Method is Standard, any parameters defined for the program are passed positionally in the order declared in the concurrent program definition. No subroutine name is recorded, which is consistent with a direct PL/SQL procedure call.

How to Run

IGSGRJ03 is submitted through the standard Oracle EBS Submit Request (SRS) window: navigate to Requests > Run, query the request by name Clean Up Graduand Records or by the short name IGSGRJ03, and submit. Because the program is an obsolete Student System object, it may not appear in the default responsibility menu; access typically requires the relevant Student System responsibility or a System Administrator role with explicit request-group grants.

Parameter guidance should be confirmed against the program's own parameter list, since ETRM documents only the standard argument method and not the individual arguments. In practice, cleanup programs of this class accept selection criteria such as the person or student identifier, the graduation term or award period, and possibly a commit or report-only flag. Users should run the program first in report-only or validation mode where available, verify the affected record count against the graduation audit report, and only then execute the destructive pass during a scheduled maintenance window. A database backup or export of the affected graduand rows is advisable before committing deletions.

Related Objects

The program operates on the graduand and graduation-award entity tables and their related APIs within the Student System schema. Commonly associated objects include:

• Graduand and graduation-award base tables under the IGS schema, including graduation application and award records.
• The IGS_GR_GEN_001 package, which contains the GRDP_DEL_GR_GAC procedure executed by this program.
• Graduation processing concurrent programs in the same family, such as graduand generation and award finalisation routines that create the records this program later cleans up.
• Student System APIs for graduation, which should be used for supported transactional changes; direct deletion via this program is intended only for administrative cleanup.
• Graduation audit and exception reports used to reconcile record counts before and after execution.

Because the IGS module is marked obsolete in 12.2.2, institutions migrating to the Oracle Student Cloud or a successor product should decommission this program along with the remaining Student System components.