Results for “gl_currency_api”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.GL_CURRENCY_API package body is the central PL/SQL currency conversion engine within the Oracle E-Business Suite General Ledger module. It provides the programmatic interface through which any application or concurrent process obtains exchange rates and converts monetary amounts between currencies. The package encapsulates the full complexity of Oracle's currency model, including daily rates, fixed (historical) conversion rates, Euro triangulation, and rate derivation rules, exposing it through a stable API layer. Because currency conversion is fundamental to virtually every financial transaction in EBS, this package is one of the most widely depended-upon objects in the Applications schema: the ETRM metadata records that it is referenced by 251 other database objects, though it does not itself reference any database object beyond the tables and standard utilities in its own dependency list.

Key Procedures and Functions

The package exposes thirty-three documented procedures and functions that fall into several functional groupings:

• Rate retrieval: GET_RATE, GET_RATE_SQL, GET_RATE_NUMERATOR_SQL, and GET_RATE_DENOMINATOR_SQL obtain the exchange rate between two currencies on a given date, either directly or by returning SQL fragments used for set-based processing.
• Closest-rate resolution: GET_CLOSEST_RATE, GET_CLOSEST_RATE_SQL, GET_CLOSEST_RATE_NUMERATOR_SQL, and GET_CLOSEST_RATE_DENOM_SQL locate the most recent available rate when no rate exists for the exact date requested. GET_CLOSEST_TRIANGULATION_RATE performs the equivalent lookup through a triangulation currency.
• Amount conversion: CONVERT_AMOUNT and CONVERT_CLOSEST_AMOUNT convert a monetary value using an exact or nearest-available rate, with CONVERT_AMOUNT_SQL and CONVERT_CLOSEST_AMOUNT_SQL providing the corresponding SQL forms.
• Rate classification and derivation: IS_FIXED_RATE, RATE_EXISTS, GET_RELATION, GET_DERIVE_TYPE, GET_EURO_CODE, and GET_TRIANGULATION_RATE determine whether a rate is fixed, whether a rate relationship is defined, how a rate is derived, and how Euro and triangulation relationships resolve.

Tables Accessed

The package reads from five documented base tables through APPS synonyms. FND_CURRENCIES supplies currency definitions, precision, and Euro membership attributes. GL_DAILY_RATES is the primary source of dated, user-maintained exchange rates. GL_FIXED_CONV_RATES holds historical fixed conversion rates used for EMU and legacy currency relationships. GL_LEDGERS provides ledger-specific currency options, such as the ledger's target and triangulation currency settings, while GL_PERIOD_STATUSES contributes period and accounting-date context used when resolving rates or validating conversion timing.

Usage Notes

Because the metadata states that no database object references GL_CURRENCY_API, consumption occurs at runtime through direct PL/SQL calls rather than compiled package dependencies. The package is invoked by Oracle General Ledger forms and concurrent programs, by subledger applications such as Payables, Receivables, and Assets that require conversion during entry and posting, and by custom PL/SQL or SQL that must obtain rates or convert amounts. It is also heavily used by Journal Import and other interfaces. Custom code should call the public API routines—such as GET_RATE or CONVERT_AMOUNT—rather than querying GL_DAILY_RATES directly, ensuring that derivation rules, fixed rates, and triangulation logic are applied consistently.