Search Results holiday_type




Overview
Explore in AI Chat

Overview

APPS.XTR_HOLIDAY_RULES_V is a reporting view within the Oracle E-Business Suite Treasury (ETRM) module. It exposes the holiday rule definitions maintained by the Treasury application, which are used by interest calculation, cash forecasting, and financial instrument processing logic to determine valid business days, settlement dates, and payment dates across currencies and calendars. The view presents a read-only projection of holiday rule data drawn from the underlying XTR_HOLIDAY_RULES base object.

In Oracle EBS 12.1.1 and 12.2.2, the view is owned by the APPS schema and is typically referenced by concurrent programs, report definitions, custom extensions, and integration interfaces that require holiday calendar logic without directly querying the base table. Because it isolates a specific set of columns, the view provides a stable, denormalized presentation suitable for external reporting and light-weight querying. The holiday_type column is one of the primary attributes users search on, as it classifies each rule row according to the nature of the holiday or calendar event.

Underlying Base Objects

The documented base object referenced by the view is the synonym XTR_HOLIDAY_RULES, which resolves to the Treasury holiday rules table in the APPS schema. The view definition is a straightforward SELECT over this single object with no joins, unions, or aggregation. The view text is as follows:

Because the view is defined over a synonym rather than a fully qualified table name, resolution of the base object depends on the synonym definition in the APPS schema. No filters, WHERE clauses, or row-limiting predicates are applied, so the view returns all rows present in the underlying table. This means row-level security or filtering must be applied by the calling query if required.

Key Columns

  • HOL_SEQ — Surrogate sequence identifier for the holiday rule row; used as a unique key reference.
  • CURRENCY — Currency code to which the holiday rule applies, supporting multi-currency calendar logic.
  • HOLIDAY_DESC — Descriptive name of the holiday or calendar event.
  • HOLIDAY_TYPE — Classification of the holiday entry (for example, standard, floating, or rule-based holidays), commonly used as a search and grouping attribute.
  • HOLIDAY_MONTH — Month component for fixed-date holidays.
  • CALCULATED_OUT_TO — The date out to which holiday occurrences have been calculated or generated.
  • HOLIDAY_DAY — Day-of-month component for fixed-date holidays.
  • HOLIDAY_YEAR — Year associated with the holiday definition where applicable.
  • HOLIDAY_RULE — The rule or formula used to derive the holiday date for floating or variable holidays.
  • DAY_RULE — Additional rule governing day computation (e.g., relative day-of-week logic).
  • WEEKEND_ADJ — Weekend adjustment indicator specifying how holidays falling on weekends are shifted.
  • EXTRA_HOLIDAY_DAYS — Number of additional non-working days associated with the rule.

Common Use Cases and Queries

Typical scenarios include validating business-day logic in Treasury interest calculations, populating custom holiday calendars, and extracting rule definitions for external cash-flow systems. A common query filters by holiday type:

  • SELECT HOL_SEQ, CURRENCY, HOLIDAY_DESC, HOLIDAY_TYPE FROM APPS.XTR_HOLIDAY_RULES_V WHERE HOLIDAY_TYPE = :holiday_type;
  • SELECT CURRENCY, HOLIDAY_DESC, HOLIDAY_MONTH, HOLIDAY_DAY FROM APPS.XTR_HOLIDAY_RULES_V WHERE CURRENCY = :currency ORDER BY HOLIDAY_MONTH, HOLIDAY_DAY;

Because the view performs no transformation, performance is equivalent to querying the base table directly. Customizations should favor the view for forward compatibility, while bulk processing yielding large result sets may still target the base table where indexed access is required.