Search Results xtr_hedge_items_temp

Overview

The XTR_HEDGE_ITEMS_TEMP table is a core data object within the Oracle E-Business Suite Treasury (XTR) module, specifically in versions 12.1.1 and 12.2.2. It functions as a temporary working table designed to support the generation of the "Positions - Forecast Hedge Items Fulfillment" report. This report is critical for treasury operations, as it analyzes and presents the fulfillment status of forecasted hedge items against existing financial positions. The table's primary role is to stage and process the specific criteria used to identify which transaction items are eligible for hedge accounting treatment, enabling the system to compile the necessary data for this specialized regulatory and management report.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies the hedge criteria for a transaction item. The key columns are HEDGE_ATTRIBUTE_ID, TRX_INV_ID, and PAY_SCHEDULE_ID. The HEDGE_ATTRIBUTE_ID is the central field, linking to the hedge attribute definition that specifies the risk management criteria. The TRX_INV_ID column holds the identifier for the underlying transaction or investment being evaluated for hedging. The PAY_SCHEDULE_ID references the specific payment schedule line of a transaction, which is essential for accurately matching cash flow forecasts to hedge instruments. Together, these columns store the fundamental relationships that determine if and how a financial item qualifies under a designated hedge program.

Common Use Cases and Queries

The primary use case is the batch generation of the Forecast Hedge Items Fulfillment report. A typical query would join this table to master transaction and hedge definition tables to extract the list of items meeting the hedge criteria for reporting. For example, a treasury analyst might run a query to audit all items captured by a specific hedge attribute before report submission. Sample SQL often involves filtering on HEDGE_ATTRIBUTE_ID to review all associated transactions:

• SELECT * FROM XTR_HEDGE_ITEMS_TEMP WHERE HEDGE_ATTRIBUTE_ID = [specific_id];

Data is typically populated into this table by the application's reporting engine or a dedicated concurrent process, processed for the report, and subsequently purged or archived, maintaining its nature as a temporary working store.

Related Objects

The table's relationships are explicitly defined by its primary key constraint, XTR_HEDGE_CRITERIA_PK. It is fundamentally linked to the tables that house the entities referenced in its key columns. The HEDGE_ATTRIBUTE_ID column will have a foreign key relationship to a master table of hedge attributes (likely named similarly to XTR_HEDGE_ATTRIBUTES). The TRX_INV_ID column references core transaction tables within the XTR schema, such as those holding deal or investment headers. The PAY_SCHEDULE_ID links to transaction schedule tables (e.g., XTR_DEAL_SCHEDULES). Any comprehensive report query will perform joins on these columns to pull descriptive information from these related master tables.