Results for “clause_name”

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

Overview

The CZ_ERROR_ATTRIBUTE_VALUES_V view is a reporting and diagnostic object within Oracle EBS, delivered under the BOM – Bills of Material product family (Oracle Configurator / constraint modeling). It exposes attribute-level validation errors that occur when the Configurator engine evaluates constraint clauses against item attribute values. Each row represents a single attribute value that failed a constraint rule, together with the clause that produced the failure and the identity of the affected item and organization.

The view plays a supporting role in troubleshooting and integration monitoring. Rather than presenting configuration results, it presents the reasons a configuration attempt was rejected: which clause failed, which attribute was evaluated, the offending value, and the concurrent request that generated the error. The view text explicitly aliases CCC.NAME to the column CLAUSE_NAME, which is why the search term "clause_name" resolves to this object. Administrators and developers use it to trace model defects, data quality problems, and unexpected rule outcomes back to specific clauses and attribute values.

Note that the ETRM metadata records this view as "Not implemented in this database" for the documented instance. The definition below is therefore reference material: the view may or may not be deployed in a given environment, and its presence typically correlates with active Oracle Configurator usage in BOM.

Underlying Base Objects

The ETRM document does not list formal "referenced base objects," but the view text defines it over a five-way join:

• CZ_ERROR_ATTRIBUTE_VALUES (CAV) — the driving table holding each attribute value error.
• CZ_ERROR_CLAUSES (CEC) — links an error record to the clause evaluation that raised it.
• CZ_CONSTRAINT_CLAUSES (CCC) — supplies the human-readable clause definition, exposed as CLAUSE_NAME.
• AK_ATTRIBUTES_VL (AKA) — the attribute definition, supplying ATTRIBUTE_NAME.
• MTL_SYSTEM_ITEMS_KFV (MSI) — the key-flexfield item view, supplying CONCATENATED_SEGMENTS as ITEM_NAME.

Joins are made on ERROR_CLAUSE_ID, CLAUSE_ID, ATTRIBUTE_CODE, and the composite (INVENTORY_ITEM_ID, ORGANIZATION_ID). Because the item master key flexfield view is used, values are already formatted for display.

Key Columns

• ATTRIBUTE_VALUE_ID / ROW_ID — surrogate and row identifier for the error row.
• ERROR_CLAUSE_ID — foreign key to the clause error record.
• CLAUSE_NAME — name of the constraint clause that failed (from CZ_CONSTRAINT_CLAUSES.NAME).
• ATTRIBUTE_CODE / ATTRIBUTE_NAME — the attribute evaluated and its descriptive name.
• INVENTORY_ITEM_ID / ITEM_NAME — the configured item, with the concatenated segments for readability.
• ORGANIZATION_ID — the inventory organization context of the item.
• ATTRIBUTE_VALUE — the actual value that violated the clause.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context that produced the error.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The most frequent use is post-mortem analysis of failed Configurator runs and data cleanup.

SELECT clause_name, attribute_name, item_name, attribute_value
FROM   cz_error_attribute_values_v
WHERE  request_id = :request_id;

To locate all errors for a specific item or clause:

SELECT clause_name, attribute_code, attribute_value, program_update_date
FROM   cz_error_attribute_values_v
WHERE  inventory_item_id = :item_id
AND    organization_id   = :org_id
ORDER  BY clause_name;

To find the clauses generating the most failures, aggregate by CLAUSE_NAME to identify defective or overly strict constraint rules. Because the view resolves item flexfields and attribute names, it is also a convenient source for integration extracts that feed external validation dashboards. Where the view is not implemented, equivalent logic must be reproduced from the base CZ_* tables directly.