Search Results cz_lookup_values_tl




Overview
Explore in AI Chat

Overview

CZ_LOOKUP_VALUES_TL is a translation table in the CZ (Configurator) schema of Oracle E-Business Suite, holding language-specific labels, descriptions, and notes for lookup values used throughout the Configurator module. In Oracle EBS, Configurator relies heavily on lookup lists to drive selection, validation, and presentation logic within configurable models and user interfaces. While the base definition of a lookup resides in CZ_LOOKUP_VALUES, the _TL suffix identifies this companion table as a translated entity, storing one row per lookup value per installed language. This design conforms to the standard EBS multilingual pattern in which a base table holds language-independent attributes and a _TL table holds translatable text keyed by LANGUAGE.

The object is owned by the CZ schema, is marked VALID, and is documented with 17 physical columns. From a heuristic Data Vault classification standpoint, ETRM metadata suggests this table behaves as a standalone object, neither functioning as a pure hub, link, nor satellite of another mined FK structure. This classification should be treated as a modeling suggestion rather than an enforced rule, since the table participates logically in the Configurator lookup domain without mined foreign-key dependencies within the data vault heuristic.

Key Information Stored

The three columns that form the primary key, CZ_LOOKUP_VALUES_TL_PK, are LIST_NAME, DATA_VALUE, and LANGUAGE. Together these uniquely identify a translated lookup entry: the lookup list to which the value belongs, the internal data value, and the language of the translation. A secondary unique index, CZ_LOOKUP_VALUES_TL_U1, extends the business key across LIST_NAME, DATA_VALUE, LANGUAGE, DELETED_FLAG, NUMERIC_ID_VALUE, and ZD_EDITION_NAME, supporting edition-aware and soft-delete-aware uniqueness.

  • LIST_NAME — identifier of the lookup list (for example, a Configurator-defined validation list).
  • DATA_VALUE — the internal coded value that applications store and evaluate.
  • LANGUAGE — the installed language code for the translation.
  • VALUE_LABEL — the translated display label presented to users.
  • VALUE_DESCRIPTION — the translated description text for the value.
  • VALUE_NOTES — supplementary translated notes or instructions.
  • NULL_VALUE_FLAG — indicates whether the value represents a null or blank option.
  • SOURCE_LANG — the source language from which the translation was derived.
  • DELETED_FLAG — soft-delete indicator for the translated row.
  • NUMERIC_ID_VALUE — numeric identifier associated with the data value, used in uniqueness checks.
  • SEEDED_FLAG — identifies Oracle-seeded versus customer-defined entries.
  • ZD_EDITION_NAME — edition name supporting EBS Edition-Based Redefinition in 12.2.x.
  • CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and last modified each translation.

Common Use Cases and Queries

The table is most commonly queried to resolve a display label for a known lookup value in a specific language, or to audit translation completeness across installed languages. A typical retrieval pattern joins on the composite key:

SELECT value_label, value_description FROM cz_lookup_values_tl WHERE list_name = :list AND data_value = :value AND language = USERENV('LANG');

Reporting scenarios include identifying lookup values missing a translation for a given language, comparing translations against the base CZ_LOOKUP_VALUES row, and extracting seeded versus customer-defined translated labels. Edition-aware environments should filter on ZD_EDITION_NAME and exclude rows where DELETED_FLAG is set. Multilingual validation queries commonly group by LIST_NAME and LANGUAGE to measure translation coverage.

Related Objects

  • CZ_LOOKUP_VALUES — the base (non-translated) lookup values table; joined on LIST_NAME and DATA_VALUE.
  • CZ_LOOKUP_VALUES_TL_PK — primary key constraint enforcing LIST_NAME, DATA_VALUE, LANGUAGE uniqueness.
  • CZ_LOOKUP_VALUES_TL_U1 — composite unique business-key index including DELETED_FLAG, NUMERIC_ID_VALUE, and ZD_EDITION_NAME.
  • FND_LANGUAGES — supplies valid LANGUAGE codes and installed language metadata.
  • CZ_LOOKUPS / CZ_LOOKUP_TYPES — define the lookup lists referenced by LIST_NAME in Configurator.
  • FND_LOOKUP_VALUES_TL — the analogous translation table for the common FND lookup framework, useful for pattern comparison.