Results for “holiday_date”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_HOLIDAYS_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes holiday calendar data maintained within the Treasury application, providing a read-oriented interface to the currency-specific non-working days used throughout Treasury processing. The view is documented as VALID in the ETRM repository and presents a projection of five columns sourced from the Treasury holiday definition. Its principal role is to serve as a stable, named access path for reports, concurrent programs, and integration queries that need to determine which dates are treated as holidays for a given currency. Because the view is defined over a synonym rather than directly over the physical table, it preserves a layer of indirection that allows Oracle to redefine the underlying object without invalidating dependent code. The column HOL_SEQ, which appears first in the view's projection, is the primary lookup key referenced by the object's metadata and is the identifier most frequently used when joining holiday records to other Treasury entities.
Underlying Base Objects
The view is defined over the base object XTR_HOLIDAYS, which is documented as a SYNONYM in the ETRM 12.2.2 metadata. The synonym resolves to the physical Treasury holiday table in the APPS schema, meaning the view does not itself store data but presents a curated subset of the base table's columns. The documented view text confirms this relationship directly:
SELECT HOL_SEQ, CURRENCY, HOLIDAY_DATE, DAY_DESC, COMMENTS FROM XTR_HOLIDAYS
Because the projection is explicit rather than a SELECT *, the view exposes only the five listed columns even if the underlying table contains additional attributes. This design limits the surface area for dependent code and shields consumers from schema changes to non-projected columns. The synonym-to-table resolution also means that the view inherits the referential and security characteristics of the APPS-owned base object, and any grants or synonyms on the base table govern access indirectly.
Key Columns
- HOL_SEQ — The holiday sequence identifier. This is the primary key of the view and the column most commonly used in joins and single-record lookups. It uniquely identifies each holiday row.
- CURRENCY — The currency code to which the holiday applies. Holiday calendars in Treasury are maintained per currency, so this column determines the scope of each non-working date.
- HOLIDAY_DATE — The actual date treated as a holiday. This is the operative column for date-arithmetic and calendar-validation logic.
- DAY_DESC — A descriptive label for the holiday, such as the holiday name or day type.
- COMMENTS — Free-text annotations attached to the holiday record by the maintaining user.
Common Use Cases and Queries
Typical uses include validating payment and settlement dates, computing spot and forward value dates, and driving Treasury reporting that must exclude non-business days. A query returning all holidays for a given currency is the most common access pattern:
SELECT hol_seq, holiday_date, day_desc FROM xtr_holidays_v WHERE currency = 'USD' ORDER BY holiday_date;SELECT hol_seq, currency, holiday_date FROM xtr_holidays_v WHERE holiday_date BETWEEN :p_start AND :p_end;SELECT COUNT(*) FROM xtr_holidays_v WHERE currency = :p_ccy AND holiday_date = :p_date;
The last form is frequently embedded in PL/SQL logic to test whether a candidate value date falls on a holiday before posting a Treasury transaction. Because the view is read-only in practice, all maintenance is performed against the base table, and the view is reserved for query and reporting consumption.
-
View: XTR_HOLIDAYS_V 12.2.2
-
View: XTR_HOLIDAYS_V 12.1.1
-
Holidays defined for different currencies
-
Statutory Holiday information.
-
Details of user defined holiday days.
-
View: HXT_HOLIDAY_DAYS_VL 12.2.2
APPS.HXT_HOLIDAY_DAYS_VL·↳ HXT_HOLIDAY_DAYS·↳ HXT_HOLIDAY_DAYS_TL·Explore HXT module →
-
Contains Holidays/Non-Working Dates information
-
Contains Holidays/Non-Working Dates information
-
Holidays defined for different currencies
-
Details of user defined holiday days.
-
View: HXT_HOLIDAY_DAYS_VL 12.1.1
APPS.HXT_HOLIDAY_DAYS_VL·↳ HXT_HOLIDAY_DAYS·↳ HXT_HOLIDAY_DAYS_TL·Explore HXT module →
-
APPS.HXTFV_HOLIDAY_CALENDARS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_SECURITY·Explore HXT module →
-
APPS.HXTFV_HOLIDAY_CALENDARS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_SECURITY·Explore HXT module →
-
Statutory Holiday information.
-
VIEW: XTR.XTR_HOLIDAYS# 12.2.2
-
VIEW: HXT.HXT_HOLIDAY_DAYS# 12.2.2
-
VIEW: FV.FV_HOLIDAY_DATES# 12.2.2
-
VIEW: XTR.XTR_HOLIDAYS# 12.2.2
-
TABLE: HXT.HXT_HOLIDAY_DAYS 12.2.2
-
TABLE: HXT.HXT_HOLIDAY_DAYS 12.1.1
-
TABLE: XTR.XTR_HOLIDAYS 12.1.1
-
TABLE: XTR.XTR_HOLIDAYS 12.2.2
-
VIEW: APPS.XTR_HOLIDAYS_V 12.2.2
-
VIEW: HXT.HXT_HOLIDAY_DAYS# 12.2.2
-
VIEW: APPS.XTR_HOLIDAYS_V 12.1.1
-
TABLE: FV.FV_HOLIDAY_DATES 12.2.2
-
VIEW: FV.FV_HOLIDAY_DATES# 12.2.2
-
VIEW: APPS.XTR_HOLIDAYS_V 12.1.1
-
TABLE: FV.FV_HOLIDAY_DATES 12.1.1
-
VIEW: APPS.XTR_HOLIDAYS_V 12.2.2