Results for “settle_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• XTR_ROLLOVER_TRANSACTIONS_V (VIEW) — the primary driver, aliased R, supplying deal number, transaction number, dates, principal action, principal adjust, PI amount received, accumulated interest, interest rate, and status code. The filter R.DEAL_TYPE = 'RTMM' restricts output to money-market rollover deals.
• XTR_AMOUNT_TYPES (SYNONYM) — aliased S, joined on DEAL_TYPE = 'RTMM' and AMOUNT_TYPE = NVL(PRINCIPAL_AMOUNT_TYPE,'PRINFLW'), providing AMOUNT_NAME and USER_AMOUNT_TYPE descriptors.
• XTR_DEAL_STATUSES (SYNONYM) — aliased DS, joined on DEAL_TYPE and STATUS_CODE, supplying the USER_STATUS_CODE translation.
• XTR_AMOUNT_ACTIONS (SYNONYM) — aliased AC, joined on DEAL_TYPE, amount type, and ACTION_CODE to supply USER_ACTION_CODE.
• XTR_DEAL_DATE_AMOUNTS_V (VIEW) and XTR_USER_ACCESS (PACKAGE) — referenced in the object's documented dependency list, supporting date-amount derivation and access control respectively.

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.