Search Results xtr_master_currencies




Overview
Explore in AI Chat

Overview

The XTR_MASTER_CURRENCIES table is a core master data table within the Oracle E-Business Suite Treasury (XTR) module, serving as the system of record for currency-specific treasury parameters. It extends the foundational currency information available in standard Oracle Applications (such as FND_CURRENCIES) by storing critical financial and operational attributes required for sophisticated treasury management. Its primary role is to define the rules and limits governing how each currency is handled across the suite of treasury transactions, risk calculations, and cash management operations, thereby centralizing control and ensuring consistency in global treasury activities.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the description confirms the table holds essential treasury configuration for each currency. Based on standard practice and the description, key stored information includes the CURRENCY code (the primary key), the NET_MAXIMUM_EXPOSURE limit for risk management, the QUOTATION_BASIS (e.g., direct or indirect), and the YEAR_BASIS (e.g., 360, 365, Actual) used for day count calculations in interest accruals. It likely also contains flags or fields controlling currency availability for trading, reporting, and settlement within the Treasury module.

Common Use Cases and Queries

This table is fundamental for treasury operations and reporting. Common use cases include validating currency parameters before deal entry, calculating exposure limits, and determining the correct day count convention for interest calculations. A typical reporting query might join this table with transaction data to analyze exposures against defined limits. For example, to list all currencies with their configured year basis and net maximum exposure, a query would be: SELECT currency, year_basis, net_maximum_exposure FROM xtr.xtr_master_currencies WHERE currency IS NOT NULL ORDER BY currency;. Another common pattern is to use this table as a filter or validation source in PL/SQL logic for treasury batch processes and settlement engines.

Related Objects

As indicated by the extensive foreign key relationships, XTR_MASTER_CURRENCIES is a central reference point for numerous transactional and setup tables within the XTR schema. Key dependent objects include:

This network of relationships underscores the table's critical role in maintaining referential integrity and consistent currency behavior across the Treasury module.