Results for “expr_subtype”

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

Overview

CZ_EXPRESSION_NODES is a core Configurator (CZ) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the contents of expressions in a tree or sequential "un-parsed" node order. In the Oracle Configurator model, expressions describe rules, constraints, and computed logic that drive configuration validity, defaults, and pricing behavior. Rather than persisting a single flat string, CZ_EXPRESSION_NODES decomposes each expression into discrete nodes, preserving parent-child hierarchy through the self-referencing EXPR_PARENT_ID column. This node-based representation allows the Configurator runtime engine to traverse, evaluate, and re-compile expressions efficiently against model structure, user selections, and property values.

The table resides in the CZ schema and is documented as VALID with 48 columns. From a Data Vault modeling perspective, the FK topology suggests a satellite-leaning classification. The table carries a surrogate primary key (EXPR_NODE_ID) plus descriptive attributes (EXPR_TYPE, DATA_VALUE, DATA_TYPE, and so on), which is characteristic of a satellite attached to a parent expression hub (CZ_EXPRESSIONS). The self-referencing parent link and the multiple foreign keys to dimension-like tables further reinforce this satellite-leaning characterization, though the hierarchical self-reference introduces link-like behavior.

Key Information Stored

The surrogate primary key is EXPR_NODE_ID, enforced by CZ_EXPRESSION_NODES_PK. Two unique indexes represent business-key candidates: CZ_EXPRESSION_NODES_PK (EXPR_NODE_ID, ZD_EDITION_NAME) and CZ_EXPRESSION_NODES_U2 (EXPR_PARENT_ID, EXPR_NODE_ID, ZD_EDITION_NAME). The presence of ZD_EDITION_NAME in both reflects the multi-edition (ZD) architecture used in 12.2.x for edition-based redefinition support.

• EXPRESS_ID — foreign key to CZ_EXPRESSIONS, identifying the parent expression to which the node belongs; this is the primary grouping key for all nodes in a single expression.
• EXPR_PARENT_ID — self-referencing foreign key to CZ_EXPRESSION_NODES, defining the tree hierarchy among nodes.
• EXPR_NODE_ID — surrogate primary key uniquely identifying each node.
• SEQ_NBR and TOKEN_LIST_SEQ — control sequential ordering of un-parsed nodes within an expression.
• EXPR_TYPE and EXPR_SUBTYPE — classify the node's semantic role (operator, operand, function, literal, and so on).
• DATA_VALUE, DATA_NUM_VALUE, and DATA_TYPE — the literal or numeric value carried by a leaf node, with an accompanying type indicator.
• FIELD_NAME and PROPERTY_ID — bind the node to a specific property or field in the model.
• ITEM_ID, ITEM_TYPE_ID, PS_NODE_ID, GRID_COL_ID, and FILTER_SET_ID — contextual references tying the node to items, model nodes, grid columns, and filter sets.
• RULE_ID and MODEL_REF_EXPL_ID — associate the node with rules and model reference explanations.
• ARGUMENT_INDEX, PARAM_INDEX, ARGUMENT_NAME, and ARGUMENT_SIGNATURE_ID — support function-argument and parameter binding.
• COMPILE_ADVICE, CONSEQUENT_FLAG, COLLECTION_FLAG, MUTABLE_FLAG, and DISPLAY_NODE_DEPTH — runtime and compilation hints.
• DELETED_FLAG, EFF_FROM, EFF_TO, CHECKOUT_USER, and SEEDED_FLAG — standard lifecycle, effectivity, and development-status columns.

Common Use Cases and Queries

Typical use cases include diagnosing why a configuration rule fails to fire, exporting expression trees for external analysis, and auditing rule logic across model editions.

• Retrieve all nodes for a given expression in hierarchical order:

  SELECT EXPR_NODE_ID, EXPR_PARENT_ID, EXPR_TYPE, DATA_VALUE FROM CZ_EXPRESSION_NODES WHERE EXPRESS_ID = :express_id ORDER BY SEQ_NBR;

• Locate properties referenced by a specific rule:

  SELECT e.EXPR_NODE_ID, e.PROPERTY_ID, e.FIELD_NAME FROM CZ_EXPRESSION_NODES e WHERE e.RULE_ID = :rule_id AND e.DELETED_FLAG = 'N';

• Identify orphaned or deeply nested nodes using a recursive WITH clause on EXPR_PARENT_ID to reconstruct the tree.
• Reconcile node counts against CZ_EXPRESSIONS to detect incomplete compilation or partially saved expressions during configuration model deployment.

Related Objects

The following objects participate directly in FK relationships with CZ_EXPRESSION_NODES:

• CZ_EXPRESSIONS — parent of every node, joined on CZ_EXPRESSION_NODES.EXPRESS_ID = CZ_EXPRESSIONS.EXPRESS_ID.
• CZ_EXPRESSION_NODES (self-join) — joined on EXPR_PARENT_ID = EXPR_NODE_ID to traverse the node tree.
• CZ_RULES — joined on RULE_ID; links nodes to the rule definitions they implement.
• CZ_PROPERTIES — joined on PROPERTY_ID; identifies the model property referenced by a node.
• CZ_PS_NODES — joined on PS_NODE_ID; ties nodes to model structure nodes.
• CZ_GRID_COLS — joined on GRID_COL_ID; binds nodes to grid column definitions.
• CZ_ITEM_MASTERS and CZ_ITEM_TYPES — joined on ITEM_ID and ITEM_TYPE_ID respectively.
• CZ_FILTER_SETS — joined on FILTER_SET_ID; constrains node applicability.
• CZ_MODEL_REF_EXPLS — joined on MODEL_REF_EXPL_ID; relates nodes to model reference expressions.