Search Results gl_rate_typ




Overview
Explore in AI Chat

Overview

The GL_RATE_TYP table is a reference data table within the Oracle E-Business Suite (EBS) Process Manufacturing Financials (GMF) module. It serves as the master repository for classifying different types of exchange rates used in financial transactions and reporting. Its primary role is to define and maintain valid exchange rate classifications—such as daily, average, or balance sheet rates—which are then referenced by other financial and tax components within the application. This table is fundamental for ensuring consistent and accurate currency conversion across multi-currency operations in a manufacturing environment.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a primary key code that uniquely identifies each rate type. The most critical column is RATE_TYPE_CODE, which serves as the primary key (GL_RATE_TYP_PK). This column stores the short code representing the exchange rate classification, such as 'DAILY', 'AVG', or a similar identifier. While the full column list is not detailed in the excerpt, the description indicates the table's purpose is to classify exchange rate types. It is typical for such a reference table to also include descriptive columns like a name or description for the rate type, and potentially control columns for enabling/disabling codes and tracking creation/modification dates.

Common Use Cases and Queries

This table is primarily used in setups and as a validation source for financial processes involving foreign currency. Common scenarios include configuring tax regimes and defining transaction defaults where a specific exchange rate type is required. A fundamental query to retrieve all active rate types for a setup LOV would be:

  • SELECT rate_type_code, name FROM gl_rate_typ WHERE enabled_flag = 'Y' ORDER BY 1;

For troubleshooting or reporting on where a specific rate type is applied, one might join to related tax tables:

  • SELECT ztb.tax_regime_code, ztb.tax, ztb.exchange_rate_type FROM zx_taxes_b ztb, gl_rate_typ grt WHERE ztb.exchange_rate_type = grt.rate_type_code AND grt.rate_type_code = 'DAILY';

Related Objects

As documented in the foreign key relationships, GL_RATE_TYP is a parent reference table for key objects in the E-Business Tax (eTax) module. The primary related objects are:

  • ZX_REGIMES_B: References GL_RATE_TYP via the column ZX_REGIMES_B.EXCHANGE_RATE_TYPE. This links the rate type to a tax regime.
  • ZX_TAXES_B: References GL_RATE_TYP via the column ZX_TAXES_B.EXCHANGE_RATE_TYPE. This links the rate type to specific tax definitions.

These relationships enforce data integrity, ensuring that the exchange rate types used in tax configuration are valid entries defined in the GL_RATE_TYP table.