Search Results system_date_type_desc




Overview
Explore in AI Chat

Overview

APPS.IGSBV_CAL_PRD_EVNT_TYP_CONFIGS is a read-only database view in the Oracle E-Business Suite (EBS) environment, defined in the APPS schema. It belongs to the Oracle iLearning / IGS (Oracle Learning Management) product family. The view exposes date-type configuration records, which define the behavioral rules for handling system dates and event types within a calendar or period framework. Its primary role is to provide a reporting and integration-friendly interface to the underlying configuration data without exposing the raw transaction table directly. Because the view is defined with a WITH READ ONLY clause, it cannot be used for DML operations, ensuring that consumers treat the data as reference information rather than a maintenance surface.

Underlying Base Objects

The view is defined over a single documented base object: IGS_CA_DA_CONFIGS (aliased as DA). The base table stores date-alias configuration rows that govern how system date types are validated and applied. The ETRM metadata does not document additional base objects, so the view can be treated as a projection over IGS_CA_DA_CONFIGS only. The WITH READ ONLY modifier is preserved from the underlying query and prevents any insert, update, or delete operations against the view.

Key Columns

The view exposes a combination of physical columns and literal label expressions. Notable columns include:

Common Use Cases and Queries

The view is typically queried to enumerate date-type configurations, to verify validation procedure assignments, or to report on calendar-category restrictions. A representative query retrieving the description and owning module is:

SELECT sys_date_type,
       system_date_type_desc,
       validation_proc,
       one_per_cal_flag,
       date_alias
  FROM apps.igsbv_cal_prd_evnt_typ_configs
 WHERE sys_date_type = :p_date_type;

A second common pattern filters on the alias or audit information to reconcile configuration changes:

SELECT a.date_alias,
       a.system_date_type_desc,
       a.last_updated_by,
       a.last_update_date
  FROM apps.igsbv_cal_prd_evnt_typ_configs a
 WHERE a.one_per_cal_flag = 'Y'
 ORDER BY a.system_date_type;

Because the view is read-only and resolves lookup meanings inline, it is well suited to BI Publisher reports, concurrent program extracts, and integration queries that must present human-readable module and calendar-category values. Consumers should note that the lookup expressions are materialized as literals in the view definition, so the returned lookup meanings reflect the configuration of IGS_LOOKUP_VALUES at query time rather than a denormalized snapshot.