Search Results gl_daily_conversion_types

Overview

The GL_DAILY_CONVERSION_TYPES table is a core reference table within the Oracle E-Business Suite General Ledger (GL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for defining and storing valid foreign currency daily conversion rate types. These rate types are critical for the system's multi-currency processing capabilities, governing how monetary amounts are converted from a transaction currency into a functional, reporting, or other destination currency. The table's primary role is to maintain a controlled list of conversion types, such as 'Corporate', 'Spot', or 'User', which are then referenced by transactional tables across various EBS modules whenever a currency conversion is required. Its integrity is enforced by the primary key constraint GL_DAILY_CONVERSION_TYPES_PK.

Key Information Stored

The table's structure is relatively simple, focusing on the definition of the conversion type itself. The most critical column is CONVERSION_TYPE, which is the primary key. This column stores the unique alphanumeric code identifying the rate type (e.g., 'Corporate'). While the provided metadata excerpt does not list all columns, based on standard EBS design, the table typically includes descriptive columns like DESCRIPTION to provide a meaningful name for the conversion type, and potentially columns for enabling or disabling the type. The data in this table is typically seeded during installation and can be extended by the implementation team to include custom rate types as needed for specific business requirements.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and setup purposes. A common operational use case is validating the exchange rate type entered on an invoice or journal before it is posted. For reporting, analysts may query this table to decode the CONVERSION_TYPE codes found in transactional data into human-readable descriptions. Administrators query it to review available rate types during system configuration. A fundamental query retrieves all active conversion types: SELECT conversion_type, description FROM gl_daily_conversion_types ORDER BY conversion_type;. Another typical pattern is a join to transactional data, such as identifying all invoices using a specific rate type: SELECT aia.invoice_num, aia.exchange_rate_type FROM ap_invoices_all aia WHERE aia.exchange_rate_type = '&RATE_TYPE';.

Related Objects

The GL_DAILY_CONVERSION_TYPES table is a central reference point for currency conversion across the EBS suite, as evidenced by its extensive foreign key relationships. Key related transactional tables that enforce referential integrity to its CONVERSION_TYPE column include:

• AP_INVOICES_ALL (EXCHANGE_RATE_TYPE, PAYMENT_CROSS_RATE_TYPE)
• AP_INVOICE_DISTRIBUTIONS_ALL (EXCHANGE_RATE_TYPE)
• AP_CHECKS_ALL (EXCHANGE_RATE_TYPE, CLEARED_EXCHANGE_RATE_TYPE, MATURITY_EXCHANGE_RATE_TYPE)
• AP_EXPENSE_REPORT_HEADERS_ALL (DEFAULT_EXCHANGE_RATE_TYPE)
• AP_AE_LINES_ALL (CURRENCY_CONVERSION_TYPE)
• CE_STATEMENT_LINES (EXCHANGE_RATE_TYPE)
• GCS_CURR_TREATMENTS_B (ENDING_RATE_TYPE)
• AP_SYSTEM_PARAMETERS_ALL (DEFAULT_EXCHANGE_RATE_TYPE)

These relationships ensure that any conversion rate type used in a payable, payment, cash management, or consolidation transaction is a valid type defined in the GL_DAILY_CONVERSION_TYPES master table.