Search Results xtr_rollover_transactions_v




Overview
Explore in AI Chat

Overview

XTR_ROLLOVER_TRANSACTIONS_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents rollover, renegotiation, and interest-settlement transaction data maintained by the Treasury dealing and transaction-management functions. A rollover transaction represents a deal that is extended or renewed on or near maturity, generating new interest accrual, principal, tax, and settlement information. This view exposes that data for inquiry, reporting, and downstream processing without requiring the caller to navigate the full set of normalized Treasury transaction tables directly.

The object carries a VALID status in the ETRM data dictionary and is documented against product XTR. It is read-only by definition and is intended for reporting, online inquiry screens, and integration extracts where rollover transaction details — including principal actions, interest adjustments, tax attributes, and settlement references — must be surfaced together.

Underlying Base Objects

The documented view metadata lists the following referenced base objects:

  • XTR_ROLLOVER_TRANSACTIONS (synonym) — the primary transaction table. Its alias XD appears throughout the SELECT list, confirming that the view is defined principally over this table.
  • XTR_COMPANY_AUTHORITIES (synonym) — the authority and company-access table, used to constrain results to companies the querying responsibility is authorized to view.
  • XTR_USER_ACCESS (package) — the access-control package invoked to resolve the current user's Treasury access rights at runtime.

This structure follows the standard Treasury security pattern: transaction rows are filtered through the user's company authorities so that a query executed under one responsibility does not expose counterparty deal data belonging to another company or dealing book.

Key Columns

The column list is extensive and reflects the full life cycle of a rollover transaction. Notable columns include:

Columns suffixed _HCE carry home-currency-equivalent amounts for multi-currency reporting.

Common Use Cases and Queries

Typical uses include rollover maturity reporting, interest and tax reconciliation, counterparty exposure review, and feeds into treasury data warehouses.

  • Listing rollovers maturing within a period for a portfolio.
  • Extracting interest and principal settlement amounts by counterparty.
  • Reconciling accrued interest against general ledger balances.
  • Identifying transactions pending renegotiation (NI_RENEG_DATE).

Sample query:

SELECT transaction_number, cparty_code, product_type, start_date, maturity_date, interest_rate, accum_interest_hce, principal_action, status_code
FROM xtr_rollover_transactions_v
WHERE maturity_date BETWEEN :p_from AND :p_to
ORDER BY maturity_date, transaction_number;