Search Results ocr_cfig_id




Overview
Explore in AI Chat

Overview

The view APPS.IGS_PS_SCH_OCR_CFIG_V belongs to the IGS (Student System) product family within Oracle E-Business Suite and is classified as a VALID database view owned by the APPS schema. Its documented purpose is to expose "occurrence rollover and override related information." In the Oracle Student System scheduling model, an "occurrence" represents a specific offering of a scheduled course or unit within a term, and configuration records govern how those occurrences behave when they are rolled over from one academic period to another and how individual scheduling attributes may be overridden.

This view therefore serves as a reporting and integration access point for the configuration flags that determine rollover behaviour (for example, whether a day, time, instructor, facility, or preference should carry forward to the next occurrence) and for the override flags that permit deviation from the default scheduling pattern. Because the view is defined over a single base entity and performs no joins, filter predicates, or transformations beyond simple column projection, it is lightweight and well suited to concurrent program extracts, BI Publisher data templates, OAF-based inquiry pages, and custom PL/SQL validation logic. The OCR_CFIG_ID column it exposes is the primary identifier that consumers use when searching for occurrence configuration setup data, which directly matches the user search term "ocr_cfig_id."

Underlying Base Objects

According to the ETRM metadata, the view is defined with a straightforward projection over one base table: IGS_PS_SCH_OCR_CFIG. The view text confirms this relationship through a simple SELECT ... FROM IGS_PS_SCH_OCR_CFIG SOC, with no shared joins, unions, or subqueries. The metadata records no additional referenced base objects, which is consistent with the view text.

  • Base table: IGS_PS_SCH_OCR_CFIG — stores the occurrence rollover and override configuration records keyed by OCR_CFIG_ID.
  • View owner: APPS, the standard Oracle EBS schema for shared application objects.
  • Relationship: One view row corresponds to exactly one base table row, identified in the view by the synthetic ROW_ID column (derived from SOC.ROWID) and the business key OCR_CFIG_ID.

Key Columns

The view exposes the full column set of the base table, including both rollover and override indicators, the surrogate key, and standard audit columns.

Common Use Cases and Queries

Typical scenarios include validating that rollover configuration exists before running occurrence rollover processes, auditing which attributes are eligible for override, and feeding downstream scheduling or reporting extracts. A direct lookup by identifier returns a single configuration record:

  • SELECT * FROM apps.igs_ps_sch_ocr_cfig_v WHERE ocr_cfig_id = :p_ocr_cfig_id;
  • SELECT ocr_cfig_id, day_roll_flag, time_roll_flag, instructor_roll_flag FROM apps.igs_ps_sch_ocr_cfig_v WHERE instructor_roll_flag = 'Y';
  • SELECT ocr_cfig_id, last_update_date, last_updated_by FROM apps.igs_ps_sch_ocr_cfig_v WHERE last_update_date >= :p_since_date ORDER BY last_update_date;

Because the view is a thin projection, the underlying base table remains the correct target for DML; the view should be treated as read-only for reporting and inquiry purposes.