Search Results get_display_currency

Overview

OPI_DBI_CURRENCY_PKG is a currency-resolution utility package owned by the APPS schema in Oracle E-Business Suite. It is part of the OPI (Oracle Process/Discrete Manufacturing Intelligence) and DBI (Daily Business Intelligence) family of PL/SQL objects, which supply the reporting and analytics layers of EBS with consistent, pre-derived reference values. The package is declared with AUTHID CURRENT_USER, so its SQL statements execute with the privileges of the invoking user rather than the defining user, a design choice typical of shared utility code that must respect the caller's access to underlying financial and HR tables.

Functionally, the package answers three recurring questions in a multi-organization, multi-currency EBS implementation: which operating unit is in context, what is the "global" (functional or reporting) currency for the installation, and which currency should be displayed to a given user for a given operating unit. This centralizes currency logic that would otherwise be duplicated across BI reports, dashboards, and inquiry screens, ensuring that currency conversions and labels are derived identically across the reporting suite.

Key Procedures and Functions

• GET_OU — Accepts a selected organization identifier and returns a NUMBER. It resolves the operating unit associated with the caller-supplied organization selection, providing the canonical OU key used by downstream currency and reporting logic.
• GET_GLOBAL_CURRENCY — Returns a VARCHAR2 currency code representing the global or installation-level currency. This is the function most directly associated with the search term "get_global_currency." It supplies the default reporting currency when no organization-specific override applies.
• GET_DISPLAY_CURRENCY — Accepts a currency code, a selected organization, and an optional organization type (defaulting to 'O', presumably for Operating Unit), and returns the currency code that should actually be displayed. This allows the package to substitute a reporting currency for a transaction currency, or to honor organization-level currency settings, depending on the parameters supplied.

The package exposes no documented procedures beyond these three functions, and no parameters have been invented here beyond those visible in the specification header.

Tables Accessed

• FINANCIALS_SYSTEM_PARAMS_ALL — The system-parameter table for financials, read to obtain installation- and organization-level currency and accounting configuration.
• FND_PRODUCT_GROUPS — The Applications product group table, consulted to determine the base/global currency established at installation.
• HR_ORGANIZATION_INFORMATION — The HR organization classification table, used to resolve organization types and validate the operating unit context passed into the lookup functions.

All three tables are referenced through APPS synonyms, consistent with the package's APPS ownership and its intent to sit atop the standard shared data model rather than any private schema.

Usage Notes

Because the package is referenced by zero other packages per the ETRM metadata, it is consumed primarily by external callers: BI/DBl report definitions, Oracle Forms-based inquiry windows, OAF pages, and custom PL/SQL or concurrent programs that need consistent currency labeling. In practice, a report or dashboard invokes GET_OU to establish the operating unit, then GET_GLOBAL_CURRENCY or GET_DISPLAY_CURRENCY to determine which currency to present, avoiding hard-coded currency logic in each report. The AUTHID CURRENT_USER clause means callers must themselves hold privileges on the underlying financials and HR objects, so custom code invoking this package should be granted access to FINANCIALS_SYSTEM_PARAMS_ALL, FND_PRODUCT_GROUPS, and HR_ORGANIZATION_INFORMATION as required. The same package signature is expected to be present in both 12.1.1 and 12.2.2, so customizations built against it should remain portable across those releases.