Search Results igs_re_dflt_ms_set




Overview
Explore in AI Chat

Overview

The view IGS_RE_DFLT_MS_SET belongs to the IGS – Student System product family within Oracle E-Business Suite, specifically the regulations and enrolment (RE) functional area. It presents default milestone set configuration data that governs the automatic generation of milestones tied to course enrolments. In EBS 12.1.1 and 12.2.2, this object is documented in ETRM as part of an obsolete product line, and the corresponding database note states that it is "Not implemented in this database." Consequently, in most current installations the view exists only as historical metadata rather than a live runtime object.

From a reporting and integration standpoint, the view is significant because it provides multi-org secured access to the default milestone setup. It serves as a reporting layer over the underlying _ALL table, applying the standard organizational security predicate so that each operating unit sees only its own rows (or rows with a null ORG_ID treated as shared). This is the classic EBS pattern for exposing setup data through a secured view rather than querying the base table directly.

Underlying Base Objects

The ETRM documentation records no explicitly referenced base objects, but the view text reveals that it is defined exclusively over IGS_RE_DFLT_MS_SET_ALL. The view selects from that table using an alias TAB and projects all of its business columns plus TAB.ROWID as ROW_ID. Because the parent object is the _ALL variant, the view is the org-secured counterpart typically paired in EBS with a _ALL table and an _B/_TL pattern for translation where applicable.

The WHERE clause implements multi-org security by comparing the table's ORG_ID against the organization identifier extracted from the USERENV('CLIENT_INFO') session context. When the first character of CLIENT_INFO is a space, a NULL is substituted; otherwise the first ten characters are converted to a number. Both sides default to -99 through nested NVL/DECODE logic, which allows rows with a null ORG_ID (global defaults) to remain visible across organizations.

Key Columns

Common Use Cases and Queries

Because the view is documented as obsolete and not implemented, queries against it in 12.1.1/12.2.2 may raise ORA-00942 unless legacy objects survive. Where present, typical uses include reporting default milestone mappings and validating setup before enrolment term processing.

A basic listing by course:

  • SELECT COURSE_CD, VERSION_NUMBER, MILESTONE_TYPE, SEQUENCE_NUMBER, OFFSET_DAYS FROM IGS_RE_DFLT_MS_SET WHERE COURSE_CD = :course_cd ORDER BY VERSION_NUMBER, SEQUENCE_NUMBER;

To inspect organizational coverage, query distinct ORG_ID values. Before relying on this view, confirm availability with USER_VIEWS/ALL_VIEWS, since the ETRM note indicates the object is not implemented in the current database.