Search Results xtr_reclass_details




Overview
Explore in AI Chat

Overview

The XTR_RECLASS_DETAILS 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. It serves a critical function in hedge accounting and financial instrument revaluation processes. The table's primary purpose is to store the detailed, reclassified amounts of effective unrealized gains and losses. This data is essential for complying with accounting standards, such as IAS 39 or ASC 815, which require the separation of the effective (hedge) and ineffective portions of a hedging instrument's fair value change. By persistently tracking these reclassified amounts, the table supports accurate period-end reporting, audit trails, and the reversal or adjustment of entries in subsequent accounting periods.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the critical data points stored. The central identifier is the RECLASS_DETAILS_ID, which serves as the primary key. The table stores the calculated monetary amounts for reclassified gains and losses. Crucially, it links this financial data to specific hedging arrangements via the HEDGE_ATTRIBUTE_ID foreign key, which points to the XTR_HEDGE_ATTRIBUTES table. Furthermore, it maintains a procedural audit trail by storing references to the batch processes that created or adjusted the records through LAST_REVAL_BATCH_ID and RETRO_BATCH_ID, both linking to the XTR_BATCHES table. This structure ensures each reclassification detail is traceable to a specific hedge and a specific system-generated batch job.

Common Use Cases and Queries

The primary use case for this table is generating reports for hedge accounting effectiveness and the resulting entries in the general ledger. Finance and treasury analysts query this table to verify the amounts reclassified from Other Comprehensive Income (OCI) to Profit & Loss (P&L) for cash flow hedges, or to analyze the effectiveness test results for fair value hedges. A common reporting pattern involves joining to related hedge and instrument tables. For example, to list all reclassification details for a specific hedging relationship, one might use a query such as:

  • SELECT rd.*, ha.hedge_number FROM xtr_reclass_details rd, xtr_hedge_attributes ha WHERE rd.hedge_attribute_id = ha.hedge_attribute_id AND ha.hedge_number = 'HEDGE123';

Another critical use case is supporting the period-end close process, where batch programs (referenced by the batch IDs) populate this table, and subsequent interfaces post the journal entries to the general ledger.

Related Objects

The XTR_RECLASS_DETAILS table is integrally connected to other key Treasury tables through documented foreign key relationships, forming a central part of the hedge accounting data model.

  • XTR_HEDGE_ATTRIBUTES: Linked via XTR_RECLASS_DETAILS.HEDGE_ATTRIBUTE_ID. This is the most significant relationship, as it ties the reclassified gain/loss amounts to the specific hedging relationship and its defined terms and attributes.
  • XTR_BATCHES (Two Relationships):
    • Linked via XTR_RECLASS_DETAILS.LAST_REVAL_BATCH_ID. This references the batch job that performed the last revaluation which impacted these reclassification details.
    • Linked via XTR_RECLASS_DETAILS.RETRO_BATCH_ID. This references the batch job responsible for any retrospective adjustments applied to the reclassification records.

Queries and processes will typically join through these foreign keys to retrieve descriptive information about the hedge or the processing batch details.