Search Results get_cur_conv_rates

Overview

The APPS.GL_EXCH_RATES_SYNC_PKG package is a server-side PL/SQL utility within the Oracle E-Business Suite General Ledger schema. Its name indicates its purpose: synchronizing and retrieving foreign exchange conversion rate information used throughout the Oracle General Ledger and subledger modules. Foreign currency transactions require accurate conversion rates between a transaction currency and the functional (ledger) currency, and Oracle EBS stores these rates in the daily rates tables maintained by the General Ledger application. This package acts as a programmatic access layer that exposes these rates to calling processes in a structured form.

The package is classified as an OTHER API under the ETRM metadata model, meaning it is not a formally published public interface such as an Open Interface or a documented PL/SQL API, but rather an internal utility invoked by other Oracle components. It resides in the APPS schema and is documented as VALID in ETRM 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API surface of this package consists of a single procedure or function:

• GET_CUR_CONV_RATES — The core routine of the package. Its purpose is to retrieve currency conversion rates, returning them in the structured object type GL_CUR_CONV_RATE_OBJ_TBL, which the package references as a dependency. This object type is a PL/SQL collection of currency conversion rate records that allows the routine to return multiple rates in a single invocation. The routine likely accepts one or more currency pairs, a conversion date, and a conversion type, resolving the appropriate rate from the General Ledger daily rates and cross-rate rule configuration.

No additional documented procedures or functions are listed in the ETRM metadata. Parameter lists are not documented, so callers should consult the package specification in the EBS instance (for example, via the Show Dependent Code feature in ETRM or USER_SOURCE) to determine the exact signature.

Tables Accessed

The package draws its data from the following documented tables, referenced through APPS synonyms:

• GL_DAILY_RATES — The primary store of foreign exchange rates in Oracle General Ledger. Each row defines a rate between a from currency and a to currency for a given conversion date and conversion type. This is the principal source of the retrieval logic.
• GL_DAILY_CONVERSION_TYPES — Defines the permitted conversion types (such as Spot, Corporate, User-defined) that determine which rate to use when multiple rates exist between the same currency pair.
• GL_CROSS_RATE_RULES and GL_CROSS_RATE_RULE_DTLS — Configuration for deriving cross rates when no direct rate exists between two currencies. These tables allow the package to triangulate a rate via an intermediate currency according to defined rules.
• PLITBLM — A System/standard PL/SQL table utility referenced in the dependency metadata, typically used for internal collection handling rather than business data.

The package also references the object type GL_CUR_CONV_RATE_OBJ_TBL, which structures the returned rate data.

Usage Notes

Because this package is classified as an internal OTHER API and is referenced by no other documented packages, it is typically invoked indirectly by Oracle forms, concurrent programs, or custom PL/SQL code that needs a consolidated view of conversion rates. Developers writing customizations should prefer the officially supported currency API (GL_CURRENCY_API) for rate maintenance and conversion when available, and treat GL_EXCH_RATES_SYNC_PKG as an internal helper whose signature may change between point releases.

When diagnosing rate-related issues in 12.1.1 or 12.2.2, GET_CUR_CONV_RATES can be used to confirm which rate the system resolves for a given currency pair, date, and conversion type. Because the underlying data comes from GL_DAILY_RATES and cross-rate rules, any invocation is subject to the standard rate maintenance and conversion type setup defined in General Ledger.