Results for “owner_org_unit_cd”

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:

• IGS_AS_UAI_EXAM_CI_V — examination calendar instance view supplying exam calendar, calendar instance, assessment, unit, and reference columns.
• IGS_CA_INST — calendar instance table, joined on calendar type and sequence number.
• IGS_CA_STAT — calendar status table, filtered to S_CAL_STATUS = 'ACTIVE'.
• IGS_AS_ASSESSMNT_ITM — assessment item table, supplying exam paper name and working time.
• IGS_PS_UNIT_VER and IGS_PS_UNIT_STAT — unit version and unit status, filtered to active units.
• IGS_AS_SU_ATMPT_ITM and IGS_EN_SU_ATTEMPT — student unit attempt item and attempt tables, the latter filtered to UNIT_ATTEMPT_STATUS = 'ENROLLED' and NO_ASSESSMENT_IND = 'N'.
• IGS_AS_UNIT_CLASS — unit class, joined on unit class and evaluated by IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI.
• PL/SQL functions IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC and the validation function IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI.

Key Columns

• EXAM_CAL_TYPE / EXAM_CI_SEQUENCE_NUMBER — examination calendar type and instance sequence number.
• TEACH_CAL_TYPE / TEACH_CI_SEQUENCE_NUMBER — the teaching calendar type and sequence number (aliased from CAL_TYPE and CI_SEQUENCE_NUMBER).
• ASS_ID — assessment identifier linking to the assessment item.
• UNIT_CD and REFERENCE — unit code and reference value.
• EXAM_PAPER_NAME — descriptive exam paper name from the assessment item.
• OWNER_ORG_UNIT_CD — owning organizational unit of the unit version.
• EXAM_WORKING_TIME — examination working time from the assessment item.
• EXAM_LOCATION_CD — computed exam location from ASSP_GET_SUA_EXLOC.
• DEG_AUD_DETAIL_ID — degree audit detail identifier.

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.