Search Results max_ovr_group




Overview
Explore in AI Chat

Overview

APPS.IGS_PS_USEC_X_GRP_V is a supplementary view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and registered under FND Design Data as IGS.IGS_PS_USEC_X_GRP_V. It belongs to the Oracle Student System (formerly Oracle Student Information System / IGS) product family and specifically supports the scheduling and delivery of crosslisted (cross-referenced) course groups, known as "use-crosslisted" groups. The view abstracts and simplifies data for the scheduling forms used within the Student System, presenting a flattened, form-friendly projection of the underlying crosslisted-group tables. Oracle explicitly classifies this as a "supplementary view used to simplify forms coding," and the documented warning states that Oracle does not recommend querying or altering data through it, since its definition may change dramatically in subsequent minor or major releases. The view is currently VALID. For reporting and integration purposes, it serves primarily as a read-only reference for querying crosslisted group definitions, enrollment thresholds, and override thresholds; the presence of the MAX_ENR_GROUP column makes it directly relevant to the common search term "max_enr_group".

Underlying Base Objects

According to the ETRM dependency information, APPS.IGS_PS_USEC_X_GRP_V is defined over two referenced base objects: IGS_PS_USEC_X_GRP and IGS_CA_INST. The primary driving entity is IGS_PS_USEC_X_GRP, the crosslisted group table, which supplies the group identifier, group name, calendar type, alternate code, sequence number, and the enrollment-related attributes MAX_ENR_GROUP and MAX_OVR_GROUP. IGS_CA_INST, the calendar instance table, contributes the calendar and date context, including the START_DT and END_DT columns exposed by the view. The view is referenced downstream by APPS.IGS_PS_USEC_SCHEDULE, confirming its role as a supporting object for scheduling-related forms and logic. Because it is a view rather than a table, no data is physically stored; all columns are derived at query time from the underlying base objects, and the ROW_ID column is a pseudo-column that uniquely identifies the source row.

Key Columns

  • ROW_ID (ROWID, 10) — Pseudo-column identifying the underlying source row.
  • USEC_X_LISTED_GROUP_ID (NUMBER, 10) — Unique identifier of the crosslisted group.
  • USEC_X_LISTED_GROUP_NAME (VARCHAR2, 80) — Descriptive name of the crosslisted group.
  • LOCATION_INHERITANCE (VARCHAR2) — Indicates how location attributes are inherited across the group.
  • CAL_TYPE (VARCHAR2, 10) — Calendar type associated with the group.
  • CI_SEQUENCE_NUMBER (NUMBER) — Sequence number linking to the calendar instance.
  • ALTERNATE_CODE (VARCHAR2, 10) — Alternate short code for the group.
  • START_DT / END_DT (DATE) — Effective start and end dates of the group within the calendar instance.
  • MAX_ENR_GROUP (NUMBER) — Maximum Enrollment Allowed for Crosslisted Group.
  • MAX_OVR_GROUP (NUMBER) — Maximum Override Allowed for Crosslisted Group.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to report on crosslisted group capacity and override rules, to validate scheduling configurations, and to drive integrations that need enrollment thresholds. A common query retrieving enrollment and override limits for a given group is:

SELECT USEC_X_LISTED_GROUP_ID, USEC_X_LISTED_GROUP_NAME, CAL_TYPE, START_DT, END_DT, MAX_ENR_GROUP, MAX_OVR_GROUP FROM APPS.IGS_PS_USEC_X_GRP_V WHERE MAX_ENR_GROUP IS NOT NULL;

A second scenario filters active groups within a date range:

SELECT USEC_X_LISTED_GROUP_NAME, ALTERNATE_CODE, MAX_ENR_GROUP FROM APPS.IGS_PS_USEC_X_GRP_V WHERE TRUNC(SYSDATE) BETWEEN START_DT AND END_DT ORDER BY USEC_X_LISTED_GROUP_NAME;

Because Oracle warns against querying or altering this form-support view directly, production integrations should generally target the base table IGS_PS_USEC_X_GRP instead, using this view only for ad hoc investigation or as a reference model.