Results for “xtr_a_rate_sets_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_A_RATE_SETS_V is an APPS-owned database view within the Oracle E-Business Suite Treasury (XTR) module. It is catalogued as VALID in both the 12.1.1 and 12.2.2 releases and serves as a reporting and integration layer over the Treasury interest rate setup data stored in the XTR_A_RATE_SETS base object. In the ETRM (Enterprise Treasury Reference Model) documentation, the view is classified as a read-only presentation object: it exposes the full column set of the underlying rate-set definition so that concurrent programs, reports, and external interfaces can query rate configuration without direct dependency on the base table's physical layout.
The view is defined with a simple projection — SELECT of the named columns FROM XTR_A_RATE_SETS — without joins, aggregations, or filters. This makes it a thin, deterministic wrapper whose primary value is schema abstraction, security consistency, and standardized naming for downstream consumers such as interest rate calculation, deal processing, and audit reporting.
Underlying Base Objects
The documented base object is XTR_A_RATE_SETS, referenced through a SYNONYM. The view returns every column of that table unchanged, meaning row-level and column-level semantics are identical to the parent rate-set definition. Because the view is a direct projection, it inherits any grants held on XTR_A_RATE_SETS and is subject to the same Oracle EBS multi-org and security model applied elsewhere in the Treasury schema. No other base tables or views are documented as participating in its definition.
Key Columns
- UNIQUE_REF_NUM — Surrogate identifier uniquely distinguishing each rate-set record.
- DEAL_TYPE / DEAL_SUBTYPE / PRODUCT_TYPE — Classify the Treasury instrument to which the rate set applies.
- EFFECTIVE_FROM / RATE_EFFECTIVE_CREATED — Dates governing when the rate becomes and was created as effective.
- CURRENCY, LOW_RANGE, HIGH_RANGE, RATE, MARGIN — Core pricing attributes, including tiered range bounds and the applicable rate or margin.
- INTEREST_PERIOD, FIXED_FLOATING, RESET_BASIS, NO_OF_DAYS, TERM — Interest computation parameters controlling periodicity, fixed versus floating determination, reset frequency, day count, and term.
- CLIENT_GROUPING — The client grouping attribute matching the user's search term; it associates a rate set with a category of counterparties or client segments.
- UPDATE_EXISTING_DEALS, PI_CONSTANT — Control flags influencing how existing deals are treated and constant principal/interest behaviour.
- POSTED, AUDIT_INDICATOR, AUDIT_DATE_STORED — Status and audit tracking fields.
- UPDATED_BY, UPDATED_ON, CREATED_BY, CREATED_ON, CONCURRENT_REQUEST — Standard EBS WHO/audit columns and the concurrent request that last processed the record.
Common Use Cases and Queries
Typical usage includes reviewing active rate configurations for a currency or deal type, auditing changes to rates and margins, and supplying input to interest accrual or deal revaluation processes. Because RATE_SETS are effective-dated, queries commonly filter by EFFECTIVE_FROM to reconstruct the rate in force on a given date.
Example: list rate sets for a client grouping by currency.
SELECT unique_ref_num, currency, deal_type, rate, margin, effective_from
FROM apps.xtr_a_rate_sets_v
WHERE client_grouping = :p_client_grouping
AND currency = :p_currency
ORDER BY effective_from DESC;
Example: identify floating-rate configurations currently posted.
SELECT unique_ref_num, deal_type, reset_basis, no_of_days, term
FROM apps.xtr_a_rate_sets_v
WHERE fixed_floating = 'FLOATING'
AND posted = 'Y';
Example: trace records created by a specific concurrent request for audit purposes.
SELECT unique_ref_num, created_by, created_on, concurrent_request
FROM apps.xtr_a_rate_sets_v
WHERE concurrent_request = :p_request_id;
In integration scenarios the view is frequently accessed read-only by external rate engines or reconciliation scripts, since it presents the canonical, documented Treasury rate-set structure without requiring knowledge of underlying table constraints.
-
View: XTR_A_RATE_SETS_V 12.1.1
APPS.XTR_A_RATE_SETS_V·↳ XTR_A_RATE_SETS·Explore XTR module →
-
View: XTR_A_RATE_SETS_V 12.2.2
APPS.XTR_A_RATE_SETS_V·↳ XTR_A_RATE_SETS·Explore XTR module →
-
VIEW: APPS.XTR_A_RATE_SETS_V 12.1.1
-
VIEW: APPS.XTR_A_RATE_SETS_V 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
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.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96