Search Results fnd_currencies




The FND_CURRENCIES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a fundamental repository for currency-related data, serving as a cornerstone for multi-currency financial transactions, reporting, and compliance. This table is part of the Oracle Applications Foundation (FND) module, which provides core infrastructure for EBS. Below is a detailed analysis of its structure, purpose, and significance in Oracle EBS implementations.

1. Purpose and Role

The FND_CURRENCIES table stores metadata for all currencies supported within an Oracle EBS environment. It enables organizations to define, manage, and reference currencies for global operations, ensuring accurate financial processing across modules like General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), and Fixed Assets (FA). Key functionalities include:

  • Currency Definition: Stores ISO-standard currency codes (e.g., USD, EUR) alongside descriptive names.
  • Precision and Formatting: Defines decimal precision, symbol placement, and formatting rules (e.g., $1,000.00 vs. 1.000,00 €).
  • Exchange Rate Handling: Supports daily and historical exchange rate management via integration with the GL_DAILY_RATES table.
  • Compliance: Aligns with international standards (ISO 4217) and regulatory requirements.

2. Key Columns and Structure

The table comprises critical columns, including:

Column Name Data Type Description
CURRENCY_CODE VARCHAR2(15) Primary key; ISO 3-letter currency code (e.g., 'USD').
NAME VARCHAR2(80) Descriptive currency name (e.g., 'US Dollar').
SYMBOL VARCHAR2(10) Currency symbol (e.g., '$').
PRECISION NUMBER Decimal precision (e.g., 2 for USD).
EXTENDED_PRECISION NUMBER Used for high-precision calculations.
MINIMUM_ACCOUNTABLE_UNIT NUMBER Smallest monetary unit (e.g., 0.01 for USD).
ENABLED_FLAG VARCHAR2(1) Indicates if the currency is active ('Y'/'N').

3. Integration with EBS Modules

The FND_CURRENCIES table integrates with multiple EBS modules:

  • General Ledger (GL): Defines functional and reporting currencies.
  • Accounts Payable/Receivable (AP/AR): Processes invoices and payments in foreign currencies.
  • Cash Management (CE): Tracks multi-currency bank transactions.
  • Fixed Assets (FA): Manages asset valuations across currencies.

4. Technical Considerations

In EBS 12.1.1 and 12.2.2, the table is often accessed via APIs (e.g., FND_CURRENCY_API) to ensure data integrity. Key technical aspects include:

  • Indexing: Optimized for queries on CURRENCY_CODE.
  • Audit Trails: Changes may be logged in FND_AUDIT_COLUMNS.
  • Upgrades: Preserved during EBS upgrades, but customizations may require validation.

5. Best Practices

To leverage FND_CURRENCIES effectively:

  • Use seeded ISO codes to avoid conflicts.
  • Validate precision settings before currency activation.
  • Monitor exchange rate dependencies in GL_DAILY_RATES.

In summary, the FND_CURRENCIES table is indispensable for global financial operations in Oracle EBS, ensuring consistency, compliance, and accuracy in multi-currency environments.