Search Results group_title




Overview
Explore in AI Chat

Overview

IGS_GR_AWD_CRM_US_GP_V is a database view belonging to the IGS (Student System) product family in Oracle E-Business Suite. In ETRM metadata it is classified as part of the obsolete IGS module, and it is documented as not implemented in the reference database. The view is defined over the graduation award ceremony grouping structure and exists primarily to surface a resolved group_title value for ceremony reporting. Specifically, the view exposes the unique group title as either the stored override_title on the underlying base record or a derived value computed by the IGS_GR_GEN_001.GRDP_GET_ACUSG_TITLE function. This makes the view a presentation-layer convenience object: consumers do not need to reproduce the override-versus-derived logic themselves, and the returned string is truncated consistently to 90 characters.

Underlying Base Objects

The view is defined over a single documented base object, IGS_GR_AWD_CRM_US_GP (aliased ACUSG). This table stores award ceremony user-defined groupings tied to a graduation calendar, ceremony, and award. The ETRM metadata records no additional referenced base objects, so the join logic is effectively a projection with one function call against the base row. The derived title is produced by the graduation module function IGS_GR_GEN_001.GRDP_GET_ACUSG_TITLE, which takes the full primary key context as arguments: graduation calendar type, calendar instance sequence number, ceremony number, award course code, award course version number, award code, and user group number. Because all primary key columns are passed through, the function resolves the title deterministically for each row.

Key Columns

Common Use Cases and Queries

Typical usage is ceremony and award-grouping reporting, where the resolved title must appear consistently without re-implementing the override logic in reporting tools or interfaces. A simple retrieval by ceremony context is common:

SELECT grd_cal_type, grd_ci_sequence_number, ceremony_number, award_cd, us_group_number, order_in_award, group_title, closed_ind FROM igs_gr_awd_crm_us_gp_v WHERE grd_cal_type = :p_cal AND grd_ci_sequence_number = :p_seq AND ceremony_number = :p_cer ORDER BY award_cd, order_in_award;

A second pattern lists only open groups for a given award course and version, supporting ceremony programme generation and printing:

SELECT award_cd, us_group_number, group_title FROM igs_gr_awd_crm_us_gp_v WHERE award_course_cd = :p_course AND award_crs_version_number = :p_ver AND closed_ind = 'N' ORDER BY order_in_award;

Because the view has no join fan-out and no documented dependencies beyond the single base table, it is inexpensive to query and safe for set-based extraction into staging tables. The primary caveat is the metadata note that the view is not implemented in the reference database and belongs to the obsolete IGS product line; implementations on EBS 12.1.1 or 12.2.2 should confirm the object exists in the target instance and that the IGS_GR_GEN_001 function package is compiled and valid before relying on the derived title.