Search Results cz_pb_languages_pk




Overview
Explore in AI Chat

Overview

The CZ.CZ_PB_LANGUAGES table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Configurator (CZ) module. It serves a critical role in enabling the multi-language functionality of Configurator publications. This table establishes the relationship between a publication and the languages in which it is available, ensuring that configuration requests and user interfaces can be served in a specified, localized language. By defining this assignment, it supports the global deployment of the product configurator, a key component of the Oracle Advanced Pricing and Order Management ecosystems.

Key Information Stored

The table is intentionally simple, consisting of only two mandatory columns that together form a unique record. The PUBLICATION_ID column is a NUMBER datatype that identifies the specific publication (a packaged, deployable configurator model) to which a language is being assigned. The LANGUAGE column is a VARCHAR2 datatype that stores the code for the language being assigned, such as 'US' for American English or 'DE' for German. The combination of these two columns is enforced as the primary key (CZ_PB_LANGUAGES_PK), ensuring that no language can be duplicated for a given publication. The table is stored in the APPS_TS_SEED tablespace, indicating its nature as reference data seeded during installation.

Common Use Cases and Queries

The primary use case is the administration and validation of language support for configurator publications. A common operational query is to list all languages enabled for a specific publication, which is essential for setup and troubleshooting. For example: SELECT LANGUAGE FROM cz.cz_pb_languages WHERE publication_id = :p_pub_id;. Conversely, to find all publications that support a particular language, one would execute: SELECT PUBLICATION_ID FROM cz.cz_pb_languages WHERE language = :p_language;. This table is also central to the runtime process; when a user initiates a configuration session, the application references this table to validate and apply the requested or default language for the interface elements and messages derived from the publication.

Related Objects

The CZ_PB_LANGUAGES table has a direct and essential relationship with the publication master table. As documented in the provided relationship data, the PUBLICATION_ID column is a foreign key referencing the CZ_MODEL_PUBLICATIONS table. This enforces referential integrity, ensuring that a language can only be assigned to a valid, existing publication. The table is referenced by the APPS synonym CZ_PB_LANGUAGES, which is the standard access point for all application code and queries within the EBS environment. There are no other documented foreign key relationships from this table, underscoring its focused purpose of managing the many-to-many relationship between publications and languages.