Search Results ovrd_val_identifier




Overview
Explore in AI Chat

Overview

APPS.IGSBV_CAL_PRD_EVNTTYP_OVRD_RLS is a Business Intelligence System (BIS) view owned by the APPS schema within the Oracle E-Business Suite. Its FND Design Data identifier is IGS.IGSBV_CAL_PRD_EVNTTYP_OVRD_RLS, and the object is registered as VALID in the ETRM repository for both 12.1.1 and 12.2.2. The view exposes the configuration of overriding rules applied to calendar period system date types, and is part of the Oracle Student System (IGS) product family, specifically the calendar and academic period configuration area.

In the Oracle EBS reporting and integration model, BIS views such as this one act as read-only, denormalized projections over one or more base configuration tables. They are intended to simplify extract, reporting, and integration development by presenting descriptive, human-readable values alongside their internal identifiers, without requiring consumers to understand the underlying normalized schema. This view therefore serves as a stable query surface for date-type override configuration data used by downstream reporting, conversion programs, and external integrations.

Underlying Base Objects

The documented dependencies for IGSBV_CAL_PRD_EVNTTYP_OVRD_RLS reference two APPS base objects: IGS_CA_DA_CONFIGS and IGS_CA_DA_OVD_VALS. These tables hold the calendar period date-type configuration and the associated override value definitions respectively. The view joins or projects these sources so that a single row represents the element values of the overriding rules for a given system date type.

The view is not referenced by any other database object, indicating that it sits at the top of its dependency chain and is intended purely for consumption rather than further extension. No additional base objects are documented in the ETRM metadata for this version.

Key Columns

  • SYSTEM_DATE_TYPE (VARCHAR2, 30) — The seeded system date type to which the override rules apply.
  • _LA:OVERRIDE_ELEMENT (CHAR, 68) — The override element associated with the system date type.
  • OVERRIDE_ELEMENT_VALUE (VARCHAR2, 100) — The value assigned to the overriding element, for example "BA-PSY/1", "SCHOOL_LAW", or "UG".
  • DATE_ALIAS (VARCHAR2, 10) — The user-assigned date alias for the element override.
  • OVRD_VAL_IDENTIFIER (VARCHAR2, 80) — A unique identifier for the override value. This is the column referenced by the user search term ovrd_val_identifier, and it is commonly used to link override records to external or downstream processing logic.
  • SYSTEM_DATE_TYPE_DESC (NUMBER) — Short description of the system date type.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns recording record creation and modification metadata.

Common Use Cases and Queries

Typical scenarios include auditing which override values are configured against each system date type, verifying that seeded date types carry the expected aliases, and extracting override configuration for migration or reconciliation between environments. The OVRD_VAL_IDENTIFIER column is frequently used as a join key or lookup value when tracing an override back to its originating rule definition.

SELECT SYSTEM_DATE_TYPE
     , OVERRIDE_ELEMENT_VALUE
     , DATE_ALIAS
     , OVRD_VAL_IDENTIFIER
  FROM APPS.IGSBV_CAL_PRD_EVNTTYP_OVRD_RLS
 WHERE SYSTEM_DATE_TYPE = :p_date_type;

SELECT OVRD_VAL_IDENTIFIER
     , OVERRIDE_ELEMENT_VALUE
     , DATE_ALIAS
  FROM APPS.IGSBV_CAL_PRD_EVNTTYP_OVRD_RLS
 WHERE OVRD_VAL_IDENTIFIER LIKE 'BA-%';

Because the object is a BIS view, queries should be treated as read-only. Reports and integrations relying on it should be validated against the actual column list after any upgrade, since the _LA:OVERRIDE_ELEMENT column carries a non-standard name and the associated description column is typed as NUMBER rather than a character type.