Search Results location_inheritance

Overview

IGS_PS_UNIT_X_GRP_V is a validity (VALID) view owned by the APPS schema within the IGS — Student System product of Oracle E-Business Suite, and is available in both 12.1.1 and 12.2.2. The object name identifies it as a view (the "_V" suffix) over the unit cross-listed group entity, where "UNIT" refers to a program unit offering and "X_GRP" denotes the cross-listed group that governs shared enrollment behavior across units. In the Oracle Student System data model, cross-listed groups allow multiple unit offerings to be treated as a single enrollment entity, and this view provides a read interface to the defining record for each such group.

The view's practical function is to expose the grouped unit configuration together with its controlling attributes, including location inheritance rules and enrollment capacity limits. It is typically referenced by reporting extracts and integration routines that must resolve how enrollment is shared, capped, or constrained across cross-listed units. Because it is a database view rather than a public API, access is read-only and governed by the same security and grants applying to the APPS schema.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: IGS_PS_UNIT_X_GRP. The view text confirms this as a direct projection—every column in the view is drawn from the base table, aliased as UXG, with no joins, unions, or derived expressions. The view renames UNIT_X_LISTED_GROUP_ID, UNIT_X_LISTED_GROUP_NAME, LOCATION_INHERITANCE, MAX_ENR_GROUP, and MAX_OVR_GROUP without transformation and preserves the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN). It also exposes the base table ROWID as ROW_ID for row identification.

Because the definition is a straightforward SELECT from IGS_PS_UNIT_X_GRP, the view does not aggregate, filter, or filter-join other entities, and it adds no selectivity of its own—records returned correspond one-to-one with rows in the base table.

Key Columns

• UNIT_X_LISTED_GROUP_ID — Primary identifier for the cross-listed group record.
• UNIT_X_LISTED_GROUP_NAME — Descriptive name of the cross-listed group.
• LOCATION_INHERITANCE — Controls how location (delivery or teaching location) settings propagate across the units in the group. This is the column referenced by the user's "location_inheritance" search and is central to determining whether a unit offering inherits a location or maintains its own.
• MAX_ENR_GROUP — Maximum enrollment permitted across the group as a whole.
• MAX_OVR_GROUP — Maximum over-enrollment (override) permitted for the group.
• ROW_ID — Base table ROWID, useful for row-level addressing and diagnostics.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, supporting reconciliation and change tracking.

Common Use Cases and Queries

Typical scenarios include validating location inheritance configuration audit, troubleshooting enrollment cap conflicts, and extracting cross-listed group definitions. The following query lists all groups and their location inheritance and enrollment ceilings:

• SELECT unit_x_listed_group_id, unit_x_listed_group_name, location_inheritance, max_enr_group, max_ovr_group FROM igs_ps_unit_x_grp_v ORDER BY unit_x_listed_group_name;
• SELECT * FROM igs_ps_unit_x_grp_v WHERE unit_x_listed_group_name = :group_name;

A common operational query filters groups with a specific location inheritance value to audit propagation behavior:

• SELECT unit_x_listed_group_id, unit_x_listed_group_name FROM igs_ps_unit_x_grp_v WHERE location_inheritance = :inheritance_value;

Because the view carries no filter logic, all reporting predicates must be applied explicitly, and joins to the underlying IGS_PS_UNIT_X_GRP fragments should be performed via UNIT_X_LISTED_GROUP_ID where additional table attributes are required. When the metadata is limited, users should consult the Oracle Student System technical reference for additional columns or supplementary joins.