Search Results int_usec_x_usec_id




Overview
Explore in AI Chat

Overview

IGS_PS_SCH_X_USEC_INT is an interface view belonging to the IGS – Student System product family, which Oracle classifies as obsolete in the EBS 12.1.1 and 12.2.2 releases. The view captures Scheduler Interface Unit Section Cross Listings data, serving as a staging and integration surface through which external scheduling or timetabling processes supply cross-listing relationships between unit sections into the Student System. Its name decomposes as "Scheduler Cross Unit Section Interface," indicating its position between an upstream scheduling source and the core Student System scheduling tables.

The object is documented as "Not implemented in this database," and no base objects are documented in the ETRM metadata. Consequently, it should be treated as a legacy compatibility artifact rather than an active integration point in a standard, unpatched EBS 12.1.1 or 12.2.2 environment. The view text references IGS_PS_SCH_X_USEC_INT_ALL, the underlying _ALL table, which is the multi-organization (ORG_ID-enabled) base object. Querying the view is equivalent to selecting from that table with the column alias ROWID AS ROW_ID.

Underlying Base Objects

The only referenced base object is IGS_PS_SCH_X_USEC_INT_ALL. The view definition is a straightforward projection: it selects every column from the _ALL table and exposes ROW_ID as an alias of the table's physical ROWID. No joins, filters, or aggregations are applied. Because the _ALL table carries ORG_ID, the view is multi-org aware, and reporting queries should be filtered by operating unit unless the session context handles it automatically.

In a standard 12.1.1 or 12.2.2 installation the object is reported as not implemented, meaning the table and view may be absent from the database entirely. Developers encountering this view should first verify DBA_OBJECTS, ALL_VIEWS, and ALL_TAB_COLUMNS before assuming its presence.

Key Columns

Common Use Cases and Queries

Typical scenarios involve auditing scheduler integration output, reconciling cross-listed sections, and debugging failed interface loads. Because the view exposes INT_USEC_ID directly, the most frequent access pattern filters by that identifier:

SELECT int_usec_id, int_usec_x_usec_id, child_unit_cd, child_cal_type, start_dt, end_dt FROM igs_ps_sch_x_usec_int WHERE int_usec_id = :p_int_usec_id;

To report all cross-listings for an operating unit within a scheduling window:

SELECT cross_list_group_name, child_unit_cd, child_title, class_max_enrollment_number FROM igs_ps_sch_x_usec_int WHERE org_id = :p_org_id AND start_dt >= :p_from_date AND end_dt <= :p_to_date;

Reconciliation against processed data uses PARENT_UOO_ID and CHILD_UOO_ID as join keys. Given the obsolete status and "not implemented" documentation, all such queries should be preceded by an existence check, and any dependency on this view should be migrated to the supported Student System scheduling tables in current implementations.