Search Results zx_regimes_tl




Overview
Explore in AI Chat

Overview

The ZX_REGIMES_TL table is a core component of the E-Business Tax (ZX) module within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a translation table, providing multilingual support (MLS) for tax regime definitions. A tax regime is a fundamental construct representing a distinct tax jurisdiction, such as a country's national VAT system or a state's sales tax. This table enables the storage and subsequent printing of user-defined tax regime names and descriptions in multiple languages, which is critical for global enterprises operating in regions with diverse linguistic requirements. Its role is to decouple the language-specific descriptive attributes from the core transactional data, ensuring that tax reporting and documentation can be generated in the appropriate language for legal compliance and business operations.

Key Information Stored

The table stores translated descriptive attributes for each tax regime. Based on its documented primary key structure, the essential columns include TAX_REGIME_ID and LANGUAGE. The TAX_REGIME_ID is a foreign key that references the base tax regime record, typically in a table like ZX_REGIMES_B. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'KO' for Korean) for the translation. While the specific descriptive columns are not detailed in the provided metadata, standard MLS table design in Oracle EBS dictates that this table will contain columns for the translated name (e.g., REGIME_NAME) and description (e.g., DESCRIPTION) of the tax regime. The combination of TAX_REGIME_ID and LANGUAGE forms the unique primary key (ZX_REGIMES_TL_PK), ensuring only one translation exists per regime per language.

Common Use Cases and Queries

The primary use case is retrieving a tax regime's description in a user's session language for display on forms, reports, or tax certificates. A common reporting requirement is to list all defined tax regimes with their translations for a set of languages for audit or setup verification. A typical SQL pattern joins this table to its base data table and uses the NLS session parameters or an explicit language code filter.

  • Sample Query for User Session Language:
    SELECT b.tax_regime_code, tl.regime_name
    FROM zx_regimes_b b, zx_regimes_tl tl
    WHERE b.tax_regime_id = tl.tax_regime_id
    AND tl.language = USERENV('LANG');
  • Sample Query for Setup Verification:
    SELECT b.tax_regime_code, tl.language, tl.regime_name, tl.description
    FROM zx_regimes_b b
    JOIN zx_regimes_tl tl ON b.tax_regime_id = tl.tax_regime_id
    WHERE b.regime_type_flag = 'FEDERAL'
    ORDER BY 1, 2;

Related Objects

ZX_REGIMES_TL has direct relationships with several key E-Business Tax objects. Its most critical relationship is with the base table ZX_REGIMES_B, which holds the non-translatable core attributes of a tax regime (e.g., code, type, effective dates). The TAX_REGIME_ID column in ZX_REGIMES_TL is a foreign key to ZX_REGIMES_B. This table is also referenced by other MLS tables within the ZX schema for related entities, such as ZX_RATES_TL for tax rates and ZX_TAXES_TL for specific taxes within a regime. Application programming interfaces (APIs) in the E-Business Tax engine will automatically query this table to resolve descriptive text based on the user's language context when processing or reporting on tax data.