Search Results xtr_buy_sell_combinations




Overview
Explore in AI Chat

Overview

The XTR_BUY_SELL_COMBINATIONS table is a core reference data object within the Oracle E-Business Suite Treasury (XTR) module. It serves as a master repository for defining and validating permissible currency pairs for financial transactions. Its primary role is to enforce business rules by establishing which currency can be bought (CURRENCY_BUY) in exchange for another currency that is sold (CURRENCY_SELL). This table is fundamental to the deal capture and validation processes in Oracle Treasury, ensuring that all foreign exchange, money market, and derivative deals reference a pre-authorized and controlled currency combination, thereby maintaining data integrity and compliance.

Key Information Stored

The table's structure is relatively simple but critical, with its primary key being the combination of the two currency columns. The essential columns are:

  • CURRENCY_BUY: Stores the three-character ISO code for the currency being purchased in the transaction.
  • CURRENCY_SELL: Stores the three-character ISO code for the currency being sold or paid in the transaction.

Each record represents a single, valid buy/sell currency pair. The existence of a specific combination in this table typically authorizes its use in deal entry. The table does not store transactional amounts or rates but acts as a control mechanism for the currencies involved in those transactions.

Common Use Cases and Queries

The primary use case is the validation of currency pairs during the creation of treasury deals in the XTR_DEALS table. A common operational query would check for the authorization of a specific pair before proceeding with a transaction. For reporting and administration, queries often list all authorized combinations or identify which currencies are paired with a specific currency. Sample SQL patterns include:

  • Validation: SELECT 'Y' FROM DUAL WHERE EXISTS (SELECT 1 FROM XTR_BUY_SELL_COMBINATIONS WHERE CURRENCY_BUY = 'USD' AND CURRENCY_SELL = 'EUR');
  • Listing all combinations for a base currency: SELECT CURRENCY_SELL FROM XTR_BUY_SELL_COMBINATIONS WHERE CURRENCY_BUY = 'GBP' ORDER BY CURRENCY_SELL;
  • Master list report: SELECT CURRENCY_BUY, CURRENCY_SELL FROM XTR_BUY_SELL_COMBINATIONS ORDER BY 1, 2;

Related Objects

As indicated by the foreign key relationships, XTR_BUY_SELL_COMBINATIONS is integral to the Treasury data model. The key related objects are:

  • XTR_DEALS: The main transactional table. It references XTR_BUY_SELL_COMBINATIONS via two separate foreign key relationships: one for the deal's primary currency pair (CURRENCY_BUY, CURRENCY_SELL) and another potentially for reference/counter currency combinations (REF_CCY, CTY_CCY).
  • XTR_AUTH_CCY_COMBINATIONS: Another authorization table that references the currencies in XTR_BUY_SELL_COMBINATIONS (CURRENCY_FIRST, CURRENCY_SECOND), suggesting a broader framework for managing approved currency pairs across different Treasury functions.

Maintenance of this table is typically performed through the Oracle EBS application's dedicated setup and reference data screens within the Treasury module, not via direct SQL manipulation.