Search Results csr_rule_windows_v




Overview
Explore in AI Chat

Overview

The CSR_RULE_WINDOWS_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2, delivered as part of the CSR (Scheduler) product. It exposes the scheduling rule window definitions stored inside the Scheduler rule repository, converting rule XML documents into a relational, query-friendly result set. Because the underlying rule definitions are persisted as XML within a single rule document column, the view exists to propagate that semi-structured content into discrete columns that SQL reports, concurrent programs, and downstream integrations can consume directly.

The view is recorded in ETRM metadata with a status of VALID and is documented as a VIEW object belonging to the CSR - Scheduler module. It is a read-only projection: all data originates from the base rule tables described below, and no direct DML should be performed against it.

Underlying Base Objects

The view is defined over the following documented base objects and supporting constructs:

  • CSR_RULES_B (SYNONYM) — the base rule table that holds the rule header and the RULE_DOC XML document, which itself contains the nested <WINDOW> elements.
  • CSR_RULE_WINDOWS_TL (SYNONYM) — the translation table supplying the language-dependent WINDOW_NAME and DESCRIPTION attributes joined by WINDOW_ID.
  • WINDOW1532_COLL (TYPE) — a collection type used in XML processing.
  • XMLSEQUENCE (SYNONYM) and XMLSEQUENCEFROMXMLTYPE (FUNCTION) — Oracle XML DB utilities that expand the XML fragment into rows.
  • AGGXMLIMP (TYPE) and SYS_IXMLAGG (FUNCTION) — supporting implementation objects referenced by the view metadata.

In the view text, the XPath /SCHEDULERRULE/WTPPARAMETERS/WINDOW is extracted from CSR_RULES_B.RULE_DOC, expanded via TABLE(XMLSEQUENCE(...)), and joined to CSR_RULE_WINDOWS_TL on WINDOW_ID, filtered by USERENV('LANG') so that only the session's language row is returned.

Key Columns

  • RULE_ID — identifier of the parent scheduling rule in CSR_RULES_B.
  • WINDOW_ID (extracted from WINDOW/@WINDOWID) — the window identifier used to join to the translation table.
  • WINDOW_NAME and DESCRIPTION — language-specific descriptive attributes from CSR_RULE_WINDOWS_TL.
  • Start/End date-time columns — the window @STARTTIME and @ENDTIME values converted to DATE via TO_DATE.
  • HH24:MI and HH24/MI columns — derived time components for start and end, convenient for time-of-day filtering and display.
  • Duration — computed as the difference between end and start in minutes (the arithmetic result multiplied by 24*60).
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN inherited from the rule record.

Common Use Cases and Queries

The view is typically used to audit or report the windows attached to Scheduler rules, to verify time-of-day coverage, and to feed integration extracts. A standard query joins rule and window information:

  • SELECT rule_id, window_id, window_name, starttime, endtime, duration_minutes FROM csr_rule_windows_v WHERE rule_id = :p_rule_id;
  • Filter by language-sensitive names to produce localized reports of configured rule windows.
  • Analyze coverage windows by extracting the HH24 and MI columns to pivot start/end times by hour.
  • Reconcile rule-window relationships by joining CSR_RULES_B to the view on RULE_ID for governance and audit extracts.

Because the source content is XML, always validate that the RULE_DOC contains a well-formed WINDOW fragment; malformed documents will not yield rows.