Results for “exam_cal_type”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view IGS_AS_UAI_EXAMINATION_V belongs to the Oracle EBS IGS — Student System product family, a module identified in the ETRM (E-Business Suite Technical Reference Manual) as obsolete. Its documented purpose is to describe all examinations that are required within a given examination calendar instance and that are scheduled to be examined. In effect, the view consolidates examination calendar data, assessment item definitions, unit version information, and enrolled student attempt records into a single denormalized result set.

Within Oracle EBS reporting and integration, this view functions as a reporting convenience layer rather than a transactional entity. It joins the examination calendar instance hierarchy to the assessment item and unit version structures, then filters to active calendar statuses, active unit statuses, and enrolled student attempts. Because it derives a computed examination location through the ASSP_GET_SUA_EXLOC function, it is oriented toward downstream reporting or integration consumers that need an exam-by-exam, student-aware projection without authoring the underlying multi-table join themselves. The metadata records that the view is not implemented in the current database, and no base objects are separately documented in ETRM 12.2.2.

Underlying Base Objects

The view text defines the following sources. Although the ETRM "Referenced base objects" field is empty, the SQL reveals the true dependency graph:

Key Columns

Common Use Cases and Queries

Typical usage includes generating examination timetables, validating enrolled candidates per exam paper, and feeding downstream scheduling or reporting extracts. A straightforward query follows:

SELECT EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, UNIT_CD, EXAM_PAPER_NAME, EXAM_WORKING_TIME, EXAM_LOCATION_CD, DEG_AUD_DETAIL_ID FROM IGS_AS_UAI_EXAMINATION_V WHERE EXAM_CAL_TYPE = :p_cal_type AND EXAM_CI_SEQUENCE_NUMBER = :p_seq ORDER BY UNIT_CD, EXAM_PAPER_NAME;

A second pattern counts candidates per exam paper:

SELECT EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, ASS_ID, EXAM_PAPER_NAME, COUNT(DISTINCT DEG_AUD_DETAIL_ID) AS CANDIDATE_COUNT FROM IGS_AS_UAI_EXAMINATION_V GROUP BY EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, ASS_ID, EXAM_PAPER_NAME;

Because the view is obsolete and not implemented in the documented database, implementations should confirm availability before deploying dependent reports and consider migrating to current Student System examination entities where supported.