Search Results igs_en_gen_008




Overview
Explore in AI Chat

Overview

The view APPS.IGS_PS_OFR_OPT_UNIT_SET_V is a student-system reporting object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, delivered as part of the Oracle Student System (formerly iGS) product family. It exposes the association between unit sets and the course offerings (course option occurrences) to which those unit sets apply, combining data from the curriculum offering model with structural unit-set definitions. The view collects unit-set identity and status information together with offering-level attributes such as course code, calendar type, location, and attendance details, producing a denormalised structure intended for inquiry screens, concurrent reports, and integration extracts.

A distinguishing characteristic of the view is its use of a UNION ALL across two branches, reflecting two distinct ways in which a unit set may be attached to an offering: directly at the course-offering option level, or at the course-option occurrence level. The first branch returns offerings that have no child occurrence records, while the second returns those explicitly defined at the occurrence level. This pattern ensures that every valid unit-set/offering combination is surfaced exactly once, avoiding double counting while preserving complete coverage.

Underlying Base Objects

Although the documented ETRM metadata lists no referenced base objects, the view text identifies the following tables: IGS_PS_OFR_UNIT_SET, which maps unit sets to course offerings at the offering-option level; IGS_PS_OFR_OPT, holding the course offering option records; IGS_EN_UNIT_SET, the master unit-set definition containing title, status, category, and validity dates; and IGS_PS_OF_OPT_UNT_ST, the course-option occurrence-to-unit-set association. Joins are driven by unit_set_cd, version_number, course_cd, crv_version_number, and CAL_TYPE. The first branch filters delete_flag = 'N' on the offering option and excludes offerings with occurrence records via a NOT EXISTS subquery, while the second branch joins directly through the occurrence table.

Key Columns

Common Use Cases and Queries

Typical applications include validating unit-set attachment to offerings, generating curriculum catalogues, and driving integration payloads. A representative query filters by course and calendar type:

SELECT unit_set_cd, version_number, course_cd, cal_type, unit_set_status
FROM apps.igs_ps_ofr_opt_unit_set_v
WHERE course_cd = :course AND cal_type = :cal_type;

Analysts also use the view to audit offerings without occurrence-level overrides, or to reconcile unit-set titles produced by IGS_EN_GEN_008 against master definitions in IGS_EN_UNIT_SET. Because it is a view rather than a table, no DML should be issued against it.