Search Results cz_pb_languages




Overview
Explore in AI Chat

Overview

The CZ_PB_LANGUAGES table is a core data object within the Oracle E-Business Suite (EBS) Configurator (CZ) module. Its primary function is to manage the multilingual capabilities of Configurator Publications. A publication is a runtime version of a configuration model deployed for end-user interaction. This table establishes the association between a specific publication and the languages in which its configuration interface and data can be served. By defining this relationship, it enables the Configurator engine to process and respond to configuration requests in a user's preferred language, a critical requirement for global deployments of Oracle EBS versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to enforce a unique language assignment per publication. The documented primary key constraint, CZ_PB_LANGUAGES_PK, is a composite key on two columns: PUBLICATION_ID and LANGUAGE. The PUBLICATION_ID column stores a unique identifier that links directly to a record in the CZ_MODEL_PUBLICATIONS table, which defines the publication itself. The LANGUAGE column stores the code representing a specific language (e.g., 'US' for American English, 'F' for French). Each row in this table signifies that the corresponding publication is enabled and available for configuration sessions in that specified language.

Common Use Cases and Queries

A primary use case is validating or reporting on the language support for deployed publications. System administrators or implementers often query this table to audit multilingual readiness before releasing a configuration model to production. For example, a common query retrieves all languages enabled for a specific publication to ensure all required locales are covered:

  • SELECT LANGUAGE FROM CZ.CZ_PB_LANGUAGES WHERE PUBLICATION_ID = <publication_id> ORDER BY LANGUAGE;

Conversely, to identify which publications support a particular language—useful for troubleshooting or phased rollouts—a join with the publications table is typical:

  • SELECT mp.PUBLICATION_NAME, lng.LANGUAGE FROM CZ.CZ_PB_LANGUAGES lng INNER JOIN CZ.CZ_MODEL_PUBLICATIONS mp ON lng.PUBLICATION_ID = mp.PUBLICATION_ID WHERE lng.LANGUAGE = 'DE' ORDER BY mp.PUBLICATION_NAME;

Related Objects

The CZ_PB_LANGUAGES table has a direct and essential foreign key relationship with the CZ_MODEL_PUBLICATIONS table, which is the master table for publication definitions. The relationship is documented as:

  • Foreign Key from CZ_PB_LANGUAGES to CZ_MODEL_PUBLICATIONS: The PUBLICATION_ID column in CZ_PB_LANGUAGES references the PUBLICATION_ID in CZ_MODEL_PUBLICATIONS. This ensures that a language can only be assigned to an existing, valid publication. Any publication can have multiple language entries in this table, but each language entry must be tied to one publication.

This table is foundational for the Configurator's runtime language resolution and is referenced by internal CZ engine processes when initializing a configuration session based on the user's language context.