Search Results gl_daily_conversion_types_u2

Overview

GL.GL_DAILY_CONVERSION_TYPES is a General Ledger reference table in Oracle E-Business Suite that stores the daily currency conversion rate types available to the applications, together with their user-facing names and descriptions. Each row defines a named rate type such as Spot, Corporate, User, or a user-defined type, and the table backs the Conversion Rate Types form in the GL setup responsibility. The table resides in the APPS_TS_SEED tablespace, confirming its role as seeded setup data referenced pervasively across Oracle Payables, Purchasing, Cash Management, Projects, and General Ledger itself. It is a low-volume, high-reference master data object; the data it holds drives how foreign currency amounts are converted, revalued, translated, and reported throughout the E-Business Suite.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a hub. That classification is a modeling suggestion, consistent with the fact that the table carries a stable business key (the conversion type name) and is referenced by a very large number of downstream tables that record the chosen rate type on transactions and balances. It contains no foreign keys other than the standard Who columns, so it is not a link; it is a narrow, slowly changing reference set rather than a satellite of a parent business entity.

Key Information Stored

The table's principal columns are:

• CONVERSION_TYPE — VARCHAR2(30), the primary key and business key of the table. This is the system-level internal name of the rate type, e.g., Spot, and is the value stored on transactional rows elsewhere in the database.
• USER_CONVERSION_TYPE — VARCHAR2(30), the user-defined display name shown in the Conversion Rate Types form. It is also a unique business-key candidate.
• DESCRIPTION — VARCHAR2(240), a free-text description of the rate type's intended purpose.
• ATTRIBUTE1–ATTRIBUTE15 — VARCHAR2(150) each, the descriptive flexfield segments for this table.
• CONTEXT — the descriptive flexfield context column.
• SECURITY_FLAG, FEM_ENABLED_FLAG, FEM_SCENARIO, FEM_RATE_TYPE_CODE, FEM_TIMEFRAME — Enterprise/Financials features flags and codes used by EBS Financials and related enterprise performance integration.
• ZD_EDITION_NAME — the editioning column introduced for E-Business Suite online patching, present on both unique indexes.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The surrogate PK is GL_DAILY_CONVERSION_TYPES_PK on CONVERSION_TYPE. The documented unique indexes are GL_DAILY_CONVERSION_TYPES_U1 on (CONVERSION_TYPE, ZD_EDITION_NAME) — the index the user searched for — and GL_DAILY_CONVERSION_TYPES_U2 on (USER_CONVERSION_TYPE, ZD_EDITION_NAME). Because the conversion type name is both the primary key and the natural business key in 12.1.1, while 12.2.x adds the editioning column to the key, GL_DAILY_CONVERSION_TYPES_U1 is the unique constraint backing the primary key in an online-patching-enabled environment.

Common Use Cases and Queries

The most frequent operational use is validating or resolving the rate type stored on a transaction. For example, to list all valid rate types with their user names and descriptions:

• SELECT conversion_type, user_conversion_type, description FROM gl_daily_conversion_types ORDER BY user_conversion_type;

To find which rate type an AP invoice uses, and confirm it exists in the reference set, join it back to the hub:

• SELECT ai.invoice_num, ai.exchange_rate_type, gdct.user_conversion_type FROM ap_invoices_all ai JOIN gl_daily_conversion_types gdct ON ai.exchange_rate_type = gdct.conversion_type WHERE ai.invoice_num = :invoice_num;

Implementations commonly use this table to reconcile ledger-level conversion defaults — GL_LEDGERS daily translation, period average, and period end rate types — and to verify Projects billing rate types. A common diagnostic is to identify rate types that exist as a default on a ledger but have no corresponding daily rates entered, by outer-joining to GL_DAILY_RATES. Because the table is seeded and rarely changed, it is also used as the reference list for LOV queries and validating values entered into descriptive flexfields.

Related Objects

The table is referenced by a very large number of EBS objects via the conversion type column. The most significant are:

• GL.GL_DAILY_RATES — joins on CONVERSION_TYPE; holds the actual daily rate values for each rate type, currency pair, and date.
• GL.GL_LEDGERS — references the table through DAILY_TRANSLATION_RATE_TYPE, PERIOD_AVERAGE_RATE_TYPE, and PERIOD_END_RATE_TYPE; drives ledger-level translation defaults.
• GL.GL_JE_HEADERS — stores the chosen CURRENCY_CONVERSION_TYPE on every journal entry header.
• AP.AP_INVOICES_ALL — stores EXCHANGE_RATE_TYPE and PAYMENT_CROSS_RATE_TYPE per invoice.
• AP.AP_SYSTEM_PARAMETERS_ALL — defines the DEFAULT_EXCHANGE_RATE_TYPE for Payables.
• PO.PO_HEADERS_ALL — stores the RATE_TYPE on purchasing documents.
• PO.PO_SYSTEM_PARAMETERS_ALL — defines the DEFAULT_RATE_TYPE for Purchasing.
• GL.GL_CROSS_RATE_RULES — references CONVERSION_TYPE to define cross-rate relationships between rate types.

These relationships, together with tables such as PA_EXPENDITURE_ITEMS_ALL, CE_STATEMENT_LINES, and RCV_TRANSACTIONS, underscore that GL_DAILY_CONVERSION_TYPES functions as a central reference hub whose rows are cited by every module that performs foreign currency conversion.