Search Results xtr_revaluation_details

Overview

The XTR_REVALUATION_DETAILS table is a core data repository within the Oracle E-Business Suite (EBS) Treasury module (XTR). It serves as the definitive ledger for storing the detailed results of periodic revaluation processes run on treasury deals and transactions. Revaluation is a critical accounting function that marks financial instruments to their current fair market value, directly impacting an organization's financial statements and risk exposure reporting. This table acts as the system of record for these calculated gains, losses, and valuations, providing the granular audit trail necessary for financial compliance, performance analysis, and reconciliation in both EBS 12.1.1 and 12.2.2 environments.

Key Information Stored

The table's primary purpose is to capture the outcome of a revaluation run for specific financial positions. Its structure is anchored by a surrogate primary key, REVALUATION_DETAILS_ID. The most critical foreign key columns establish links to the underlying treasury transactions, primarily DEAL_NO and TRANSACTION_NO, which connect to master deal tables (XTR_DEALS) and transaction tables (XTR_ROLLOVER_TRANSACTIONS). Other essential references include BATCH_ID, linking to the control record in XTR_BATCHES that initiated the revaluation job, and BANK_ACCT_USE_ID, which ties the result to a specific bank account usage definition in the Cash Management module (CE_BANK_ACCT_USES_ALL). While the specific valuation columns are not detailed in the provided metadata, typical data stored includes the revaluation date, revalued amount in both transaction and functional currencies, calculated unrealized gain or loss, the revaluation rate used, and the accounting period.

Common Use Cases and Queries

This table is central to treasury reporting and audit activities. Common use cases include generating period-end unrealized P&L reports, reconciling treasury system valuations to the general ledger, and analyzing the sensitivity of the portfolio to market rate fluctuations. A typical analytical query would join this table to deal and transaction master tables to break down revaluation results by deal type, currency, or portfolio.

• Sample Query for Revaluation Summary by Deal:
  SELECT d.deal_type, rd.revaluation_date, SUM(rd.unrealized_gain_loss)
FROM xtr_revaluation_details rd, xtr_deals d
WHERE rd.deal_no = d.deal_no
AND rd.revaluation_date = :p_date
GROUP BY d.deal_type, rd.revaluation_date;
• Audit Trail for a Batch: Queries filtering by BATCH_ID provide a complete snapshot of all positions revalued in a specific automated job run, crucial for error tracing and process verification.

Related Objects

As indicated by its foreign keys, XTR_REVALUATION_DETAILS has strong dependencies on several key Treasury and financial tables. It is a direct child table of XTR_DEALS (for deal header information) and XTR_ROLLOVER_TRANSACTIONS (for specific transaction details). The relationship to XTR_BATCHES provides process context, linking details to the batch control record. Its integration with CE_BANK_ACCT_USES_ALL is significant, connecting treasury valuations to the broader Oracle Cash Management and bank account structure. The primary key constraint XTR_REVALUATION_DETAILS_PK ensures the uniqueness of each revaluation record, maintaining data integrity for this critical financial information.