Search Results xtr_hedge_relationships




Overview
Explore in AI Chat

Overview

The XTR_HEDGE_RELATIONSHIPS table is a core data repository within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary table for storing and managing hedge relationship information. In treasury management, a hedge relationship formally links a hedging instrument, such as a derivative contract, to one or more hedged items, which are specific assets, liabilities, or forecasted transactions exposed to financial risk. This table is fundamental for supporting hedge accounting compliance under standards like IFRS 9 and ASC 815, as it maintains the official designation and structural details of these relationships, enabling the system to track effectiveness and perform necessary accounting entries.

Key Information Stored

While the full column list is not provided in the metadata, the primary and foreign key structure reveals critical data points. The central column is HEDGE_RELATIONSHIP_ID, the unique identifier for each defined relationship. The table links to other essential treasury entities via foreign keys: HEDGE_ATTRIBUTE_ID connects to the XTR_HEDGE_ATTRIBUTES table, likely storing details about the risk being hedged and the hedge's effectiveness method. The SOURCE_TYPE_ID links to XTR_SOURCE_TYPES, which typically categorizes the origin or type of the hedged item (e.g., a fixed asset, a forecasted sale). Additional columns, inferred from standard functionality, would store the relationship's status, designation date, description, and references to the specific hedging instrument and hedged item transactions within the system.

Common Use Cases and Queries

This table is central to hedge accounting operations and reporting. Common use cases include generating reports for audit trails of hedge designations, calculating hedge effectiveness, and supporting period-end accounting processes. A typical analytical query might join this table to instrument and transaction tables to list all active relationships.

  • Sample Query for Active Hedge Relationships:
    SELECT hrel.hedge_relationship_id, hrel.description, hattr.risk_type, stype.source_type_name
    FROM xtr_hedge_relationships hrel,
    xtr_hedge_attributes hattr,
    xtr_source_types stype
    WHERE hrel.hedge_attribute_id = hattr.hedge_attribute_id
    AND hrel.source_type_id = stype.source_type_id
    AND hrel.status = 'ACTIVE';
  • Data from this table is also crucial for regulatory reporting, internal controls, and reconciling the treasury front-office deal capture with the back-office general ledger entries for hedge accounting.

Related Objects

The XTR_HEDGE_RELATIONSHIPS table is part of a tightly integrated schema within the Treasury module. As per the provided metadata, it has direct foreign key relationships with two key reference tables:

  • XTR_HEDGE_ATTRIBUTES: This table stores the qualifying criteria and methods for the hedge, such as the designated risk and the effectiveness assessment technique.
  • XTR_SOURCE_TYPES: This reference table classifies the nature or source system of the item being hedged.

Furthermore, it is the parent table for the primary key constraint XTR_HEDGE_RELATIONSHIPS_PK. In a complete implementation, it would also be referenced by child tables storing effectiveness test results, journal entry links, and potentially the specific deal-to-item allocations that operationalize the relationship.