Search Results zx_condition_groups_tl




Overview
Explore in AI Chat

Overview

ZX_CONDITION_GROUPS_TL is the multilingual support (MLS) translation table for tax condition groups in Oracle E-Business Tax (product ZX). A condition group is a reusable set of conditions that determines when a tax rule, tax status, or tax rate applies during tax determination. The base definition of each condition group resides in ZX_CONDITION_GROUPS_B, while ZX_CONDITION_GROUPS_TL stores the language-specific name and description that users see and that the application prints on tax documents. The table resides in the ZX schema and is classified as VALID in the ETRM 12.1.1 and 12.2.2 object registry.

Its role is strictly translational and descriptive: it carries no tax logic, only the human-readable text associated with a condition group in each installed language. In Data Vault modeling terms, the metadata classifies this object heuristically as standalone; a reasonable modeling suggestion would treat it as a satellite hanging off the condition group hub, keyed by the group identifier plus language, rather than as a hub or link in its own right.

Key Information Stored

The physical schema documents ten columns. The most significant are:

  • CONDITION_GROUP_ID — Identifier of the parent condition group; inherited from the base table and part of the composite primary key.
  • LANGUAGE — The installed language code for the translated row; the second component of the primary key.
  • CONDITION_GROUP_NAME — The displayed name of the condition group in the given language.
  • CONDITION_GROUP_DESC — The long description of the condition group in the given language.
  • SOURCE_LANG — The language in which the base record was originally created; used by the MLS framework to determine whether a translation is current or requires regeneration.
  • CREATION_DATE, LAST_UPDATE_DATE — Standard audit timestamps for the translation row.
  • CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns identifying the user and login responsible for the row.

The surrogate primary key is ZX_CONDITION_GROUPS_TL_PK, defined on (CONDITION_GROUP_ID, LANGUAGE). A unique index, ZX_CONDITION_GROUPS_TL_U2, is documented on the same pair, confirming that CONDITION_GROUP_ID plus LANGUAGE is the business-key candidate and that at most one translation exists per group per language.

Common Use Cases and Queries

Functional and technical users query this table to resolve the localized name of a condition group when building tax reporting extracts, validating configuration, or debugging tax determination. A typical join resolves the current session language against the translation table:

  • Reporting the condition group name in the user's language: SELECT t.condition_group_name, t.condition_group_desc FROM zx_condition_groups_tl t WHERE t.condition_group_id = :group_id AND t.language = USERENV('LANG').
  • Auditing all translations defined for a group: SELECT language, condition_group_name, source_lang FROM zx_condition_groups_tl WHERE condition_group_id = :group_id.
  • Identifying untranslated or stale rows by comparing SOURCE_LANG with the target LANGUAGE, useful during multilingual implementations.
  • Joining to ZX_CONDITION_GROUPS_B on CONDITION_GROUP_ID to combine rule logic with the display text in custom tax exception reports.

Because the table is purely descriptive, it should not be used to drive tax calculation logic; tax determination always operates on the base table.

Related Objects

  • ZX_CONDITION_GROUPS_B — Base table holding the actual condition group definition; joined on CONDITION_GROUP_ID and the parent of this translation row.
  • ZX_CONDITION_GROUPS_VL — The MLS view that unions the base and translation tables and is the preferred query interface for localized names.
  • ZX_CONDITIONS_B — Base table of the individual conditions that belong to a condition group, linked through the group identifier.
  • ZX_CONDITIONS_TL — Parallel translation table for those individual conditions.
  • ZX_RULES_B / ZX_RULES_TL — Tax rules that reference condition groups during tax determination, with the corresponding translation table following the same MLS pattern.
  • ZX_TAX_STATUS_B and related ZX tax regime/status objects — configuration entities that consume condition groups in rule evaluation.

In practice, ZX_CONDITION_GROUPS_VL should be preferred over direct access to this table, since it automatically filters by the appropriate language and preserves the documented key semantics.