Search Results ese_id




Overview
Explore in AI Chat

Overview

IGS_AS_ESE_EXMVNUS_UNAVLBL_V is a reporting view in the Oracle EBS Student System (IGS) product family, which is documented as obsolete in Release 12.1.1 and 12.2.2. The view presents the inverse of the examination venue availability model: rather than listing which venues are available for a given examination session, it selects all venues that are unavailable for each examination session. This inverse presentation is useful because venue availability is typically stored sparsely — records exist only where availability has been explicitly declared — so a direct "unavailable" list must be derived by negation.

The ETRM metadata states that the object is "Not implemented in this database," meaning the view may exist only in certain installations, patches, or customizations, and is not guaranteed to be present in a standard 12.1.1 or 12.2.2 instance. The user search term "ese_id" corresponds directly to the ESE_ID column, which is the examination session identifier and the principal join key within this view. Because the view is obsolete, it should be treated as a reference structure for legacy reporting rather than a supported integration point.

Underlying Base Objects

The documented view text is defined over two base tables and a correlated availability table:

  • IGS_GR_VENUE (aliased VE) — the venue master, filtered by CLOSED_IND = 'N' so that closed venues are excluded from the result set.
  • IGS_AS_EXAM_SESSION (aliased ESE) — the examination session header, supplying the calendar type, sequence numbers, date alias, session number, and start/end times.
  • IGS_AD_LOCATION and IGS_AD_LOCATION_TYPE — joined inside an EXISTS subquery to restrict results to venues whose EXAM_LOCATION_CD is a location of type 'EXAM_CTR' (examination centre).
  • IGS_AS_EXMVNU_SESAVL — the session-availability table, referenced in a NOT EXISTS subquery that removes any venue/session combination for which an availability record already exists.

The view also invokes the function IGS_CA_GEN_001.CALP_GET_ALIAS_VAL to resolve the display alias value from the date alias, DAI_SEQUENCE_NUMBER, and examination calendar type. No base objects are separately documented in the ETRM metadata, so the tables above are taken from the supplied view text.

Key Columns

Common Use Cases and Queries

The primary use case is examination timetabling and venue planning: identifying which open examination centres have no declared availability for a given session, so that availability records can be created or exams reassigned. A representative query for a specific session is:

SELECT venue_cd, exam_cal_type, exam_session_number, start_time, end_time
FROM   igs_as_ese_exmvnus_unavllbl_v
WHERE  ese_id = :p_ese_id
ORDER BY venue_cd;

To list unavailable venues across all sessions of a calendar, omit the ESE_ID predicate and filter on EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER. Because the EXISTS subquery restricts results to locations of type 'EXAM_CTR', the output is already scoped to genuine examination centres. Note that the view is not implemented in all databases and is documented as obsolete; any query should first confirm object existence via ALL_VIEWS and, for long-term solutions, be migrated to the supported availability structures.