Search Results control_num




Overview
Explore in AI Chat

Overview

IGS_PS_EXP_WL_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGS.IGS_PS_EXP_WL_V. It belongs to the Student System (IGS) product family and is classified by Oracle as a view type "used to simplify forms coding." The view exposes data relating to expected workload entries defined at institutional calendar-category level, joining the base workload table to a lookup view in order to resolve the internal calendar category code into a user-facing meaning. In Oracle EBS 12.1.1 and 12.2.2 the object retains a status of VALID in the ETRM repository.

Oracle's documentation carries an explicit warning: this is a form-support view and is not intended as a query or integration interface. Oracle states that it may change dramatically in subsequent minor or major releases, and no database object in the ETRM dependency listing references it. Reporting or interfacing solutions should therefore avoid hard-coding dependencies on this view.

Underlying Base Objects

The ETRM dependency section documents two referenced objects:

The view itself references no further objects and, per the ETRM record, is not referenced by any database object. The documented column list includes ROW_ID, CONTROL_NUM, CALENDAR_CAT, CALENDAR_CAT_MEANING, EXPECTED_WL, and the five standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN). The presence of the Who columns confirms the view is defined over a table carrying standard Oracle audit attributes and that the lookup join is non-destructive to that context.

Key Columns

  • ROW_ID (ROWID) — the physical row identifier of the underlying IGS_PS_EXP_WL record, used by the form for row-level navigation and locking.
  • CONTROL_NUM (NUMBER) — documented in ETRM as "No longer Used." This is the column most commonly searched by technical consultants auditing legacy workload records, but it carries no functional meaning in current releases and should not be relied upon for joins or business logic.
  • CALENDAR_CAT (VARCHAR2, 30) — the calendar category at which the expected workload is set, expressed at institutional level. This is the functional key for the workload definition.
  • CALENDAR_CAT_MEANING (VARCHAR2, 80) — the descriptive meaning of the calendar category, resolved via IGS_LOOKUPS_VIEW. This makes the view directly presentable in reports without an additional decode.
  • EXPECTED_WL (NUMBER) — the expected workload value for the calendar category. ETRM annotates this column as "Obsolete," indicating that the workload value is retained for backward compatibility only.

Because both CONTROL_NUM and EXPECTED_WL are annotated as unused or obsolete, the only columns with reliable business meaning are CALENDAR_CAT and its resolved meaning.

Common Use Cases and Queries

The principal legitimate use case is diagnostic: identifying whether a site still holds rows in IGS_PS_EXP_WL for calendar categories that are no longer maintained, or confirming that the lookup join resolves cleanly. A basic query follows the documented query text:

  • SELECT CONTROL_NUM, CALENDAR_CAT, CALENDAR_CAT_MEANING, EXPECTED_WL FROM APPS.IGS_PS_EXP_WL_V;
  • SELECT CALENDAR_CAT, CALENDAR_CAT_MEANING, COUNT(*) FROM APPS.IGS_PS_EXP_WL_V GROUP BY CALENDAR_CAT, CALENDAR_CAT_MEANING;
  • SELECT v.CALENDAR_CAT, v.CALENDAR_CAT_MEANING FROM APPS.IGS_PS_EXP_WL_V v WHERE v.CALENDAR_CAT_MEANING IS NULL;

Each of these should be treated as a read-only audit against a form-support view. Where persistent integration or reporting is required, query the base table IGS_PS_EXP_WL directly and resolve the calendar category through the lookup tables, thereby avoiding the release-to-release instability Oracle explicitly warns about for IGS_PS_EXP_WL_V.