Results for “sql_validation”

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

Overview

The view IGSBV_CAL_SYS_DT_TYP_OVRD_RLS belongs to the IGS — Student System product family within Oracle E-Business Suite. The IGS module is documented as obsolete in the ETRM reference for EBS 12.1.1 and 12.2.2, meaning it is no longer actively implemented in current database instances, though its metadata and object definitions are retained for historical and upgrade reference. In the ETRM metadata, the implementation note explicitly states "Not implemented in this database," confirming that the view typically exists only as a documented definition rather than an active compiled object.

Functionally, this view exposes the overriding rules associated with seeded system date types. Within the IGS calendar framework, system date types drive validation and control logic for academic calendar processing. Override rules allow institutions to replace or supplement the seeded (Oracle-delivered) behavior with institution-specific logic embedded in SQL validation expressions. The view therefore serves as a reporting and integration surface over the override rule configuration repository.

Underlying Base Objects

Although the documented metadata lists no referenced base objects, the embedded view text identifies the source tables explicitly. The view is defined as a join between two IGS calendar tables:

• IGS_CA_DA_OVD_RULES (aliased OVD) — the primary table holding override rule records, including the SQL validation expression, its override flag, and closed indicator.
• IGS_CA_DA_CONFIGS (aliased DA) — the configuration table supplying the descriptive text for each system date type.

The join condition is OVD.SYS_DATE_TYPE = DA.SYS_DATE_TYPE, correlating each override rule to its parent system date type configuration. The view is declared WITH READ ONLY, enforcing read-only access for consumers. The _LA: token in the select list is an EBS descriptive flexfield / attribute reference, mapping the element code to a lookup via IGS_LOOKUP_VALUES.

Key Columns

The columns exposed by the view support both configuration auditing and SQL validation inspection:

• SYSTEM_DATE_TYPE — the seeded system date type identifier to which the override rule applies.
• OVERRIDE_ELEMENT — the _LA: lookup-mapped value for OVD.ELEMENT_CODE, resolved against IGS_LOOKUP_VALUES using the IGS_DA_OVRD_ELT_LEVEL lookup type to return the MEANING.
• SQL_VALIDATION — the SQL validation expression defined for the override rule. This is the column most relevant to searches involving "sql_validation."
• SQL_VALIDATION_OVRD_FLAG — flag indicating whether the SQL validation value overrides the seeded default.
• CLOSED_INDICATOR — indicates whether the override rule is closed or inactive.
• SYSTEM_DATE_TYPE_DESC — the description of the system date type sourced from IGS_CA_DA_CONFIGS.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

The primary practical use is auditing which SQL validation expressions are attached to system date types and whether they override seeded behavior. A typical query retrieves all active override rules with their SQL validation text:

SELECT system_date_type,
       sql_validation,
       sql_validation_ovrd_flag,
       closed_indicator
FROM   igsbv_cal_sys_dt_typ_ovrd_rls
WHERE  closed_indicator = 'N';

A second scenario filters to rules where the override flag is set, isolating institution-specific validation logic:

SELECT system_date_type,
       system_date_type_desc,
       sql_validation
FROM   igsbv_cal_sys_dt_typ_ovrd_rls
WHERE  sql_validation_ovrd_flag = 'Y';

Because the view is read-only and defined over configuration tables, it is suitable for reconciliation reports and migration validation during EBS upgrades. Analysts searching for "sql_validation" will find this view particularly relevant, as the SQL_VALIDATION column exposes the exact validation logic configured against each seeded system date type.