Search Results derive_effective

Overview

ASO_I_CURRENCIES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, registered under the ASO (Order Capture) product family. It is a thin projection over the Oracle Foundation currencies dictionary and exposes the currency codes that are valid for use within Order Capture and related pricing, quoting, and order-entry flows. The view does not store data of its own; it presents a filtered, integration-friendly column set drawn from the multilingual currencies view. Its principal purpose is to provide Order Capture components, concurrent programs, and external interfaces with a stable, denormalized list of currencies together with their date-activation windows and derivation attributes.

The presence of the DERIVE_TYPE and DERIVE_EFFECTIVE columns distinguishes this view from a generic currency list. These attributes are relevant to currency derivation logic, in which a transaction currency is inferred from a source context such as a customer, price list, or agreement rather than entered manually. The view therefore supports both simple value-list lookups and the configuration of derived-currency behavior.

Underlying Base Objects

The view is defined exclusively over FND_CURRENCIES_VL, the multilingual (translated) view of the Oracle Foundation currencies entity. Per the ETRM documentation, the referenced base object is FND_CURRENCIES_VL (VIEW), and the view text is a direct SELECT of seven columns from that object. No joins, filters, or aggregations are applied; consequently, ASO_I_CURRENCIES_V inherits the row population, translation behavior, and enabled/disabled semantics of the underlying Foundation currencies definition.

Because FND_CURRENCIES_VL resolves translated NAME values according to the session language, the same row may return different NAME text depending on the NLS environment of the querying session. The CURRENCY_CODE, however, remains invariant and is the recommended join key.

Key Columns

• CURRENCY_CODE — The ISO-style currency identifier (for example, USD, EUR, JPY). This is the primary key for joining to order, price list, and transaction tables.
• NAME — The translated display name of the currency, sourced through FND_CURRENCIES_VL and therefore language-sensitive.
• ENABLED_FLAG — Indicates whether the currency is currently enabled for use. Values are typically Y and N; disabled currencies should generally be excluded from active value lists.
• START_DATE_ACTIVE — The date from which the currency becomes available for use.
• END_DATE_ACTIVE — The date after which the currency is no longer available. A null value indicates no defined expiry.
• DERIVE_TYPE — Classifies how the currency may be derived within Order Capture logic, supporting automated currency determination instead of manual selection.
• DERIVE_EFFECTIVE — The effective date governing the derivation rule, allowing derivation behavior to change over time without altering historical records.

Common Use Cases and Queries

Typical uses include populating currency list-of-values regions on order and quote entry pages, validating incoming currency codes during interface loads, and reporting on the active currency set by effective date. The following query returns all currently enabled currencies:

• SELECT currency_code, name, derive_type, derive_effective FROM aso_i_currencies_v WHERE enabled_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE)) AND NVL(end_date_active, TRUNC(SYSDATE));

To inspect derivation configuration for a specific currency:

• SELECT currency_code, name, derive_type, derive_effective FROM aso_i_currencies_v WHERE currency_code = 'USD';

Because the view carries no filter predicates, organizations that restrict the usable currency set through Foundation setup will see those restrictions reflected automatically. Queries should always constrain ENABLED_FLAG and the active date range to avoid presenting expired or disabled currencies to end users.