Results for “authorisation_rqrd_ind”

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

Overview

The view IGS_EN_UNIT_SET belongs to the Oracle E-Business Suite product family designated as IGS – Student System, a module that Oracle classifies as obsolete in Release 12.1.1 and 12.2.2. The view exposes the code of a unit set, where unit sets comprise lists of units or rules. In the ETRM documentation the object is described purely in terms of its business meaning: a unit set is a named collection of units (or the rules that generate them), maintained against a specific operating unit and version, and carrying administrative attributes such as status, category and authorisation requirements. The view therefore functions as the reporting and integration surface for unit set master data rather than as a transaction entry object.

Two facts in the supplied metadata are particularly significant for anyone who locates this object through a search for "igs_en_unit_set". First, the documentation states explicitly that the view is "Not implemented in this database". Second, the referenced base objects are recorded as "none documented". Together these indicate that IGS_EN_UNIT_SET is a legacy or dormant definition, and that on a standard 12.1.1 or 12.2.2 instance the view may not exist at all, or may exist only in environments where the Student System product was previously licensed and its schema objects retained.

Underlying Base Objects

The view text reveals the single base object over which it is defined: IGS_EN_UNIT_SET_ALL, an operating-unit-enabled table. The view is the organisation-secured (_ALL to non-_ALL) projection of that table. Its WHERE clause applies the standard multi-organisation security predicate, deriving the operating unit from the first ten characters of the USERENV('CLIENT_INFO') session value and retaining rows only when the derived value equals the row's ORG_ID, with NULL handling collapsing unmatched values to the sentinel -99. A ROWID value is exposed as ROW_ID to provide a stable row identifier.

Because the base table is not documented in the ETRM entry, the internal relationships of IGS_EN_UNIT_SET_ALL to other Student System tables cannot be asserted from the supplied material. Consumers should treat the view as a standalone denormalised projection and avoid assuming foreign-key joins to unit, rule or curriculum objects unless those objects have been independently confirmed.

Key Columns

The columns fall into identification, lifecycle and descriptive groups, plus the mandatory EBS audit and descriptive flexfield blocks.

• ROW_ID – the ROWID of the underlying row, exposed for direct row addressing.
• ORG_ID – operating unit that owns the unit set; drives the view's security predicate.
• UNIT_SET_CD, VERSION_NUMBER – the unit set code and its version, forming the natural business key.
• UNIT_SET_STATUS, UNIT_SET_CAT – lifecycle status and the category that classifies the unit set.
• START_DT, REVIEW_DT, EXPIRY_DT, END_DT – validity window and review/expiry milestones.
• TITLE, SHORT_TITLE, ABBREVIATION – the display forms of the unit set name.
• RESPONSIBLE_ORG_UNIT_CD, RESPONSIBLE_OU_START_DT – the accountable organisational unit and the date its responsibility began.
• ADMINISTRATIVE_IND, AUTHORISATION_RQRD_IND – flags governing administrative treatment and whether authorisation is required.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE20 – the descriptive flexfield segments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the standard EBS who-columns.

Common Use Cases and Queries

Typical uses are to enumerate unit sets for the current operating unit, to audit lifecycle state and expiry, and to extract version histories for integration into downstream academic structures. Because the organisation security is applied inside the view, no additional ORG_ID filter is normally required when the session is set correctly.

List active unit sets for the session's operating unit:

SELECT unit_set_cd, version_number, title,
       unit_set_status, unit_set_cat, start_dt, end_dt
FROM   igs_en_unit_set
WHERE  unit_set_status = 'ACTIVE'
ORDER  BY unit_set_cd, version_number;

Identify unit sets approaching expiry or review:

SELECT unit_set_cd, version_number, review_dt, expiry_dt
FROM   igs_en_unit_set
WHERE  NVL(end_dt, expiry_dt) >= TRUNC(SYSDATE)
AND    NVL(end_dt, expiry_dt) <= TRUNC(SYSDATE) + 90
ORDER  BY NVL(end_dt, expiry_dt);

Before relying on any such query, verify that the object exists in the target database, since the metadata records it as not implemented and its base objects as undocumented.