Results for “show_conversion_rate”

14 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_DAILY_RATES_V is an Oracle E-Business Suite view owned by the APPS schema and classified under the General Ledger (GL) product family. It is defined over the GL_DAILY_RATES table and exposes daily currency conversion rates together with their inverse (reciprocal) rates in a single row. Where the base table GL_DAILY_RATES stores a single directional rate for a given from-currency, to-currency, conversion date, and conversion type, the view joins the table to itself in order to present both the primary rate and the secondary (inverse) rate side by side. This makes the view particularly useful for reporting and integration requirements where both directional quotations are needed simultaneously—for example, when displaying a rate and its reciprocal on the same report line, or when validating that a stored rate and its inverse are internally consistent.

In EBS 12.1.1 and 12.2.2 the view is a read-only reporting construct. It carries no data of its own and reflects the underlying GL_DAILY_RATES and GL_DAILY_CONVERSION_TYPES records at query time. Because it also references the FND_DATA_SECURITY and FND_GLOBAL packages, the view is subject to Oracle Applications data security on conversion types.

Underlying Base Objects

The ETRM metadata for this object documents the following referenced base objects, all resolved through APPS:

  • GL_DAILY_RATES (SYNONYM) — the primary source of conversion rate data. It is referenced twice in the view definition: once as PRIMARY and once as SECONDARY, joined on to-currency/from-currency, conversion date, and conversion type.
  • GL_DAILY_CONVERSION_TYPES (SYNONYM) — aliased CT, joined on CONVERSION_TYPE. This provides the USER_CONVERSION_TYPE and the SECURITY_FLAG that drives the data-security decode logic.
  • FND_DATA_SECURITY (PACKAGE) — invoked through CHECK_FUNCTION to evaluate whether the current user may view, update, or maintain each conversion type.
  • FND_GLOBAL (PACKAGE) — supplies USER_NAME (via FND_GLOBAL.USER_NAME), which is passed into the security check.

By relying on these objects, the view inherits both the conversion rate data model and the conversion type security model of Oracle General Ledger.

Key Columns

The view also emits three additional security-derived flags (view, update, and maintain permissions) computed through FND_DATA_SECURITY against conversion types, allowing callers to enforce access control at the row level.

Common Use Cases and Queries

Typical scenarios include rate maintenance screens, currency revaluation reporting, and conversion interfaces that require both a rate and its reciprocal.

Retrieve the effective daily rate for a currency pair:

  • SELECT from_currency, to_currency, conversion_date, user_conversion_type, conversion_rate, show_conversion_rate, show_inverse_con_rate FROM gl_daily_rates_v WHERE from_currency = 'USD' AND to_currency = 'EUR' AND conversion_date = SYSDATE;

List inverse relationships for a conversion type within a date range:

  • SELECT from_currency, to_currency, conversion_date, conversion_rate, show_inverse_con_rate FROM gl_daily_rates_v WHERE conversion_type = 'Corporate' AND conversion_date BETWEEN :start_date AND :end_date ORDER BY conversion_date, from_currency;

Because security is applied dynamically, the view returns rows only for conversion types the current user is authorised to access, making it suitable for building secure, self-service rate reports and concurrent program extracts.