Search Results xtr_rollover_transactions

Overview

The XTR_ROLLOVER_TRANSACTIONS table is a core data repository within the Oracle E-Business Suite Treasury (XTR) module, serving as the transactional ledger for a diverse portfolio of financial instruments. It stores detailed information for individual transactions that are part of larger treasury deals. Its primary role is to support the lifecycle management of bond, interest rate swap, negotiable instrument, and various money market deals (short-term, retail term, and wholesale term money). The table is fundamental to tracking the financial and contractual details of each transaction, enabling critical treasury operations such as cash flow forecasting, interest accruals, revaluations, and counterparty limit monitoring.

Key Information Stored

The table's structure is anchored by a composite primary key consisting of DEAL_NUMBER and TRANSACTION_NUMBER, linking each transaction to its parent deal in the XTR_DEALS table. Critical columns include identifiers for the transaction's currency (linked to XTR_MASTER_CURRENCIES) and the involved counterparty limit (via COMPANY_CODE, CPARTY_CODE, and LIMIT_CODE linked to XTR_COUNTERPARTY_LIMITS). For accounting integration, it holds account use identifiers for principal, balance outstanding, and accumulated interest (PRINCIPAL_ACCT_USE_ID, BAL_OS_ACCT_USE_ID, ACCUM_INT_ACCT_USE_ID), which reference the CE_BANK_ACCT_USES_ALL table in Cash Management. The table also maintains references to revaluation processing batches (FIRST_REVAL_BATCH_ID, LAST_REVAL_BATCH_ID linked to XTR_BATCHES) and parcel splits (PARCEL_SPLIT_NO linked to XTR_PARCEL_SPLITS).

Common Use Cases and Queries

This table is central to treasury reporting and operational inquiries. Common use cases include generating transaction listings for a specific deal, analyzing exposures by counterparty or currency, and reconciling accounting entries. A typical query might retrieve all transactions for a deal to assess cash flows:

• SELECT deal_number, transaction_number, currency FROM xtr_rollover_transactions WHERE deal_number = :p_deal_num ORDER BY transaction_number;

Another critical use case is supporting the revaluation process, where transactions are marked-to-market. Analysts may query transactions pending revaluation or review the batch history. The table is also essential for limit monitoring, as transactions are validated against counterparty credit limits stored in XTR_COUNTERPARTY_LIMITS, with any breaches logged in XTR_LIMIT_EXCESS_LOG.

Related Objects

XTR_ROLLOVER_TRANSACTIONS has extensive relationships within the Treasury schema. It is a primary child table of XTR_DEALS. Key dependent tables that store supplemental transaction data include XTR_DEAL_DATE_AMOUNTS (for date-specific amounts), XTR_REVALUATION_DETAILS, XTR_ACCRLS_AMORT (for accrual and amortization schedules), and XTR_CONFIRMATION_DETAILS. The foreign key relationships to CE_BANK_ACCT_USES_ALL and XTR_MASTER_CURRENCIES are crucial for financial and multi-currency integrity. As a referenced parent table, it is integral to the audit trail captured in XTR_LIMIT_EXCESS_LOG.