Search Results uoo_unit_mode




Overview
Explore in AI Chat

Overview

The view APPS.IGS_PS_UNIT_OFR_OPT_ASS_PAT_V is a public Oracle E-Business Suite database view belonging to the Student Systems (IGS) product family, specifically the Students/Programs of Study entity group. Its FND Design Data identifier is IGS.IGS_PS_UNIT_OFR_OPT_ASS_PAT_V, and it is owned by the APPS schema. In both Oracle EBS 12.1.1 and 12.2.2 the object exists in VALID status and is documented as a public view, meaning it is intended for custom reporting and integration rather than as an internal-only object. The view consolidates the assessment pattern that defines the assessment requirement for a unit, together with the unit offering option and unit class attributes against which that pattern is delivered. Consequently it answers the business question: which assessment pattern applies to a given unit offering option, and under which unit mode and unit class is that option delivered? The column UOO_UNIT_MODE — the term users frequently search on as "uoo_unit_mode" — surfaces the unit mode of the parent unit class at the offering-option grain, making the view a convenient join point when unit-mode filtering is required without navigating the underlying normalized tables.

Underlying Base Objects

The documented view definition references base objects belonging to the APPS schema. The principal sources are:

  • UNIT_OFFERING_OPTION — supplies unit code, version number, calendar type, calendar instance sequence, location code, unit class, and UOO_ID.
  • UNIT_ASSESSMENT_PATTERN — supplies the assessment pattern code, description, assessment pattern identifier, and the logical delete date.
  • UNIT_CLASS — supplies the unit mode exposed as UOO_UNIT_MODE.

The view therefore joins the unit offering option context to its assessment pattern and to the unit class definition. Because the assessment pattern of a unit must map to both the unit offering option and the unit class, the view enforces that alignment in its result set. The documented dependency list is stated only at the APPS schema level; the precise join predicates are not reproduced in the ETRM metadata, so consumers should treat the view as a denormalized reporting projection over these three areas rather than as a table with independent storage.

Key Columns

Common Use Cases and Queries

Typical uses include reporting assessment patterns by unit mode, verifying mapping consistency between unit offering options and assessment patterns, and extracting assessment configuration for downstream integration. Filtering on unit mode is straightforward:

SELECT unit_cd, version_number, ass_pattern_cd, uoo_unit_class, uoo_unit_mode FROM apps.igs_ps_unit_ofr_opt_ass_pat_v WHERE uoo_unit_mode = :p_unit_mode AND uap_logical_delete_dt IS NULL;

To list all assessment patterns for a specific offering option, constrain on unit code, version, and calendar instance:

SELECT ass_pattern_cd, description, uoo_unit_class, uoo_unit_mode FROM apps.igs_ps_unit_ofr_opt_ass_pat_v WHERE unit_cd = :p_unit_cd AND version_number = :p_version AND cal_type = :p_cal_type AND ci_sequence_number = :p_ci_seq;

Always apply the logical delete filter to exclude retired assessment patterns, and use UOO_ID or ASS_PATTERN_ID when joining to related IGS entities. Because the view is public and documented, it is a supported source for custom reporting in both 12.1.1 and 12.2.2.