Search Results ext_precision

Overview

FIIBV_CURR_CURRENCY_LCV is a base view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FII (Financial Intelligence) product family. Within the Oracle EBS 12.1.1 and 12.2.2 data model, it serves as the currency-level foundation of the currency dimension used by Financial Intelligence reporting and analytical structures. Its principal role is to expose a denormalized, presentation-ready projection of the currency master data held in FND_CURRENCIES and its translated sibling FND_CURRENCIES_TL, so that downstream FII dimensions, extracts, and business intelligence layers can resolve currency attributes consistently.

The view is flagged VALID in the ETRM metadata, and its naming convention follows the FII base-view standard: the FIIBV prefix identifies it as a base view, CURR denotes the currency dimension, and CURRENCY_LCV indicates the currency level within that dimension. Because it is a view rather than a table, it holds no data of its own; it is a query-time projection over the currency setup tables.

Underlying Base Objects

Although the ETRM metadata records no explicitly documented referenced base objects, the view text establishes its dependencies directly. FIIBV_CURR_CURRENCY_LCV is defined over two Oracle Application Object Library tables:

• FND_CURRENCIES CUR — the primary source of currency attributes, supplying flags, derivation parameters, precision settings, symbols, and date ranges.
• FND_CURRENCIES_TL FCT — the translated (language-dependent) table, supplying the currency NAME and DESCRIPTION.

The two are joined on CURRENCY_CODE, with FCT filtered by FCT.LANGUAGE = USERENV('LANG') so that the returned name and description match the session language. A single-row scalar function call, EDW_INSTANCE.GET_CODE, truncated to forty bytes via SUBSTRB, populates the INSTANCE column. The view text also carries descriptive flexfield references ('_DF:FND:FND_CURRENCIES:CUR' and '_DF:JG:JG_FND_CURRENCIES:CUR'), which indicate that currency descriptive flexfield context segments can be surfaced through this base view.

Key Columns

• CURRENCY_PK — the currency code, acting as the primary key for the currency level; duplicated in CURRENCY.
• CURRENCY — the ISO currency code as stored in FND_CURRENCIES.
• NAME / DESCRIPTION — language-specific currency name and description sourced from FND_CURRENCIES_TL.
• SYMBOL — the display symbol for the currency.
• MIN_ACCOUNT_UNIT — sourced from MINIMUM_ACCOUNTABLE_UNIT, this defines the smallest unit in which amounts may be accounted for the currency.
• PRECISION / EXT_PRECISION — standard and extended precision settings controlling rounding and display.
• DERIVE_TYPE, DERIVE_EFFT_DATE, DERIVE_FACTOR — currency derivation (euro conversion) parameters, including the effective date and multiplier.
• CURRENCY_FLAG, ENABLED_FLAG, ISO_FLAG — status and classification indicators for the currency.
• DATE_EFFECTIVE / DATE_END — active date range from START_DATE_ACTIVE and END_DATE_ACTIVE.
• INSTANCE — the EDW instance code derived from EDW_INSTANCE.GET_CODE.
• ALL_FK — a constant 'ALL' value used as a dummy foreign-key placeholder for the all-currencies rollup.
• LAST_UPDATE_DATE — audit timestamp supporting incremental extraction.

Common Use Cases and Queries

The view is typically consumed by FII dimension loads, currency-conversion logic, and reporting queries that need a language-aware currency listing. A frequent need is to list enabled currencies with their minimum accountable unit and precision:

SELECT currency_pk, name, symbol, min_account_unit, precision, ext_precision
FROM   apps.fiibv_curr_currency_lcv
WHERE  enabled_flag = 'Y'
ORDER  BY currency_pk;

A second scenario retrieves euro-derivation parameters for conversion reporting:

SELECT currency_pk, derive_type, derive_factor, derive_efft_date
FROM   apps.fiibv_curr_currency_lcv
WHERE  derive_type IS NOT NULL;

A third supports incremental extraction of changed currencies using the audit column:

SELECT currency_pk, name, last_update_date
FROM   apps.fiibv_curr_currency_lcv
WHERE  last_update_date >= :p_since;

Because the view filters translation rows by USERENV('LANG'), callers receive NAME and DESCRIPTION in their session language, making it suitable for both multilingual reporting and integration feeds requiring localized currency labels.