Results for “xtr_rate_sets_v”

16 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_RATE_SETS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the XTR – Treasury product module. It exposes interest rate set definitions maintained in the Treasury (ETRM) application, which is used to manage debt, investments, foreign exchange, and derivative instruments. The view presents a single row per rate set record, combining rate configuration attributes such as currency, deal type, effective dating, rate ranges, and reset parameters. Because it is a view rather than a base table, it serves primarily as a reporting and integration surface, allowing external systems, concurrent programs, and custom reports to read rate set data without directly querying the underlying transaction table. The view status is VALID across EBS 12.1.1 and 12.2.2, though the metadata documented here corresponds to the 12.2.2 ETRM object model.

Underlying Base Objects

The view is defined over a single documented base object: XTR_RATE_SETS, referenced through a synonym. The view text performs a straightforward projection, selecting all listed columns from XTR_RATE_SETS without joins, unions, or aggregation logic. Consequently, the view is a thin abstraction layer: it does not transform, filter, or enrich the base table data. This design means row counts, cardinality, and column semantics in XTR_RATE_SETS_V are identical to those in the base table, and the view is suitable for direct querying with the same performance characteristics as the base table (subject to the absence of table-level hints and indexes on the view definition itself).

Key Columns

Common Use Cases and Queries

Typical uses include reconciling rate sets by currency and date, identifying active tiered rates within a given range, and feeding rate data into downstream analytics or integrations. A representative query returns current rate sets for a currency:

SELECT unique_ref_num, currency, rate, margin,
       low_range, high_range, effective_from
FROM   apps.xtr_rate_sets_v
WHERE  currency = 'USD'
AND    effective_from <= SYSDATE
ORDER  BY effective_from DESC;

To locate records within a specific band, filter on the range columns:

SELECT unique_ref_num, low_range, high_range, rate
FROM   apps.xtr_rate_sets_v
WHERE  high_range >= :p_amount
AND    low_range  <= :p_amount;

Because the view mirrors XTR_RATE_SETS directly, custom reports should reference the view for upgrade safety while relying on standard EBS security and responsibility-based access to the APPS schema.