Search Results gl_archive_daily_balances

Overview

The FND_CURRENCIES table is a core reference table within the Oracle E-Business Suite Application Object Library (FND). It serves as the central repository for all currency definitions enabled for use at an implementation site. This table is fundamental to the financial and transactional modules of Oracle EBS, providing the master list of valid currency codes, their names, and associated formatting and conversion attributes. Its data is critical for ensuring accurate monetary calculations, reporting, and multi-currency processing across the entire application suite, from Accounts Payable to Advanced Pricing.

Key Information Stored

The table's primary key is the CURRENCY_CODE, which is the ISO-standard three-character identifier (e.g., USD, EUR, JPY). Beyond the code, the table stores descriptive and functional attributes for each currency. Key columns include CURRENCY_NAME, DESCRIPTION, ENABLED_FLAG (to control active use), and ISSUING_TERRITORY_CODE (a foreign key to FND_TERRITORIES linking the currency to its country or region of origin). It also holds critical precision data such as PRECISION (the number of decimal places used) and MINIMUM_ACCOUNTABLE_UNIT (the smallest coin denomination, used for rounding). Extended attributes like SYMBOL and ISO_STATUS further define the currency's presentation and standardization status.

Common Use Cases and Queries

This table is primarily queried for validation, reporting, and data population in user interfaces. A common use case is populating a list of values (LOV) for currency selection fields throughout the application. System administrators may query it to review or maintain enabled currencies. For reporting, it is frequently joined to transactional tables to retrieve currency names and symbols. Example queries include fetching all active currencies or retrieving details for a specific code used in an invoice.

• SELECT currency_code, currency_name, precision, enabled_flag FROM apps.fnd_currencies WHERE enabled_flag = 'Y' ORDER BY currency_code;
• SELECT trx.amount, curr.currency_name, curr.symbol FROM ap_invoices_all trx JOIN apps.fnd_currencies curr ON trx.invoice_currency_code = curr.currency_code WHERE trx.invoice_id = :p_invoice_id;

Related Objects

As indicated by the extensive foreign key relationships in the metadata, FND_CURRENCIES is referenced by a vast number of transactional and setup tables across virtually all financial and order management modules. Key foreign key references include AP_INVOICES_ALL (for invoice currency), AR_CASH_RECEIPTS_ALL (for receipt currency), and GL_DAILY_RATES (for conversion rates). The table has a primary foreign key relationship with FND_TERRITORIES via the ISSUING_TERRITORY_CODE column. Furthermore, critical APIs such as FND_CURRENCY_API rely on this table for functions like validating currency codes and retrieving precision for amount formatting.