Search Results as_multi_currencies_pkg




Overview
Explore in AI Chat

Overview

AS_MULTI_CURRENCIES_PKG is a PL/SQL package owned by the APPS schema that supports multi-currency rate maintenance within the Oracle E-Business Suite. Its principal business function is to maintain the mapping between source billing or transaction currency types and the currency types recognized by Oracle Receivables (AR) and General Ledger (GL), and to load the corresponding daily conversion rates into the GL_DAILY_RATES_INTERFACE table for validation and import. The package therefore acts as a bridge between application-specific currency definitions and the standard Oracle rate architecture, ensuring that foreign-currency transactions are converted using rates that have been correctly mapped, staged, and validated before they become effective in the GL_DAILY_RATES repository.

The package is classified as OTHER in the ETRM 12.2.2 API classification scheme, indicating that it is not a public, supported interface API in the same sense as an FND_API-based business API, but rather an internal utility used by the application's multi-currency configuration and load processes. Its dependencies include the FND_API package and the SYS.STANDARD package, which is typical of packages that raise standard exceptions and use the Oracle Forms/PL/SQL conventions.

Key Procedures and Functions

The documented package exposes six procedures, organized into two functional groups:

  • INSERT_TYPE_MAPPINGS — Creates new records that associate a source currency type with a target currency type recognized by the application, adding the mapping rows to the multi-currency type mapping table.
  • UPDATE_TYPE_MAPPINGS — Modifies existing currency type mapping records, allowing an administrator to correct or change the target currency type associated with a given source type.
  • DELETE_TYPE_MAPPINGS — Removes currency type mapping records that are no longer required, typically when a currency type configuration is retired or restructured.
  • INSERT_PERIOD_RATES — Inserts period-specific daily conversion rates, staging them for the multi-currency rate load process.
  • UPDATE_PERIOD_RATES — Amends previously loaded period rates, supporting correction of rate values or effective dates.
  • DELETE_PERIOD_RATES — Deletes period rate records, generally to reverse or discard a staged or erroneous rate load.

These six procedures follow a consistent insert/update/delete pattern, reflecting the package's role as a maintenance layer for two related sets of configuration data: currency type mappings and period rates.

Tables Accessed

The package references three tables through APPS synonyms:

  • AS_MC_TYPE_MAPPINGS — Stores the mapping between source and target currency types. This is the primary table manipulated by INSERT_TYPE_MAPPINGS, UPDATE_TYPE_MAPPINGS, and DELETE_TYPE_MAPPINGS, and it defines which currencies are eligible for conversion and how they are identified.
  • GL_DAILY_RATES_INTERFACE — The standard Oracle General Ledger interface table used to stage daily conversion rates prior to validation and import into GL_DAILY_RATES. The period rate procedures populate or amend this table, after which the standard GL rate import process validates and transfers the rows.
  • PLITBLM — A PL/SQL internal table (index-by table) type used by Oracle's server-side PL/SQL for bulk operations. Its presence among the referenced tables indicates that the package uses bulk collect or bulk binding techniques when processing rate and mapping data sets.

Usage Notes

AS_MULTI_CURRENCIES_PKG is typically invoked from Oracle Forms-based multi-currency setup or rate maintenance screens, from concurrent programs that load period rates, or from custom PL/SQL routines that require programmatic maintenance of currency type mappings and conversion rates. Because the package stages data in GL_DAILY_RATES_INTERFACE, callers must be aware that a successful procedure call does not by itself create effective GL rates; the standard GL daily rate interface validation and import process must subsequently run to move the staged rows into GL_DAILY_RATES.

The package is referenced by only one other package, AS_MULTI_CURRENCIES_PKG_W, which is the conventional Oracle wrapper that exposes the core package's procedures to Forms and other clients. Practitioners should note that the package is part of the multi-currency framework and should be used in conjunction with the correct period, rate type, and currency type definitions to avoid inconsistent mapping or rate data. Because the metadata classifies this as an OTHER API rather than a supported public API, direct custom invocations should be undertaken with caution and fully tested in a non-production environment before deployment.