Search Results igs_gr_crmn_round_v




Overview
Explore in AI Chat

Overview

IGS_GR_CRMN_ROUND_V is a reporting view within the Oracle EBS IGS — Student System product family, historically associated with the Graduation (GR) module. In the ETRM 12.2.2 metadata the product is flagged as Obsolete and the implementation data states Not implemented in this database, meaning the object is retained for reference and upgrade completeness rather than active use in a standard installation. The view presents a denormalized, ceremony-centric picture of graduation award data by unioning four base objects into a single result set.

The view's distinguishing feature is its call to the PL/SQL function IGS_GR_GEN_001.GRDP_GET_ACUSG_TITLE, which is invoked with the primary key components of the ceremony round and returns a generated descriptive TITLE value. This is the exact usage pattern a user searching for "grdp_get_acusg_title" would encounter: the function is referenced inside the view text, not exposed as a standalone API. Reporting queries against the view therefore obtain the derived title transparently.

Underlying Base Objects

The view is defined as a UNION of four SELECT statements drawn from the following IGS Graduation objects:

  • IGS_GR_AWD_CRM_US_GP — award ceremony user group assignments, the most granular level and the only branch that supplies award, course, and user group values.
  • IGS_GR_AWD_CEREMONY — award ceremony linkage, supplying award and course identifiers while nulling the user group.
  • IGS_GR_CRMN — the ceremony master, supplying only calendar/ceremony-round context.
  • IGS_GR_CRMN_ROUND — the ceremony round, supplying the round context with all downstream identifiers nulled.

Each branch projects the same fourteen columns so the union is column-aligned. Branches that lack a value use TO_NUMBER('') or '' placeholders, which produce NULLs in the result set. The ETRM metadata documents no referenced base objects; the relationship above is derived from the view text itself.

Key Columns

Common Use Cases and Queries

Typical usage is to enumerate graduation ceremonies and rounds together with their award-level detail and generated titles, or to resolve which user groups are associated with a given award ceremony. Because lower branches contribute NULL award and course columns, queries usually filter or aggregate on the populated branch.

SELECT grd_cal_type, grd_ci_sequence_number, ceremony_number,
       award_cd, course_version, us_group_number, title
  FROM igs_gr_crmn_round_v
 WHERE award_course_cd IS NOT NULL;

To list ceremony rounds without award detail:

SELECT DISTINCT grd_cal_type, grd_ci_sequence_number, ceremony_number
  FROM igs_gr_crmn_round_v;

Practitioners should note the Obsolete status and confirm object availability in their specific 12.1.1 or 12.2.2 instance before relying on the view in new development or data extracts.