Search Results xtr_auth_ccy_combinations




Overview
Explore in AI Chat

Overview

The XTR_AUTH_CCY_COMBINATIONS table is a core reference data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module. It serves as the system of record for defining and controlling valid currency pairs that can be utilized in treasury transactions across the application. Its primary role is to enforce business rules by authorizing specific currency combinations for trading, hedging, and other financial operations, thereby preventing the entry of invalid or unauthorized foreign exchange (FX) deals. This table is critical for maintaining data integrity and operational control in a global treasury environment, functioning as a foundational lookup for currency pair validation in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to define a currency pair and its authorization status. Based on the provided metadata, the key columns are the composite primary key, which consists of CURRENCY_QUOTE_FIRST and CURRENCY_QUOTE_SECOND. These columns store the codes for the base (first) and counter (second) currencies that form a pair, such as USD/EUR. While the explicit column list from the full ETRM is not provided, the description indicates the table stores information on "whether a combination is authorised for use." This strongly implies the presence of a status or authorization flag column (e.g., AUTHORIZED_FLAG, STATUS). The table's integrity is maintained through foreign key constraints linking both currency columns to the XTR_MASTER_CURRENCIES table, ensuring only valid, master-defined currencies are used in combinations.

Common Use Cases and Queries

The primary use case is the validation of currency pairs during the creation of treasury transactions like foreign exchange spots, forwards, and swaps. Before a deal is booked, the application will query this table to confirm the entered currency pair is authorized. Common reporting and maintenance queries include listing all active currency combinations or identifying which currencies a specific currency can be paired with. A typical SQL pattern for checking authorization would be:

SELECT currency_quote_first, currency_quote_second FROM xtr.xtr_auth_ccy_combinations WHERE currency_quote_first = 'USD' AND currency_quote_second = 'JPY' AND authorized_flag = 'Y';

Administrators may also run queries to audit setup or integrate this reference data into downstream financial reporting systems.

Related Objects

The table has defined relationships with several other key Treasury tables, as documented in the foreign key metadata:

  • XTR_MASTER_CURRENCIES: The source of valid currency codes. XTR_AUTH_CCY_COMBINATIONS.CURRENCY_QUOTE_FIRST and .CURRENCY_QUOTE_SECOND are foreign keys to this master table.
  • XTR_BUY_SELL_COMBINATIONS: This table references XTR_AUTH_CCY_COMBINATIONS. The columns XTR_BUY_SELL_COMBINATIONS.CURRENCY_FIRST and .CURRENCY_SECOND are foreign keys to the authorized combinations table, indicating it relies on this setup for its valid pairs.

This relationship network positions XTR_AUTH_CCY_COMBINATIONS as a central reference point between the master currency list and transactional tables that execute deals based on those currency pairs.