Search Results zx_rates_tl




Overview
Explore in AI Chat

Overview

The ZX_RATES_TL table is a core component of the E-Business Tax (ZX) module within Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a translation table, providing multilingual support (MLS) for tax rate definitions. Its primary role is to enable the storage and retrieval of language-specific descriptions for tax rates, ensuring that tax-related data can be accurately presented and printed in multiple languages based on user or system settings. This table operates in conjunction with its base table, ZX_RATES_B, which holds the primary transactional and configuration data for tax rates. The existence of ZX_RATES_TL is critical for global implementations of Oracle EBS where legal and reporting requirements mandate the use of local languages.

Key Information Stored

The table stores translated attributes for each tax rate, keyed by the tax rate identifier and language. The primary key is a composite of TAX_RATE_ID and LANGUAGE, ensuring a unique translation entry per language for each rate. While the provided metadata does not list all columns, the structure of a typical translation table in Oracle EBS includes the core translated text column, often named TAX_RATE_NAME or DESCRIPTION. Other standard columns include SOURCE_LANG (to denote the original language of the record), CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for auditing. The TAX_RATE_ID column is the foreign key that links each translation row directly to its corresponding master record in the ZX_RATES_B table.

Common Use Cases and Queries

The primary use case is retrieving a tax rate's description in a user's session language for display on invoices, reports, or within the application UI. A common reporting query involves joining the translation table with its base table to present comprehensive, language-specific tax rate information. For example, to list all active tax rates with their English descriptions, one might use a query pattern such as:

  • SELECT zb.tax_rate_code, ztl.tax_rate_name, zb.rate
  • FROM zx_rates_b zb, zx_rates_tl ztl
  • WHERE zb.tax_rate_id = ztl.tax_rate_id
  • AND ztl.language = USERENV('LANG')
  • AND zb.active_flag = 'Y';

Another critical scenario is during data migration or setup, where implementations must populate this table with translated descriptions for each defined tax rate to support all required languages.

Related Objects

ZX_RATES_TL has a direct and essential relationship with several key E-Business Tax objects. Its primary relationship is defined by a foreign key constraint linking the TAX_RATE_ID column to the ZX_RATES_B table, which is the master table for all tax rate definitions. This table is also referenced by various E-Business Tax views and APIs that surface tax rate information to other EBS modules, such as Oracle Receivables and Payables. While not listed in the metadata, related translation tables like ZX_TAXES_TL (for tax content) and ZX_REGIMES_TL (for tax regimes) follow a similar architectural pattern within the ZX schema. Applications will typically access this data through public APIs or views rather than querying the table directly.