Results for “cz_model_ref_expls”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_MODEL_REF_EXPLS is the model-reference explosion table within the Oracle E-Business Suite Configurator (CZ) module. It stores the fully exploded representation of a configured model, recording every configuration node generated when a model is expanded against a set of user selections. Each row corresponds to one node in a model-reference explosion tree, capturing the component used at that node, its position in the hierarchy, its depth, and its relationship to parent, child, and referring nodes. The table therefore acts as the persistent record of what a given configuration actually resolved to, rather than the definition of the model itself.

Under the heuristic Data Vault classification derived from its foreign-key structure, CZ_MODEL_REF_EXPLS is hub-leaning. It carries a single-column surrogate primary key and is referenced by numerous dependent tables, suggesting it should be modeled as a central hub entity, with the surrounding CZ_* detail tables treated as satellites or links attached to it. This classification is a modeling suggestion based on FK topology and should be validated against actual usage.

Key Information Stored

The table is documented with seventeen columns in ETRM 12.2.2. The most significant are:

• MODEL_REF_EXPL_ID — the surrogate primary key, defined by unique index CZ_MODEL_REF_EXPLS_PK. This is the only documented business-key candidate.
• MODEL_ID — foreign key to CZ_DEVL_PROJECTS, identifying the model or development project that produced the explosion.
• COMPONENT_ID — foreign key to CZ_PS_NODES, the component instantiated at this exploded node.
• REFERRING_NODE_ID — foreign key to CZ_PS_NODES, the node that referred to this component.
• PARENT_EXPL_NODE_ID — self-referencing foreign key identifying the parent node in the explosion tree.
• CHILD_MODEL_EXPL_ID — self-referencing foreign key pointing to a child model explosion, supporting nested or reused model expansions.
• PS_NODE_TYPE and EXPL_NODE_TYPE — classify the nature of the exploded node.
• NODE_DEPTH — the level of the node within the explosion hierarchy, useful for ordered traversal.
• VIRTUAL_FLAG — indicates whether the node is virtual, i.e. present for structural reasons without a concrete component.
• DELETED_FLAG — soft-delete indicator for obsolete explosion rows.
• HAS_TRACKABLE_CHILDREN — flags whether subordinate nodes require change tracking.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS auditing columns.

Common Use Cases and Queries

Typical scenarios include reporting the resolved configuration for a given model, tracing why a specific component appeared in an order, and reconciling Configurator output with downstream order or BOM data. A common pattern joins the explosion back to its model and component nodes:

• SELECT e.MODEL_REF_EXPL_ID, e.MODEL_ID, e.COMPONENT_ID, e.NODE_DEPTH FROM CZ_MODEL_REF_EXPLS e WHERE e.MODEL_ID = :model_id AND NVL(e.DELETED_FLAG,'N') = 'N' ORDER BY e.NODE_DEPTH;
• Hierarchical traversal of the explosion tree using CONNECT BY PRIOR MODEL_REF_EXPL_ID = PARENT_EXPL_NODE_ID START WITH PARENT_EXPL_NODE_ID IS NULL.
• Joining to CZ_COMBO_FEATURES and CZ_DES_CHART_FEATURES on MODEL_REF_EXPL_ID to report which features and combinations were selected at each exploded node.
• Filtering on VIRTUAL_FLAG to exclude structural placeholder nodes from component-count reporting.

Related Objects

CZ_MODEL_REF_EXPLS is tightly coupled to the following documented objects through foreign keys:

• CZ_PS_NODES — referenced via COMPONENT_ID and REFERRING_NODE_ID; the source of component definitions.
• CZ_DEVL_PROJECTS — referenced via MODEL_ID; the model definition driving the explosion.
• CZ_MODEL_REF_EXPLS — self-referencing via PARENT_EXPL_NODE_ID and CHILD_MODEL_EXPL_ID for tree structure.
• CZ_COMBO_FEATURES — references MODEL_REF_EXPL_ID; stores feature combinations at a node.
• CZ_DES_CHART_FEATURES, CZ_DES_CHART_COLUMNS, CZ_DES_CHART_CELLS — reference MODEL_REF_EXPL_ID (and SECONDARY_FEAT_EXPL_ID) for design chart data.
• CZ_EXPRESSION_NODES and CZ_FUNC_COMP_SPECS — reference MODEL_REF_EXPL_ID for expression and functional component specifications.
• CZ_LCE_HEADERS and CZ_LCE_LOAD_SPECS — reference MODEL_REF_EXPL_ID, ATTACHMENT_EXPL_ID, and REQUIRED_EXPL_ID for lead-time and load specifications.
• CZ_UI_NODES — references MODEL_REF_EXPL_ID for user-interface node rendering.