Search Results xtr_mirror_dda_limit_row




Overview
Explore in AI Chat

Overview

XTR_MIRROR_DDA_LIMIT_ROW is a Treasury (XTR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. Per the ETRM documentation, its purpose is to hold cashflow information for all deal transactions with a status of CURRENT. The table therefore functions as a mirror of daily deal activity, capturing the limit-relevant cashflow amounts associated with current deals so that Treasury exposure and limit utilization reporting can be performed. The owner/schema is XTR and the object carries a VALID status in the documented environment.

From a modeling perspective, the heuristic Data Vault classification of this object is satellite-leaning. This suggests it is best understood as a descriptive, context-bearing structure that hangs off a core business key (the deal) rather than as a standalone hub or a pure link. The classification is a modeling suggestion derived from the foreign-key structure, not a physical property of the table.

Key Information Stored

The physical schema documented for ETRM 12.2.2 lists 29 columns. The following are the most significant for functional understanding:

The primary key, XTR_MIRROR_DDA_LIMIT_ROW_PK, is defined on (DEAL_NUMBER, HCE_AMOUNT). This is distinct from the business-key candidate captured by the unique index.

Common Use Cases and Queries

Typical use cases center on limit utilization and Treasury exposure reporting. Analysts join this table to bank account usage data to attribute cashflows to specific bank accounts, and filter on LIMIT_CODE or LIMIT_PARTY to report consumption against a given limit. Status-based filtering isolates the current population, which is the table's defining characteristic.

SELECT r.DEAL_NUMBER, r.DEAL_TYPE, r.CURRENCY,
       r.UTILISED_AMOUNT, r.HCE_UTILISED_AMOUNT, r.LIMIT_CODE
FROM   XTR.XTR_MIRROR_DDA_LIMIT_ROW r
WHERE  r.STATUS_CODE = 'CURRENT'
ORDER BY r.HCE_UTILISED_AMOUNT DESC;

A join path to bank account information:

SELECT r.DEAL_NUMBER, r.LIMIT_PARTY, b.BANK_ACCOUNT_ID
FROM   XTR.XTR_MIRROR_DDA_LIMIT_ROW r,
       CE.CE_BANK_ACCT_USES_ALL b
WHERE  r.BANK_ACCT_USE_ID = b.BANK_ACCT_USE_ID;

Related Objects

  • CE_BANK_ACCT_USES_ALL — Referenced through the foreign key on BANK_ACCT_USE_ID.
  • XTR_MIRROR_DDA_LIMIT_ROW_PK — The primary key constraint on (DEAL_NUMBER, HCE_AMOUNT).
  • XTR_MIRROR_DDA_LIMIT_ROW_U1 — The unique business-key index on (DEAL_NUMBER, TRANSACTION_NUMBER, DEAL_TYPE).

Additional XTR deal and limit tables in the same schema typically share the deal and limit identifiers used here and are commonly queried alongside this object for consolidated Treasury reporting.