Search Results currency_flag




Overview
Explore in AI Chat

Overview

FII_CURR_CURRENCY_LCV is an Oracle EBS collection view owned by the APPS schema within the Financial Intelligence (FII) product family. According to the ETRM repository, the view is the "collection view for currency level of currency dimension," meaning it exposes the currency-level members of the currency dimension that feeds the FII analytical and reporting infrastructure. It has a status of VALID and is available in both Oracle EBS 12.1.1 and 12.2.2.

In practice, this view is one of the standard dimensional collection views FII ships to represent members, hierarchies, and their attributes for downstream reporting, extraction, and integration routines. Reports and ETL processes that need currency-level metadata — rather than transactional balances — query the LCV (level collection view) rather than the underlying base tables directly.

Underlying Base Objects

The documented definition is a thin projection. The view text is:

No base tables are separately documented in the ETRM metadata; the single referenced object is FIIBV_CURR_CURRENCY_LCV, the base view (BV) that holds the actual currency-level collection logic and joins. The LCV layer exists primarily to standardize the exposed column list and to append the five USER_ATTRIBUTE columns (returned as literal NULLs here) so that all FII collection views present a consistent interface. Because it selects one-to-one from the base view, no row multiplication or aggregation occurs at this layer.

Key Columns

  • CURRENCY_PK — Surrogate primary key identifying the currency-level member.
  • ALL_FK — Foreign key to the "All" / total member of the dimension, used for hierarchy rollups.
  • CURRENCY_FLAG / ISO_FLAG — Flags indicating whether the member is a currency and whether it is ISO-qualified.
  • DERIVE_TYPE, DERIVE_EFFT_DATE, DERIVE_FACTOR — Metadata governing derived currency members.
  • NAME, DESCRIPTION, CURRENCY, SYMBOL — Presentation attributes (currency name, code, and symbol).
  • DATE_EFFECTIVE / DATE_END — Effective-dating range for the member, controlling which rows are current for a given period.
  • ENABLED_FLAG — Whether the member is active for reporting.
  • PRECISION, EXT_PRECISION, MIN_ACCOUNT_UNIT — Currency precision and minimum accounting unit attributes.
  • INSTANCE, LAST_UPDATE_DATE — Instance identifier and audit column; USER_ATTRIBUTE1–5 appear as NULL placeholders.

Common Use Cases and Queries

A typical use case is populating or validating the currency dimension for a reporting period, filtering on the effective-dating and enabled columns:

  • SELECT CURRENCY_PK, CURRENCY, NAME, SYMBOL, DATE_EFFECTIVE, DATE_END, ENABLED_FLAG FROM APPS.FII_CURR_CURRENCY_LCV WHERE ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN DATE_EFFECTIVE AND NVL(DATE_END, SYSDATE + 1);
  • SELECT CURRENCY, PRECISION, EXT_PRECISION, MIN_ACCOUNT_UNIT FROM APPS.FII_CURR_CURRENCY_LCV WHERE ISO_FLAG = 'Y';
  • SELECT a.CURRENCY, a.NAME FROM APPS.FII_CURR_CURRENCY_LCV a WHERE a.DERIVE_TYPE IS NOT NULL;

Because the view resolves effective dating at the collection-view layer, it is well suited for point-in-time reconciliation of currency metadata before loading FII fact tables or producing dimensional extracts.