Search Results gl_conversion_type




Overview
Explore in AI Chat

Overview

APPS.GLBV_GL_CONVERSION_TYPES is a read-only Oracle EBS view that exposes the set of currency conversion types defined in the General Ledger application. It is a "BV" (business view) style object that presents a simplified, denormalized projection of the underlying GL_DAILY_CONVERSION_TYPES base table. Its purpose in the EBS reporting and integration layer is to provide a stable, query-friendly interface through which concurrent programs, reports, and external interfaces can retrieve the list of valid conversion types and their descriptive attributes without directly referencing the transactional base table.

In Oracle EBS 12.1.1 and 12.2.2, currency conversion types (such as Spot, Corporate, User-defined, and others) drive how foreign currency amounts are translated between the entered and functional currencies. Because these types are referenced widely across subledgers and General Ledger, a dedicated read-only view serves as a controlled access point for lookups and validation.

Underlying Base Objects

According to the documented view text, GLBV_GL_CONVERSION_TYPES is defined with a single source and a WITH READ ONLY clause:

  • GL_DAILY_CONVERSION_TYPES — the sole referenced base table, aliased internally as GL_CONVERSION_TYPE. The view performs no joins, aggregations, or filters; it is a straight projection of three columns from that table.

The WITH READ ONLY clause explicitly prevents DML against the view, reinforcing that it is intended for query and reporting only. Because the base table is the daily rates conversion type definition table, changes made to conversion types through the standard GL setup forms are immediately visible through the view. The documented ETRM metadata lists no other referenced base objects, so the dependency footprint is limited to a single table.

Key Columns

The view exposes exactly three columns:

  • CONVERSION_TYPE — the internal (system) identifier for the conversion type. This is the value typically stored on foreign currency transactions and rate definitions, and it is the key used in programmatic validation.
  • USER_CONVERSION_TYPE — the user-facing name of the conversion type as presented in the EBS user interface. Reports generally display this value to end users.
  • DESCRIPTION — a free-text description providing additional context about the conversion type, useful for documentation and reporting.

Common Use Cases and Queries

Typical scenarios include populating LOVs in custom reports, validating conversion type values supplied by external interfaces, and joining conversion type descriptions onto transaction or rate extracts. A representative query is:

  • SELECT conversion_type, user_conversion_type, description FROM apps.glbv_gl_conversion_types ORDER BY user_conversion_type;
  • SELECT user_conversion_type FROM apps.glbv_gl_conversion_types WHERE conversion_type = 'Spot';

Because the view is read-only and reflects GL_DAILY_CONVERSION_TYPES directly, it is safe for high-volume reporting and can be referenced in SQL*Plus, BI Publisher, and custom concurrent programs. No maintenance should be performed through it; setup changes must flow through the standard General Ledger conversion type maintenance forms.