Search Results as_grading_period




Overview
Explore in AI Chat

Overview

IGS_AS_GPC_UNIT_SETS_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, catalogued within the FND Design Data repository under the application short name IGS. In EBS 12.1.1 and 12.2.2 this object belongs to the Student Systems (Higher Education) product family, and more specifically to the Academic Support / Grading Period Configuration functional area, as indicated by the IGS_AS prefix. The view is classified by Oracle as a "supplementary view used to simplify forms coding," which means it exists primarily to support the Oracle Forms-based user interface rather than to serve as a public integration or reporting interface. It presents a denormalised projection that joins grading-period configuration rows to their associated unit sets, exposing both the numeric surrogate key (GPC_UNIT_SET_CD) and the descriptive attributes of the unit set (code, version, title) in a single result set.

Because the view is a forms-support construct, Oracle explicitly warns that it should not be queried or altered directly, and that its definition may change dramatically in subsequent minor or major releases. Consumers searching for the column gpc_unit_set_cd will therefore find it here, but should treat the view as a convenience layer rather than a stable API.

Underlying Base Objects

The documented dependency list shows that IGS_AS_GPC_UNIT_SETS_V is defined over the following objects, all owned by APPS:

The view is not referenced by any other database object, confirming its role as a terminal presentation layer within the forms stack. The owner of the documented metadata is not specified beyond APPS.

Key Columns

The view exposes twelve columns. ROW_ID is the standard ROWID row identifier. GPC_UNIT_SET_CD (NUMBER, 15) is the surrogate primary key of the grading period configuration to unit set relationship. GRADING_PERIOD_CD (VARCHAR2, 30) holds the lookup code, and GRADING_PERIOD (VARCHAR2, 80) its resolved description. UNIT_SET_CD (VARCHAR2, 10), UNIT_SET_VERSION_NUMBER (NUMBER), and UNIT_SET_TITLE (VARCHAR2, 90) describe the associated unit set. The remaining five columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are the standard WHO audit columns.

Common Use Cases and Queries

Typical use cases include diagnosing grading period to unit set assignments during student assessment configuration, verifying that a grading period has the correct unit sets attached, and reporting on unit set titles against grading periods. A representative query:

  • SELECT gpc_unit_set_cd, grading_period_cd, grading_period, unit_set_cd, unit_set_title FROM apps.igs_as_gpc_unit_sets_v WHERE grading_period_cd = :period;
  • SELECT unit_set_cd, unit_set_version_number, unit_set_title FROM apps.igs_as_gpc_unit_sets_v WHERE gpc_unit_set_cd = :id;

For production reporting, Oracle's guidance favours querying the base tables IGS_AS_GPC_UNIT_SETS and IGS_EN_UNIT_SET directly, since the view's shape may change between releases.