Search Results zx_parameters_tl




Overview
Explore in AI Chat

Overview

ZX_PARAMETERS_TL is the multilingual translation (MLS) table for tax parameters in Oracle E-Business Tax (ZX). It stores the language-specific descriptive text associated with each tax parameter defined in the base table ZX_PARAMETERS_B. Because configuration names such as tax parameter names must be presented to users in their chosen session language, EBS separates language-neutral attribute rows (the "_B" table) from translated rows (the "_TL" table). Each row in ZX_PARAMETERS_TL represents one tax parameter code in one installed language.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries the TAX_PARAMETER_CODE foreign key that points to ZX_PARAMETERS_B, meaning it extends the descriptive context of a parent business entity rather than acting as an independent hub or an associative link between two hubs. It is best understood as a language-dependent descriptor satellite attached to the tax parameter business key.

Key Information Stored

The table contains ten documented columns. The most significant are:

  • TAX_PARAMETER_CODE — the business identifier of the parent tax parameter; part of the primary key and the foreign key to ZX_PARAMETERS_B.
  • LANGUAGE — the installed language code for the translated row; the second component of the primary key.
  • SOURCE_LANG — the language of the source (usually US) from which the translation was derived.
  • TAX_PARAMETER_NAME — the translated, user-facing name of the tax parameter, and the principal payload of this table.
  • ZD_EDITION_NAME — the edition identifier supporting Oracle's edition-based redefinition (EBR); present in the unique index and the primary key definition.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS auditing columns recording who created and last modified each translated row and when.

The surrogate primary key is ZX_PARAMETERS_TL_PK, defined on (TAX_PARAMETER_CODE, LANGUAGE), with ZD_EDITION_NAME participating in the EBR uniqueness constraint. The unique index ZX_PARAMETERS_TL_U1 on (TAX_PARAMETER_CODE, LANGUAGE, ZD_EDITION_NAME) represents the business-key candidate that enforces one translated name per parameter per language per edition.

Common Use Cases and Queries

The most frequent use is resolving a tax parameter code into a displayable name in the user's language, and reporting on tax configuration in multilingual implementations. A typical join retrieves the translated name alongside base attributes:

  • SELECT b.tax_parameter_code, t.tax_parameter_name FROM zx_parameters_b b, zx_parameters_tl t WHERE b.tax_parameter_code = t.tax_parameter_code AND t.language = USERENV('LANG');
  • Reporting the set of tax parameters with their translated names to audit configuration completeness.
  • Verifying translation coverage by comparing rows in ZX_PARAMETERS_B against ZX_PARAMETERS_TL for a target LANGUAGE.
  • Diagnosing duplicate or missing translations when tax setup appears in a non-base language.

Because the table is MLS, queries should always constrain LANGUAGE to avoid returning every translation, and should be aware of ZD_EDITION_NAME in EBR-enabled environments.

Related Objects

The principal related objects follow directly from the documented relationships:

  • ZX_PARAMETERS_B — the base (language-neutral) table; joined on TAX_PARAMETER_CODE via the documented foreign key.
  • ZX_PARAMETERS_TL_PK — the primary key constraint on (TAX_PARAMETER_CODE, LANGUAGE).
  • ZX_PARAMETERS_TL_U1 — the unique business-key index on (TAX_PARAMETER_CODE, LANGUAGE, ZD_EDITION_NAME).
  • ZX_PARAMETERS_VL — the MLS view that unions the base and translated tables for convenient access.
  • TAX_PARAMETERS (ZX_TAX_PARAMETERS) — related E-Business Tax setup entities that consume parameter codes.

These objects collectively support the storage, translation, and presentation of tax parameter definitions within the E-Business Tax module.