Search Results xtr_deal_date_amounts




Overview
Explore in AI Chat

Overview

The XTR_DEAL_DATE_AMOUNTS table is a core transactional data store within the Oracle Treasury (XTR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a central repository for detailed financial transaction information associated with treasury deals. As indicated by its description, it groups this information by three critical dimensions: date type, amount type, and amount action. This structure allows the system to track and manage the complex cash flows, valuations, and accounting events that occur throughout the lifecycle of a financial instrument, from initiation to settlement and maturity. Its extensive foreign key relationships underscore its role as a nexus connecting deal headers, transaction details, reference data, and banking information.

Key Information Stored

The table's primary purpose is to record the monetary figures and their associated dates for specific actions within a deal. While the full column list is not provided in the metadata, the foreign key relationships reveal its critical components. The primary key is DEAL_DATE_AMOUNT_ID. Essential foreign keys include DEAL_NUMBER and TRANSACTION_NUMBER, which link to parent deal and transaction tables (XTR_DEALS, XTR_ROLLOVER_TRANSACTIONS, etc.). The dimensional attributes DATE_TYPE, AMOUNT_TYPE, and ACTION_CODE link to their respective reference tables (XTR_DATE_TYPES, XTR_AMOUNT_TYPES, XTR_AMOUNT_ACTIONS) to classify the transaction entry. Crucially, it stores bank account usage identifiers (COMPANY_ACCT_USE_ID, CPARTY_ACCT_USE_ID, BENEFECIARY_ACCT_USE_ID) linking to Cash Management (CE_BANK_ACCT_USES_ALL), enabling precise payment and settlement instructions. The table likely contains columns for the transaction amount, currency, and the relevant effective date.

Common Use Cases and Queries

This table is fundamental for treasury operations and reporting. Common use cases include generating cash flow forecasts by querying future-dated amount actions, reconciling settled transactions by checking completed payment actions, and supporting the calculation of mark-to-market exposures. Financial reporting and audit trails rely on queries against this table to substantiate deal valuations and realized gains/losses. A typical analytical query might join to reference tables to produce a readable report:

  • SELECT dda.deal_number, dt.date_type_name, at.amount_type_name, aa.action_name, dda.amount, dda.currency_code FROM xtr_deal_date_amounts dda JOIN xtr_date_types dt ON dda.date_type = dt.date_type JOIN xtr_amount_types at ON dda.amount_type = at.amount_type JOIN xtr_amount_actions aa ON dda.action_code = aa.action_code WHERE dda.deal_number = :p_deal_num ORDER BY dda.effective_date;

Integration with subledger accounting uses this table's data to create accounting events for amounts tagged with specific action codes.

Related Objects

As shown in the metadata, XTR_DEAL_DATE_AMOUNTS has extensive relationships across the Treasury module. Key related objects include:

This network of relationships positions XTR_DEAL_DATE_AMOUNTS as a central detail table that operationalizes the financial terms defined in a treasury deal master.