Search Results xtr_dealer_limits




Overview
Explore in AI Chat

Overview

The XTR_DEALER_LIMITS table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically in versions 12.1.1 and 12.2.2. It serves a critical control function by defining and enforcing trading limits for authorized dealers. The table stores the maximum monetary or volume thresholds that a dealer is permitted to transact for specific combinations of financial products and deal types. This data is essential for operational risk management, ensuring that trading activities remain within predefined, authorized boundaries to mitigate financial exposure and enforce internal compliance policies.

Key Information Stored

The table's structure centers on a unique combination of a dealer, a deal type, and a product type, which together form its primary key (XTR_DEALER_LIMITS_UK). The most critical columns include DEALER_CODE, which identifies the authorized trader; DEAL_TYPE, which classifies the transaction (e.g., Spot, Forward, Swap); and PRODUCT_TYPE, which specifies the financial instrument (e.g., Foreign Exchange, Money Market). The core business data is stored in limit amount columns, which define the maximum value permitted for the given combination. While the exact column names for the limit amounts are not detailed in the provided metadata, they typically include fields for different limit categories, such as daily, per-deal, or cumulative limits, often denominated in a specific currency.

Common Use Cases and Queries

The primary use case is the real-time validation of treasury transactions. Before a deal is confirmed, the application checks this table to ensure the proposed transaction does not exceed the dealer's authorized limit for that product and deal type. Common reporting and audit queries involve listing all limits for a specific dealer or identifying dealers with limits for a particular product. A typical SQL pattern for checking a dealer's limits would be:

  • SELECT DEALER_CODE, DEAL_TYPE, PRODUCT_TYPE, LIMIT_AMOUNT FROM XTR.XTR_DEALER_LIMITS WHERE DEALER_CODE = '&DEALER';

Another critical use case is exposure reporting, where data from this table is joined with live transaction data from tables like XTR_DEALS to calculate utilization percentages and flag dealers approaching their thresholds.

Related Objects

As indicated by its foreign key constraints, XTR_DEALER_LIMITS is tightly integrated with other master data tables in the Treasury module. It references XTR_DEALER_CODES to validate the dealer, XTR_DEAL_TYPES for the deal classification, and XTR_PRODUCT_TYPES for the financial product definition. This relationship ensures data integrity and that limits are only assigned to valid, active combinations. The table is also a likely reference point for various treasury transaction processing forms, workflow rules, and risk management reports within the XTR application.