Search Results fii_currency_api




Overview
Explore in AI Chat

Overview

The APPS.FII_CURRENCY_API package body is a public PL/SQL API in the Oracle E-Business Suite APPS schema that supports currency-related display and retrieval logic used by the Financial Intelligence (FII) family of applications, most notably the Daily Business Intelligence (DBI) reporting components. Its principal business function is to centralize the resolution of currency names and labels that appear in BI reporting output, providing a consistent, metadata-driven way to convert stored currency codes and conversion type definitions into human-readable display names. The package is classified as an API and holds a VALID status in the database, which indicates it is a supported, active object within the EBS data dictionary.

The package body depends on several standard EBS facilities: FND_PROFILE for retrieving profile option values, FND_MESSAGE for message and label retrieval, BIS_COMMON_PARAMETERS for Business Intelligence System common parameter handling, and GL_DAILY_CONVERSION_TYPES for daily conversion type metadata. It is not referenced by any other database object, confirming that it functions as a self-contained utility surface rather than as a dependency for other server-side code.

Key Procedures and Functions

Four documented program units are exposed by this package:

  • GET_DISPLAY_NAME — Returns the display-oriented name associated with a currency or conversion type, allowing consumers to present a formatted label rather than a raw code.
  • GET_PRIM_CURR_NAME — Retrieves the name of the primary currency, typically the ledger or functional currency configured for the reporting context.
  • GET_SEC_CURR_NAME — Retrieves the name of the secondary currency, used in dual-currency or reporting-currency scenarios where a second currency is presented alongside the primary.
  • GET_ANNUALIZED_CURR_NAME — Returns the currency name used in annualized reporting views, where amounts are expressed on an annualized basis rather than at the transaction or period level.

The documented metadata does not expose signature detail, so these units should be called only in accordance with their published specifications. Callers should not assume positional parameter ordering beyond what is documented.

Tables Accessed

The only documented table or view referenced by this package is GL_DAILY_CONVERSION_TYPES, accessed through the APPS synonym layer. This General Ledger table stores the definitions of daily conversion types — the named rate types such as Spot, Corporate, or User-defined rates — that determine which exchange rate is applied during currency conversion. Its role in this package is to supply the metadata required to label or resolve conversion-type-dependent currency names for BI display purposes. The package performs no documented writes; its behavior is read-only with respect to application data.

Usage Notes

Because FII_CURRENCY_API is not referenced by any other database object, it is not part of an internal call chain invoked automatically by EBS forms or concurrent programs. It is instead intended for direct invocation by reporting and intelligence-generation code, and by customizations that need to reproduce the same currency naming conventions used by the FII/DBI layer. Typical call sites include PL/SQL packages that build BI report output, concurrent programs that produce financial summaries, and bespoke extensions that must align their labels with shipped EBS reporting terminology.

Callers should ensure that the necessary GL and FND profile contexts are initialized before invoking these functions, since the package derives display behavior partly from FND_PROFILE and related lookup sources. No direct responsibility for transaction processing, validation, or data maintenance is assigned to this object; it is a display-name resolution utility only.