Search Results previous_sessions




Overview
Explore in AI Chat

Overview

IGS_AS_EXM_SUPRVISOR is an APPS-owned database view within the Oracle E-Business Suite student and academic records management layer, associated with the FND Design Data object IGS.IGS_AS_EXM_SUPRVISOR. The view is documented as VALID and is registered as a multi-org view, meaning that queries against it retrieve records for the current operating unit and ignore data belonging to other operating units. This behavior is enforced through the ORG_ID column that appears in the view's column list, consistent with the standard Oracle multi-org reporting model in release 12.1.1 and 12.2.2.

The view exposes examination supervisor assignments, capturing the person designated as an examination supervisor, the supervisor type, the responsible organizational unit, and an indicator of prior invigilation activity. It functions primarily as a reporting and integration access point rather than a transaction entry surface; the underlying transactional storage resides in a base "_ALL" table and the view applies the multi-org filter on top of it.

Underlying Base Objects

The ETRM dependency information documents that APPS.IGS_AS_EXM_SUPRVISOR references APPS.IGS_AS_EXM_SUPRVISOR_ALL. This naming convention is standard in EBS: the "_ALL" object stores rows for every operating unit, while the non-suffixed view exposes only those rows belonging to the session's current operating unit. The dependency list does not document any further base tables beneath IGS_AS_EXM_SUPRVISOR_ALL.

The view is referenced by several dependent objects, indicating its role as a shared access layer: APPS.IGS_AS_EXM_SUPRVISOR_V, the concurrent program or package IGS_AS_GEN_006, and the validation object IGS_AS_VAL_EIS. Because these dependents read the view rather than the base table directly, any change to the view's structure can affect examination scheduling and validation logic.

Key Columns

  • ROW_ID (ROWID) — the physical row identifier for the underlying record.
  • PERSON_ID (NUMBER) — the identifier of the person assigned as examination supervisor.
  • EXAM_SUPERVISOR_TYPE (VARCHAR2) — the classification of supervisor role.
  • PREVIOUS_SESSIONS (NUMBER) — a count or indicator of the supervisor's prior examination sessions. This is the column referenced in the user's search and is frequently used to identify experienced supervisors.
  • RESPONSIBLE_ORG_UNIT_CD (VARCHAR2) — the organizational unit accountable for the supervisor assignment.
  • RESPONSIBLE_OU_START_DT (DATE) — the effective start date of the responsible operating unit association.
  • COMMENTS (VARCHAR2, 2000) — free-text remarks.
  • ORG_ID (NUMBER) — the operating unit identifier driving the multi-org filter.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include identifying supervisors with prior invigilation history, reporting supervisor coverage by operating unit, and feeding validation or scheduling processes such as IGS_AS_VAL_EIS. The following query lists supervisors with prior sessions for the current operating unit:

SELECT PERSON_ID, EXAM_SUPERVISOR_TYPE, PREVIOUS_SESSIONS, RESPONSIBLE_ORG_UNIT_CD
FROM APPS.IGS_AS_EXM_SUPRVISOR
WHERE PREVIOUS_SESSIONS > 0;

A second common pattern joins the view to person data for descriptive reporting. Because the view is multi-org, results are automatically limited to the operating unit of the current session, and no explicit ORG_ID predicate is required, though it may be supplied for clarity in cross-org extracts.