Search Results gl_mc_currency_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_MC_CURRENCY_PKG is a multi-currency (MC) currency utility package in the Oracle E-Business Suite General Ledger module. Its documented status is VALID and it resides in the APPS schema. It serves the core business function of resolving currency-related attributes for multiple reporting currencies and secondary ledgers, providing callers with currency codes, conversion rate types and rates, and rounding behavior tied to a given ledger and book relationship.

The package is classified as OTHER in the ETRM 12.2.2 metadata and is documented with seven procedures and functions. It is widely depended upon: the metadata states that it is referenced by 14 other packages. It is not referenced directly by any database object other than its own dependents, indicating that it is consumed as a shared internal utility rather than as a trigger or view source. Its documented dependencies include APP_EXCEPTION, FND_CURRENCIES, FND_LOG, FND_MESSAGE, GL_CURRENCY_API, GL_DAILY_CONVERSION_TYPES, GL_JE_INCLUSION_RULES, GL_LEDGER_RELATIONSHIPS, GL_MC_INFO, and FA_MC_BOOK_CONTROLS, among others.

Key Procedures and Functions

The documented program units are the following seven:

  • GET_CURRENCY_CODE — Returns the currency code associated with a given multi-currency context, drawing on the FND_CURRENCIES foundation.
  • GET_MRC_SOB_TYPE_CODE — Returns the set of books or ledger type code used in the multi-currency reporting context, resolving the ledger relationship.
  • GET_RATE — Retrieves an exchange rate for a specified conversion type and date, leveraging GL_DAILY_CONVERSION_TYPES and GL_CURRENCY_API.
  • GET_DEFAULT_RATE — Provides the default or fallback exchange rate when no explicit rate is supplied by the caller.
  • GETCURRENCYDETAILS — Returns a consolidated set of currency details (currency code, precision, rounding conventions) for a given context.
  • CURRROUND — Rounding utility that applies the correct precision for the target currency, typically used in multi-currency reporting conversion.

Tables Accessed

The package accesses the following tables via APPS synonyms:

  • FA_MC_BOOK_CONTROLS — Provides book control settings for fixed assets multi-currency reporting, used to determine currency context.
  • FND_CURRENCIES — Supplies currency code, precision, and rounding information.
  • GL_DAILY_CONVERSION_TYPES — Defines the conversion rate types (Spot, Corporate, User) used by GET_RATE.
  • GL_JE_INCLUSION_RULES — Determines which journal entry sources and categories are included in the reporting context.
  • GL_LEDGER_RELATIONSHIPS — Links the primary ledger to its secondary or reporting ledger, essential for resolving the MRC set of books.

Usage Notes

GL_MC_CURRENCY_PKG is typically invoked from multi-currency reporting programs, General Ledger conversion routines, and custom extensions that need consistent currency resolution. Because it is referenced by 14 other packages, it functions as a central point of currency metadata for MC operations. It is not documented as being called directly from forms or concurrent programs; instead, callers reach it through the dependent packages. Custom code should invoke these public units rather than duplicate rounding or rate lookups, since the package enforces consistent behavior across all multi-currency reporting.