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
- UNIQUE_REF_NUM – Unique reference number identifying the rate set record.
- DEAL_TYPE / DEAL_SUBTYPE / PRODUCT_TYPE – Classify the deal or instrument to which the rate set applies.
- EFFECTIVE_FROM / RATE_EFFECTIVE_CREATED – Effective dating for the rate set and when the effective rate was created.
- CURRENCY – Currency in which the rate is denominated.
- LOW_RANGE / HIGH_RANGE – Numeric range boundaries used for tiered or banded rate application.
- RATE / MARGIN – The base interest rate and any spread applied over it.
- INTEREST_PERIOD / RESET_BASIS / NO_OF_DAYS – Define the interest accrual period, reset convention, and day-count basis.
- FIXED_FLOATING / TERM / PI_CONSTANT – Indicate whether the rate is fixed or floating, the term length, and periodic interest constant parameters.
- CLIENT_GROUPING – Client segmentation grouping for the rate set.
- POSTED / CONCURRENT_REQUEST – Track posting status and the concurrent request that processed the record.
- CREATED_BY / CREATED_ON / UPDATED_BY / UPDATED_ON / AUDIT_INDICATOR – Standard audit and ownership 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.
-
View: XTR_RATE_SETS_V 12.1.1
-
View: XTR_RATE_SETS_V 12.2.2
-
VIEW: APPS.XTR_RATE_SETS_V 12.1.1
-
VIEW: APPS.XTR_RATE_SETS_V 12.2.2
-
SYNONYM: APPS.XTR_RATE_SETS 12.2.2
-
SYNONYM: APPS.XTR_RATE_SETS 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96