Search Results cz_model_ref_expls

Overview

The CZ_MODEL_REF_EXPLS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module, specifically for releases 12.1.1 and 12.2.2. It functions as the model-reference explosions table, serving as the structural backbone for managing and storing the hierarchical relationships between configurable components within a model. When a configurator model references another model or sub-model, this table records the explosion of that reference, effectively mapping the parent-child relationships and the specific instances of components as they are expanded during the configuration process. Its primary role is to maintain the integrity and navigability of complex, multi-level product models, enabling the runtime engine to correctly resolve dependencies, apply rules, and validate user selections.

Key Information Stored

The table's structure is centered on defining explosion nodes within a model hierarchy. Its primary key is MODEL_REF_EXPL_ID, which uniquely identifies each explosion record. Critical foreign key columns establish the necessary relational links: MODEL_ID ties the explosion to a specific development project in CZ_DEVL_PROJECTS. COMPONENT_ID and REFERRING_NODE_ID link to specific nodes within the product structure (CZ_PS_NODES), identifying the actual component and the node from which the reference was made. The recursive relationships are managed through PARENT_EXPL_NODE_ID and CHILD_MODEL_EXPL_ID, which both reference the table's own primary key, allowing the table to store multi-level hierarchical explosions where one explosion node can be the parent or child of another.

Common Use Cases and Queries

This table is essential for debugging configuration models, analyzing model structure, and generating reports on component usage. A common scenario involves tracing the complete explosion path for a specific model to understand its composition. A hierarchical query, such as a CONNECT BY or recursive WITH clause in SQL, is frequently used against the PARENT_EXPL_NODE_ID and CHILD_MODEL_EXPL_ID relationships. Another typical query joins CZ_MODEL_REF_EXPLS to CZ_PS_NODES and CZ_DEVL_PROJECTS to list all explosion nodes for a given model name, providing a flat or hierarchical view of all referenced components. Support and development personnel may also query this table to identify orphaned explosion records or to analyze the impact of a component change across multiple model references.

Related Objects

The CZ_MODEL_REF_EXPLS table is a central hub with extensive foreign key relationships, as documented in the ETRM. Key dependencies include:

• CZ_PS_NODES: Joined via COMPONENT_ID and REFERRING_NODE_ID to resolve the actual component and reference point in the product structure.
• CZ_DEVL_PROJECTS: Joined via MODEL_ID to associate explosions with a specific configurator model project.
• CZ_MODEL_REF_EXPLS (Self-Referential): Joined via PARENT_EXPL_NODE_ID and CHILD_MODEL_EXPL_ID to navigate the explosion hierarchy.
• Critical Child Tables: The explosion ID is referenced by numerous functional tables, including CZ_COMBO_FEATURES, CZ_DES_CHART_CELLS, CZ_DES_CHART_COLUMNS, CZ_DES_CHART_FEATURES, CZ_EXPRESSION_NODES, CZ_FUNC_COMP_SPECS, CZ_LCE_HEADERS, CZ_LCE_LOAD_SPECS, and CZ_UI_NODES. This demonstrates its integral role in features, design charts, expressions, functional specs, and user interface definitions.

These relationships underscore the table's critical position in linking the structural model explosion to the functional and UI elements of the Configurator.