Search Results cz_explnodes_values_eff_cv




Overview
Explore in AI Chat

Overview

The CZ_EXPLNODES_VALUES_EFF_CV view is a Configurator (CZ) module database object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name denotes its function concisely: it is a "covered" (_CV) variant of the explanation-nodes view (EXPLNODES) that joins effective/valid node value data (VALUES_EFF). In the Configurator data model, "explosion nodes" represent the individual elements of a configured model — features, option classes, and their associated properties — that are exploded at runtime when a configuration is generated. The "effective" designation indicates the view surfaces only rows that satisfy the effectivity constraints defined on those nodes.

Because it is a view rather than a stored table, CZ_EXPLNODES_VALUES_EFF_CV does not persist data. It presents a read-only, denormalized projection that reporting tools, extensions, and integration interfaces can query to obtain the current, effective value set for configuration nodes. This makes it valuable for reconciliation reports, downstream data extraction to order-management or manufacturing systems, and for diagnostics when custom code must interrogate a configured model without navigating the multi-table Configurator schema directly.

Underlying Base Objects

The view is defined over several documented Configurator objects, listed by ETRM 12.2.2 as: CZ_DEVELOPER_UTILS_PVT (package), CZ_EXPLNODES_IMAGE_EFF_V (view), CZ_PSNODE_PROPVAL_V (view), CZ_SIGNATURES (synonym), CZ_SYSTEM_PROPERTIES_V (view), CZ_TYPES (package), CZ_TYPE_RELATIONSHIPS (synonym), CZ_UTILS (package), and DUAL (synonym).

The primary workhorse is CZ_EXPLNODES_IMAGE_EFF_V, which supplies node attributes such as names, parent identifiers, feature types, minimum and maximum constraints, and effectivity information. CZ_PSNODE_PROPVAL_V contributes property-value data for the nodes, while CZ_SYSTEM_PROPERTIES_V provides system-level properties. CZ_TYPE_RELATIONSHIPS establishes the type-level connections used to determine which values are valid for which nodes, and CZ_SIGNATURES identifies the signature types referenced in those relationships. Package references to CZ_DEVELOPER_UTILS_PVT, CZ_TYPES, and CZ_UTILS indicate that the view embeds PL/SQL logic for value computation, particularly a scalar subquery that computes a "no value" indicator using EXISTS and UNION ALL branches against the type-relationship tables.

Key Columns

The view exposes the full column set of the underlying explanation-node view, including:

The presence of PSN_CREATION_DATE and PSN_LAST_UPDATE_DATE supports audit and change-tracking queries.

Common Use Cases and Queries

Typical uses include verifying which nodes are effective for a given model on a given date, exporting node value definitions to external configuration engines, and troubleshooting discrepancies between configured output and expected option values.

A simple retrieval of effective nodes for a model:

  • SELECT PS_NODE_ID, NAME, FEATURE_TYPE, INITIAL_VALUE, MINIMUM, MAXIMUM FROM CZ_EXPLNODES_VALUES_EFF_CV WHERE MODEL_ID = :p_model_id AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_UNTIL, SYSDATE + 1);

Identifying nodes that carry no usable value, useful for data cleanup:

  • SELECT PS_NODE_ID, NAME, NO_VALUE FROM CZ_EXPLNODES_VALUES_EFF_CV WHERE NO_VALUE = 1;

Drilling into a subtree by parent linkage:

  • SELECT PS_NODE_ID, PARENT_ID, NODE_DEPTH, NAME FROM CZ_EXPLNODES_VALUES_EFF_CV WHERE PARENT_ID = :p_parent_id ORDER BY TREE_SEQ;

Because the view performs significant internal joins and a subquery invoking utility logic, queries should always filter on indexed columns such as MODEL_ID, PS_NODE_ID, or PARENT_ID rather than scanning the full result set, particularly in high-volume reporting environments in both 12.1.1 and 12.2.2.