Search Results xtr_revaluation_rates




Overview
Explore in AI Chat

Overview

The XTR_REVALUATION_RATES table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically in versions 12.1.1 and 12.2.2. As defined in the ETRM documentation, its primary purpose is to store revaluation rates for a specific company on a given end-of-period date. Revaluation is a critical accounting process in treasury management, involving the periodic adjustment of the book value of financial instruments—such as foreign currency holdings, derivatives, and securities—to reflect their current fair market value. This table acts as the system of record for the rates used in these calculations, ensuring accurate financial reporting, profit and loss recognition, and regulatory compliance for the organization's treasury activities.

Key Information Stored

While the provided metadata does not list all columns, the structure and key constraints reveal essential data points. Each record is uniquely identified by the UNIQUE_REF_NUM column, which serves as the primary key (XTR_REVALUATION_RATES_PK). The table stores the revaluation rate itself, which is typically a market price, exchange rate, or yield applicable on the period-end date. The REVAL_TYPE column, which has a foreign key relationship to the XTR_MARKET_PRICES table, categorizes the type of rate (e.g., spot FX rate, interest rate, commodity price). The BATCH_ID column links the rate to a processing batch in the XTR_BATCHES table, providing an audit trail for batch-driven revaluation jobs. Additional columns likely include identifiers for the COMPANY, CURRENCY, the effective PERIOD_END_DATE, and the rate VALUE.

Common Use Cases and Queries

The primary use case is the execution and audit of period-end revaluation runs within the Treasury module. A batch process generates records in this table, which are then used to revalue portfolios. Common reporting queries involve extracting rates for validation or historical analysis. For example, to audit the rates used for a specific company ('ABC Corp') and currency (EUR) at the last quarter-end, one might query:

  • SELECT company_code, currency, period_end_date, reval_type, rate_value FROM xtr_revaluation_rates WHERE company_code = 'ABC' AND currency = 'EUR' AND period_end_date = '30-JUN-2023';

Another critical scenario is troubleshooting revaluation results by joining to the XTR_MARKET_PRICES table to verify the source market data: SELECT r.*, m.market_price FROM xtr_revaluation_rates r, xtr_market_prices m WHERE r.reval_type = m.reval_type AND r.batch_id = :batch_number;

Related Objects

As indicated by the foreign keys, XTR_REVALUATION_RATES has direct dependencies on two key tables. The link to XTR_MARKET_PRICES ensures that revaluation rates are sourced from validated market data. The relationship with XTR_BATCHES provides context for the batch-controlled process that populated the rates. This table is fundamentally linked to the core transactional tables in the XTR module that hold positions and deals requiring revaluation. While not listed in the excerpt, it is also commonly referenced by treasury reconciliation reports, GL interface programs that post revaluation accounting entries, and custom valuation dashboards.