Search Results poa_currency_pkg




Overview
Explore in AI Chat

Overview

POA_CURRENCY_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It provides currency resolution and exchange rate retrieval services for the Procurement Operations Analysis (POA) and Daily Business Intelligence (DBI) reporting components. Rather than owning its own persistent data, the package exposes a set of accessor routines that other packages and programs call to determine which currency should be displayed on a report and what exchange rate should be applied to a foreign-currency amount.

Its scope is intentional and narrow: it centralizes currency logic so that multiple DBI/POA consumers resolve the "global" and "secondary" currencies consistently, honoring Financials system parameters, profile options, and organization-specific overrides. The package is classified under ETRM as an OTHER API, indicating it is documented as a utility package rather than a public integration interface. ETRM records eight documented procedures/functions and confirms the object is VALID. It references seven external packages (including FII_CURRENCY, GL_CURRENCY_API, POA_DBI_UTIL_PKG, BIS_COLLECTION_UTILITIES, and BIS_COMMON_PARAMETERS) and is itself referenced by seven other database objects, confirming its role as a shared dependency in the POA/DBI reporting stack.

Key Procedures and Functions

  • GET_GLOBAL_CURRENCY — Returns the global currency, i.e., the primary reporting currency the system should use for DBI/POA output.
  • GET_GLOBAL_RATE — Returns the exchange rate associated with the global currency, used to convert source amounts into the reporting currency.
  • GET_GLOBAL_CURRENCY_RATE — Returns both the global currency and its rate in a single call, enabling consumers to avoid two round trips.
  • GET_DISPLAY_CURRENCY — Determines the currency that should appear on a report or form at display time, which may differ from the stored functional currency.
  • GET_DBI_GLOBAL_RATE — Provides the global rate in the DBI context.
  • GET_DBI_SGLOBAL_RATE — Provides the secondary global rate in the DBI context.
  • GET_SECONDARY_GLOBAL_CURRENCY — Returns the secondary global currency, supporting dual-currency reporting requirements.
  • DISPLAY_SECONDARY_CURRENCY_YN — Returns a Yes/No flag indicating whether the secondary currency should be displayed, allowing callers to dynamically show or suppress that column.

Tables Accessed

Via APPS synonyms, the package reads FINANCIALS_SYSTEM_PARAMS_ALL, PER_ORGANIZATION_LIST, and DUAL. FINANCIALS_SYSTEM_PARAMS_ALL supplies system-level accounting and currency configuration, including functional currency defaults. PER_ORGANIZATION_LIST is used to resolve organization-specific context so currency decisions can honor the operating unit or organization under which the report runs. DUAL is accessed for single-row scalar evaluations and constant expressions. Through its referenced packages, the package also indirectly leverages GL_SETS_OF_BOOKS, FND_PROFILE, FII_CURRENCY, and GL_CURRENCY_API for set of books and rate lookups.

Usage Notes

POA_CURRENCY_PKG is not an end-user-invoked interface; it is called programmatically by DBI/POA concurrent programs, PL/SQL report logic, and other packages in the reporting layer. Customizations that need to mirror DBI currency behavior should invoke these documented functions rather than reimplementing currency or rate derivation, ensuring the same profile and system-parameter rules are applied. Because the package is referenced by seven other objects, changes to its logic have a broad blast radius within the DBI/POA domain and should be regression-tested against all dependent calls before deployment in either 12.1.1 or 12.2.2.