Search Results cz_intl_texts




Overview
Explore in AI Chat

Overview

The CZ_INTL_TEXTS table is a core data object within the CZ (Configurator) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as a master repository for internationalized text identifiers, acting as a central reference point for textual content that can be translated into multiple languages. Its primary role is to enable the multilingual capabilities of the Oracle Configurator by decoupling the unique identifier of a piece of text from its language-specific translations, which are stored in the related CZ_LOCALIZED_TEXTS table. The ETRM documentation explicitly marks this table as "OBSOLETE," indicating its structure and purpose are from a legacy implementation, but it remains a critical component of the data model for existing installations.

Key Information Stored

The table's structure is centered around a primary key that links to numerous other Configurator entities. The most critical column is INTL_TEXT_ID, which serves as the table's primary key (CZ_INTL_TEXTS_PK). This unique numeric identifier does not store the actual text; instead, it represents a specific textual concept or phrase within the Configurator model. Other columns in the table, while not detailed in the provided metadata, would typically include system-level audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track record lifecycle, consistent with Oracle EBS standards.

Common Use Cases and Queries

The primary use case is retrieving the localized text for a given entity in a specific language. A developer or report would join CZ_INTL_TEXTS to a transactional table (like CZ_PS_NODES) and then to CZ_LOCALIZED_TEXTS to get the translated string. For example, to find the caption for a UI node in American English, one might use a query pattern such as:

  • SELECT lt.text FROM cz_ui_nodes un, cz_intl_texts it, cz_localized_texts lt WHERE un.caption_id = it.intl_text_id AND it.intl_text_id = lt.intl_text_id AND lt.language = 'US' AND un.node_id = :p_node_id;

Another common scenario is auditing text usage across the model to understand dependencies before modifying or purging configuration data.

Related Objects

As evidenced by the foreign key relationships, CZ_INTL_TEXTS is a foundational table referenced by many key Configurator entities. Major related objects include: