Results for “fii_currency_api”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
View: PJI_CURRENCY_TYPES_V 12.1.1
This is an internal summarization view.
APPS.PJI_CURRENCY_TYPES_V·↳ FII_CURRENCIES_V·↳ FII_CURRENCY_API·↳ GL_SETS_OF_BOOKS·Explore PJI module →
-
View: FII_CURRENCIES_V 12.1.1
Internal view used to support currency dimension in DBI.
APPS.FII_CURRENCIES_V·↳ FII_CURRENCY_API·↳ FND_CURRENCIES·↳ DUAL·Explore FII module →
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.FII_CURRENCIES_V 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - PJI Tables and Views 12.1.1
-
eTRM - FII Tables and Views 12.1.1
This table stores the mapping of leaf nodes from pruned dimension to nodes in the child value sets
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - PJI Tables and Views 12.1.1
-
eTRM - FII Tables and Views 12.1.1
This table stores the mapping of leaf nodes from pruned dimension to nodes in the child value sets