Search Results igs_ps_ofr_opt_unit_set_v




Overview
Explore in AI Chat

Overview

IGS_PS_OFR_OPT_UNIT_SET_V is a view within the Oracle EBS Student System (product code IGS), a module classified as obsolete in the ETRM 12.1.1 and 12.2.2 reference. The view exposes the association between unit sets and the offerings, option blocks, and course versions to which they apply. Its purpose is to present a flattened, reporting-friendly record of unit set definitions combined with their offering context, drawing together course identification, calendar type, attendance attributes, and unit set lifecycle dates. Because the product family is obsolete, the view is preserved principally for reference, legacy upgrade analysis, and historical data extraction rather than for new functional development. In release 12.2.2 the documented metadata records no owning schema and no referenced base objects, and the object is marked "Not implemented in this database" — that is, it exists in the data model definition but is absent from a standard installation.

Underlying Base Objects

The view text is defined as a UNION ALL of two query branches over three base tables: IGS_PS_OFR_UNIT_SET (aliased COUS), IGS_PS_OFR_OPT (aliased COO), and IGS_EN_UNIT_SET (aliased US), plus a semi-join against IGS_PS_OF_OPT_UNT_ST (aliased COOUS). The first branch joins offering unit sets to offering options on course code, version number, and calendar type, restricting to records where DELETE_FLAG = 'N' and where no matching row exists in IGS_PS_OF_OPT_UNT_ST for the given COO_ID. The second branch returns unit sets that are explicitly tied to an option through IGS_PS_OF_OPT_UNT_ST. The two branches therefore cover unit sets inherited at the offering level and unit sets overridden or defined at the option level. IGS_EN_UNIT_SET supplies the descriptive unit set attributes, while IGS_EN_GEN_008.ENRP_GET_US_TITLE, a stored function, resolves the display title.

Key Columns

Common Use Cases and Queries

Typical usage includes auditing which unit sets apply to a course offering, distinguishing offering-level from option-level assignments, and reconciling unit set validity windows against offering dates. A representative query retrieves active unit sets for a course version:

SELECT unit_set_cd, us_version_number, course_cd, crv_version_number, cal_type, location_cd, unit_set_status, start_dt, end_dt FROM igs_ps_ofr_opt_unit_set_v WHERE course_cd = :course AND crv_version_number = :version AND cal_type = :cal ORDER BY unit_set_cd;

A second pattern groups counts by attendance mode to summarise delivery coverage, while a third filters on COO_ID to isolate the option-level branch. As the view is not implemented in the reference database, confirm its presence in the target instance before relying on it in reports or interfaces; where absent, equivalent logic must be reconstructed from the four underlying tables.