Search Results cz_lce_clobs




Overview
Explore in AI Chat

Overview

The CZ_LCE_CLOBS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module. Its primary function is to store the complete Logical Configuration Entity (LCE) data for a configurable component in a highly consolidated format. An LCE represents a self-contained, executable model of a configurable item, encompassing its rules, properties, and structure. By packaging the entire LCE into a single row using a Character Large Object (CLOB) column, this table enables efficient storage, retrieval, and management of complex configuration models. It plays a critical role in the runtime performance of the Oracle Configurator, allowing the system to quickly load and process the necessary logic for interactive configuration sessions.

Key Information Stored

The table's structure is designed to link a large CLOB payload to a specific configuration header. The most critical columns include:

  • LCE_HEADER_ID: This is the primary key column and serves as the foreign key linking to the CZ_LCE_HEADERS table. It uniquely identifies the specific LCE header record to which the packaged CLOB data belongs.
  • A CLOB column: While the provided metadata does not explicitly name the CLOB column, its purpose is clearly defined. This column holds the serialized or packaged data that constitutes the entire Logical Configuration Entity. This data is typically in a proprietary, structured format that the Configurator engine can efficiently parse and execute.

Common Use Cases and Queries

Direct manipulation of this table is typically performed by the Configurator engine itself during model publication and runtime. However, technical consultants may query it for diagnostics, data validation, or impact analysis. A common scenario involves tracing the stored LCE data back to its source model header. For example, to verify the existence of packaged LCE data for a specific component, one might execute a join using the documented foreign key relationship:

SELECT cl.lce_header_id, h.name, DBMS_LOB.GETLENGTH(cl.<clob_column>) AS clob_size
FROM cz.cz_lce_clobs cl, cz.cz_lce_headers h
WHERE cl.lce_header_id = h.lce_header_id
AND h.name = '<Component_Name>';

Another use case is investigating performance or corruption issues by checking for unusually large or empty CLOB entries associated with recently published models.

Related Objects

The CZ_LCE_CLOBS table has a direct and essential relationship with the CZ_LCE_HEADERS table, as documented in the provided metadata.

  • CZ_LCE_HEADERS: This is the primary parent table. The relationship is enforced by a foreign key where CZ_LCE_CLOBS.LCE_HEADER_ID references CZ_LCE_HEADERS.LCE_HEADER_ID. The CZ_LCE_HEADERS table contains metadata about the LCE, such as its name, version, and status, while CZ_LCE_CLOBS stores the actual executable payload. Any query to retrieve meaningful information from CZ_LCE_CLOBS will almost invariably require a join to CZ_LCE_HEADERS.
  • Table: CZ_LCE_CLOBS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_LCE_CLOBS,  object_name:CZ_LCE_CLOBS,  status:VALID,  product: CZ - Configurator ,  description: Packages entire LCE for a component into a single row using a CLOB to hold the data ,  implementation_dba_data: CZ.CZ_LCE_CLOBS , 

  • Table: CZ_LCE_CLOBS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_LCE_CLOBS,  object_name:CZ_LCE_CLOBS,  status:VALID,  product: CZ - Configurator ,  description: Packages entire LCE for a component into a single row using a CLOB to hold the data ,  implementation_dba_data: CZ.CZ_LCE_CLOBS , 

  • Table: CZ_LCE_HEADERS 12.2.2

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_LCE_HEADERS,  object_name:CZ_LCE_HEADERS,  status:VALID,  product: CZ - Configurator ,  description: Compiled logic record headers ,  implementation_dba_data: CZ.CZ_LCE_HEADERS , 

  • Table: CZ_LCE_HEADERS 12.1.1

    owner:CZ,  object_type:TABLE,  fnd_design_data:CZ.CZ_LCE_HEADERS,  object_name:CZ_LCE_HEADERS,  status:VALID,  product: CZ - Configurator ,  description: Compiled logic record headers ,  implementation_dba_data: CZ.CZ_LCE_HEADERS ,