Search Results exam_announcements




Overview
Explore in AI Chat

Overview

APPS.IGS_AS_ASSESSMNT_ITM is a reporting and integration view in the Oracle E-Business Suite Student System (Oracle Student System, or OSI) that exposes assessment item definitions used within the institution's assessment and examination portfolio. The view is defined over the base table IGS_AS_ASSESSMNT_ITM_ALL, providing a business-facing projection of assessment records including assessment identifiers, paper names, examination scheduling attributes, supervisory and candidate instruction text, and descriptive flexfield segments. Within EBS 12.1.1 and 12.2.2, this view serves as the standard interface through which assessment metadata is presented to reports, concurrent programs, and external integrations without requiring direct navigation of the underlying _ALL table.

The view applies an application security predicate against ORG_ID, meaning that multi-org (operating unit) filtering is enforced at the view level. A record is returned only where the operating unit resolved from the session context (USERENV('CLIENT_INFO')) matches the row's ORG_ID, or where both resolve to the sentinel value -99. This design ensures that callers automatically receive only the assessments belonging to the current operating unit context.

Underlying Base Objects

The ETRM metadata documents the view as selecting from IGS_AS_ASSESSMNT_ITM_ALL. The trailing "_ALL" convention indicates a multi-org enabled table that stores assessment item definitions for all operating units, with rows partitioned logically by ORG_ID. The view does not document any additional joined base objects; all columns are sourced from this single table. Consequently, the view is a one-to-one projection of the base table, with the sole transformation being the multiorg WHERE clause and the retention of ROWID as ROW_ID for downstream identification.

Because the view is built directly on the _ALL table, DML against the view is generally restricted; it is intended for read access. Organizations requiring updates to assessment instructions or scheduling attributes should target the base table or the associated application forms rather than the view.

Key Columns

Common Use Cases and Queries

Typical uses include generating examination instruction sheets, validating that required instructions such as EXAM_SUPPLIED_INSTRCTN are populated, and feeding assessment metadata into scheduling or student portal integrations.

Retrieve all instruction text for a specific assessment:

SELECT ass_id, exam_paper_name, exam_supervisor_instrctn, exam_supplied_instrctn, exam_allowable_instrctn FROM apps.igs_as_assessmnt_itm WHERE ass_id = :p_ass_id;

Locate assessment items missing supplied instructions:

SELECT ass_id, description, exam_paper_name FROM apps.igs_as_assessmnt_itm WHERE exam_supplied_instrctn IS NULL AND closed_ind = 'N';

List open scheduled examinations with durations for a given operating unit context:

SELECT ass_id, exam_paper_name, exam_working_time, exam_perusal_time FROM apps.igs_as_assessmnt_itm WHERE assessment_type = 'EXAM' AND exam_scheduled_ind = 'Y' AND closed_ind = 'N';