Search Results extended_precision

Overview

AR_ALL_ENABLED_CURRENCIES_V is an APPS-owned database view in the Oracle E-Business Suite Receivables (AR) module. It presents the set of currencies that are enabled for use and relevant to the functional currency configuration of the operating unit's set of books, exposing both standard currency attributes and descriptive/flexfield columns. Because it joins Receivables system parameters to the set of books definition, the view resolves the currencies that Receivables actually treats as active for a given ledger context rather than returning every currency defined in the applications.

The view is classified in the ETRM metadata as VALID in both Oracle EBS 12.1.1 and 12.2.2. Its documentation header carries the release marker "(Release 10SC Only)," which reflects the historical origin of the view text; the object nevertheless continues to exist and resolve in later releases, with the same column footprint. For integration and reporting, the view provides a stable, read-only projection of currency master data joined to ledger configuration, and it is commonly used where receivables logic must enumerate the currencies that are legitimately enabled for a business unit.

Underlying Base Objects

The view text references three documented base objects:

• FND_CURRENCIES_VL (VIEW) — the currency definitions view, aliased FC. The view filters this source on CURRENCY_FLAG = 'Y' and ENABLED_FLAG = 'Y', restricting the result set to enabled currencies only.
• AR_SYSTEM_PARAMETERS (SYNONYM) — Receivables system parameters, aliased SP. It supplies SET_OF_BOOKS_ID and CODE_COMBINATION_ID_GAIN, which drive the ledger linkage and the gain/loss account determination.
• GL_SETS_OF_BOOKS (VIEW) — the set of books (ledger) definition, aliased SB. It is joined to AR_SYSTEM_PARAMETERS on SET_OF_BOOKS_ID and provides SB.CURRENCY_CODE, the functional currency of the books.

The join conditions tie the currency row to the Receivables system parameters row and, in turn, to the set of books row. The final currency selection uses a DECODE on SP.CODE_COMBINATION_ID_GAIN: when that gain account combination identifier is empty, the functional currency of the set of books is selected; otherwise, the enabled currency codes are returned. This construction means the view resolves currency values relative to the Receivables and General Ledger configuration of the operating context rather than presenting an unfiltered list.

Key Columns

The view exposes the complete attribute list of the underlying currency definition plus the standard WHO audit and descriptive flexfield columns.

• CURRENCY_CODE — the ISO currency code; the primary business identifier used in joins and lookups.
• NAME and DESCRIPTION — the currency's display name and descriptive text.
• PRECISION — the number of decimal places used for standard currency amounts.
• EXTENDED_PRECISION — the extended precision (number of decimal places) supported for the currency, relevant to high-precision and reporting calculations.
• MINIMUM_ACCOUNTABLE_UNIT — the smallest accountable unit for the currency, governing rounding behavior.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range for the currency.
• ISSUING_TERRITORY_CODE and SYMBOL — issuing territory and the currency symbol.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield context and segment columns carried through from the currency definition.

Common Use Cases and Queries

Typical usage centers on validating which currencies are enabled for receivables processing, resolving precision and extended precision for amount formatting, and reporting on currency configuration alongside ledger context. The following query returns enabled currencies with their precision attributes:

• SELECT currency_code, name, precision, extended_precision, minimum_accountable_unit, symbol FROM ar_all_enabled_currencies_v ORDER BY currency_code;
• SELECT currency_code, extended_precision FROM ar_all_enabled_currencies_v WHERE currency_code = 'USD';
• SELECT c.currency_code, c.name, c.start_date_active, c.end_date_active FROM ar_all_enabled_currencies_v c WHERE SYSDATE BETWEEN c.start_date_active AND NVL(c.end_date_active, SYSDATE);

Because the source is filtered on CURRENCY_FLAG = 'Y' and ENABLED_FLAG = 'Y', these queries naturally return only currencies that are active in the applications, and the join to Receivables system parameters and GL sets of books scopes the result to the ledger configuration of the environment. This makes the view suitable for validation logic, LOV-style lookups in custom reports, and reconciliation between Receivables currency behavior and General Ledger book definitions.