Search Results exam_session_number




Overview
Explore in AI Chat

Overview

The IGS_AS_EXAM_SESSION view is a Multi-Org secured database object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It exposes examination session scheduling data maintained by institutions that use Oracle Student System to manage academic calendars, examination timetables, and assessment logistics. In EBS 12.1.1 and 12.2.2, the view is registered with a VALID status in the ETRM metadata repository, confirming that it is a supported and queryable object for reporting, integration, and extension purposes.

The view's primary role is to present exam session definitions in a Multi-Org-aware manner. Rather than querying the underlying table directly, consumers — including concurrent programs, Oracle Discoverer workbooks, OBIEE extracts, and custom PL/SQL packages — should query this view so that the operating unit security predicate is applied transparently. The view therefore functions as the standard access path for exam session data filtered by the session's current organization context.

Underlying Base Objects

The view is defined over the table IGS_AS_EXAM_SESSION_ALL. The _ALL suffix indicates that the base table stores rows for every operating unit (ORG_ID) in the enterprise. The view's defining query selects all business columns plus TAB.ROWID (aliased as ROW_ID) and ORG_ID from this table, applying a Multi-Org security predicate:

NVL(TAB.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,
  SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99)) =
NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,
  SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99)

The predicate reads the current organization from the CLIENT_INFO session context, treats a blank leading character as NULL, and defaults unmatched values to -99. Rows whose ORG_ID matches the session's operating unit (or that carry the sentinel value) are returned. This is the classic pre-R12 Multi-Org view pattern; in 12.2.2 the same construct remains because the Student System retains its historical Multi-Org implementation.

Key Columns

  • ESE_ID — Surrogate primary key identifying the examination session record in the base table.
  • EXAM_SESSION_NUMBER — The user-facing session identifier that users search on; typically a sequential or coded number distinguishing individual exam sittings.
  • EXAM_CAL_TYPE / EXAM_CI_SEQUENCE_NUMBER — Identify the examination calendar type and its calendar instance sequence to which the session belongs.
  • DT_ALIAS / DAI_SEQUENCE_NUMBER — The date alias and date alias instance sequence linking the session to a specific calendar date definition.
  • CI_START_DT / CI_END_DT — The calendar instance start and end dates bracketing the session.
  • START_TIME / END_TIME — The scheduled start and end time of the examination sitting.
  • COMMENTS — Free-text notes attached to the session.
  • ORG_ID — Operating unit that owns the row; drives the Multi-Org filter.
  • ROW_ID — The base table ROWID, exposed for updatable-view or direct row addressing scenarios.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

The most frequent scenario is locating a session by its number within the user's operating unit:

SELECT ese_id, exam_session_number, exam_cal_type,
       ci_start_dt, start_time, end_time, comments
FROM   igs_as_exam_session
WHERE  exam_session_number = :p_session_number;

Institutions also join the view to examination calendar and venue tables to build timetable reports:

SELECT s.exam_cal_type, s.exam_session_number,
       s.ci_start_dt, s.start_time, s.end_time
FROM   igs_as_exam_session s
WHERE  s.ci_start_dt BETWEEN :p_from AND :p_to
ORDER  BY s.ci_start_dt, s.start_time;

Because the view enforces the Multi-Org predicate, developers must ensure the correct operating unit is initialized (via FND_CLIENT_INFO or an equivalent session setup) before querying; otherwise rows belonging to another organization will not be returned. For bulk extracts across all operating units, querying the underlying IGS_AS_EXAM_SESSION_ALL table with an explicit ORG_ID filter is the appropriate alternative.