Results for “igs_re_dflt_ms_set”
29 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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
- ROW_ID – The physical ROWID of the underlying table row, useful for direct row identification.
- ORG_ID – Operating unit identifier driving the multi-org security predicate.
- COURSE_CD and VERSION_NUMBER – Identify the course and version to which the default milestone set applies.
- MILESTONE_TYPE and ATTENDANCE_TYPE – Classify the milestone and the attendance condition that triggers it.
- SEQUENCE_NUMBER – Ordering of milestones within the set.
- OFFSET_DAYS – Day offset used to schedule the milestone relative to a reference date.
- ATTENDANCE_MODE – Mode of attendance associated with the milestone configuration.
- COMMENTS – Free-text notes.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit 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.
-
View: IGS_RE_DFLT_MS_SET 12.1.1
APPS.IGS_RE_DFLT_MS_SET·↳ IGS_RE_DFLT_MS_SET_ALL·Explore IGS module →
-
View: IGS_RE_DFLT_MS_SET 12.2.2
Not implemented in this database·Explore IGS module →
-
APPS.IGS_PR_MILESTONE_CRV_ATT_V·↳ IGS_EN_ATD_TYPE·↳ IGS_PS_OFR_OPT·↳ IGS_RE_DFLT_MS_SET·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_RE_VAL_DMS 12.1.1
-
PACKAGE: APPS.IGS_RE_VAL_DMS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.