Search Results xtr_tmm_summary_v




Overview
Explore in AI Chat

Overview

XTR_TMM_SUMMARY_V is an APPS-owned database view within the Oracle E-Business Suite Treasury (XTR) module, delivering a consolidated, reporting-oriented presentation of rollover transaction activity for RTMM (Rollover Treasury Money Market) deals that involve principal action. The view is a UNION ALL of two branches, distinguished by an ORDER_COLUMN value of 'A' and 'B', which together produce an ordered, reconcilable picture of principal movement, interest accrual, deductions, and adjustments against a deal. It is not a transactional entity in its own right; rather it is a denormalized read layer designed for reporting, reconciliation, and downstream integration where a flattened set of principal and interest figures is required.

Because the view derives from the rollover transaction and deal-date amount infrastructure, it reflects the state of rollover processing as computed by the underlying Treasury engine. Its role is primarily as a query surface for Treasury reports, period-end summaries, and interfaces that must present both the transaction-level principal action and the associated interest computation in a single result set.

Underlying Base Objects

The view is defined over the following documented objects in the APPS schema:

Key Columns

  • ORDER_COLUMN, DEAL_NOS, TRANS_NOS — the ordering discriminator and deal/transaction identifiers.
  • SETTLE_DATE, REFERENCE, USER_ACTION_CODE — settlement or maturity date and the descriptive action text.
  • AMOUNT, ADJUST_PRINCIPAL — the principal amount for the row and any principal adjustment arising from the deduction logic.
  • INTEREST_AMOUNT — the central column for interest reporting; returned as R.INTEREST when no PI amount has been received, otherwise zero in the first branch, and computed from accumulated interest and interest in the deduction branch.
  • INTEREST_CFWD, NOS_DAYS, BALANCE_CFWD, RATE — carried-forward interest, day count, carried-forward balance, and the applied rate.
  • PRIN_DECRSE — the excess of PI amount received over accumulated interest brought forward plus current interest, used to quantify principal reduction.
  • STATUS_CODE, USER_STATUS_CODE, AMOUNT_TYPE, USER_AMOUNT_TYPE — coded and translated status and amount-type descriptors.

Common Use Cases and Queries

Typical scenarios include rollover interest reconciliation, principal-versus-interest decomposition for RTMM deals, and audit extracts where the full row set for a deal is required in ORDER_COLUMN sequence.

To isolate interest rows for a specific deal:

  • SELECT DEAL_NOS, TRANS_NOS, INTEREST_AMOUNT, RATE, NOS_DAYS FROM APPS.XTR_TMM_SUMMARY_V WHERE DEAL_NOS = :deal AND INTEREST_AMOUNT <> 0 ORDER BY ORDER_COLUMN;

To summarize principal adjustments by status:

  • SELECT USER_STATUS_CODE, SUM(ADJUST_PRINCIPAL), SUM(INTEREST_AMOUNT) FROM APPS.XTR_TMM_SUMMARY_V GROUP BY USER_STATUS_CODE;

To retrieve the complete ordered picture of a deal, query all columns filtered by DEAL_NOS and ordered by ORDER_COLUMN, TRANS_NOS.