Search Results fnd_currency_cache




Overview
Explore in AI Chat

Overview

FND_CURRENCY_CACHE is a PL/SQL package body owned by the APPS schema that provides the caching and formatting infrastructure for currency display information in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to resolve currency-specific formatting rules — such as the number of decimal places, thousands separators, and display masks — so that monetary amounts are rendered consistently across the application. Because currency formatting is requested constantly by forms, reports, and concurrent programs, the package caches format information derived from the FND_CURRENCIES table rather than querying it on every call. The object is classified as OTHER in the ETRM repository and carries a status of VALID, confirming that it compiles cleanly in the documented environment.

Key Procedures and Functions

The documented interface exposes three program units, all oriented toward retrieving or constructing currency format definitions:

  • BUILD_FORMAT_MASK — Constructs a currency format mask from the underlying currency definition attributes. This unit assembles the mask that governs how a numeric amount is displayed, using the precision and separator characteristics defined for the currency.
  • GET_FORMAT_MASK — Returns the format mask for a requested currency. This is the primary access point used by callers that need to render an amount in the correct currency presentation. Internally it leverages the cached values rather than rebuilding the mask on each invocation.
  • GET_INFO — Retrieves general cached information about a currency. It serves as the broad information accessor for callers that require more than the format mask alone, such as precision or related currency attributes.

The package therefore follows a build-once, retrieve-many pattern: BUILD_FORMAT_MASK performs the construction work, while GET_FORMAT_MASK and GET_INFO serve as the retrieval API for dependent code.

Tables Accessed

The package references APPS.FND_CURRENCIES through the APPS synonym layer. FND_CURRENCIES is the foundational currency definition table in EBS, storing the enabled currencies, their precision, and related formatting attributes. FND_CURRENCY_CACHE reads this table to obtain the raw currency attributes that BUILD_FORMAT_MASK transforms into display masks and that GET_INFO and GET_FORMAT_MASK return to callers. The recorded dependency listing also shows references to FND_CURRENCY_CACHE itself, consistent with the package's caching role, and to FND_PROFILE, indicating that profile option settings influence currency behavior or locale handling. The SYS.STANDARD dependency reflects standard PL/SQL language constructs.

Usage Notes

FND_CURRENCY_CACHE is a widely consumed utility. ETRM records indicate it is referenced by 19 other database objects, while it references no external application objects beyond FND_CURRENCIES and FND_PROFILE, placing it near the base of the currency-handling dependency chain. It is typically invoked indirectly whenever an EBS form, Oracle Reports output, or concurrent program must format a monetary value for display, and it may also be called from custom PL/SQL code that renders amounts. Because the package exists to avoid repeated lookups against FND_CURRENCIES, customizations should call GET_FORMAT_MASK or GET_INFO in preference to querying the table directly. Implementers should note that FND_CURRENCY_CACHE is not documented as being referenced by the FND_CURRENCY_CACHE package body itself in the reverse-dependency listing; rather, its consumers initiate all calls. As with all APPS-owned packages, direct modification is not supported, and the interface should be treated as read-only from the perspective of custom development.