Search Results autoselection_count

Overview

The CZ_ERRORS_SUMMARY_V view belongs to the Oracle EBS Bills of Material (BOM) product family and serves as a consolidated error and warning summary for configuration-related transactions processed through Oracle Configurator (CZ) and Oracle Order Management. In Oracle EBS 12.1.1 and 12.2.2 environments, the view aggregates diagnostic counts — messages, errors, suggestions, warnings, autoselections, and overridden errors — that arise when a configured model is validated against a sales order line or shipment line.

The view is central to the Configure-to-Order (CTO) validation cycle. When a user configures a model during order entry, Oracle Configurator writes records to the CZ_ERRORS table. The view summarizes those records and joins them to system definitions, order headers, order types, and inventory items, allowing developers and support analysts to present a readable diagnostic dashboard. The SYSTEM_NAME column — the term the searching user queried — exposes CS_SYSTEMS.NAME, the descriptive name of the configuration system that generated the error records.

Underlying Base Objects

The view's SELECT statement references the following base objects:

• CZ_ERRORS — the primary transactional table holding configuration error, message, and suggestion records keyed by SYSTEM_ID, HEADER_ID, and LINE_ID.
• CS_SYSTEMS — the configuration system definition; supplies the SYSTEM_NAME.
• SO_HEADERS_ALL and SO_LINES_ALL — order header and line data; SO_LINES_ALL is aliased twice (SOL1 for the child line, SOLP for the parent) to support option hierarchies.
• SO_ORDER_TYPES — supplies the ORDER_TYPE name.
• MTL_SYSTEM_ITEMS_KFV — the item key flexfield view, yielding MODEL_NAME via CONCATENATED_SEGMENTS.

All joins are outer joins ((+) notation), meaning configuration error rows are preserved even when the associated order line, header, or system record is absent — a design choice that keeps orphaned or in-progress CZ records visible. The query applies DISTINCT and a GROUP BY clause, and invokes helper functions on the OE_CONFIG package to compute the count columns.

Key Columns

• SYSTEM_ID / SYSTEM_NAME — identifier and name of the configuration system.
• HEADER_ID / ORDER_NUMBER / ORDER_TYPE — the sales order context.
• LINE_ID, LINE_NUMBER, SHIPMENT_NUMBER, OPTION_NUMBER — the specific order or shipment line; OPTION_NUMBER is populated only for option (child) lines.
• MODEL_NAME — concatenated segments of the configured model item.
• MESSAGE_COUNT, ERROR_COUNT, SUGGESTION_COUNT, WARNING_COUNT, AUTOSELECTION_COUNT, OVERRIDEN_ERROR_COUNT, OVERRIDE_ERROR_COUNT — the aggregate diagnostic counters, each derived from a CZ_*_COUNT function in the OE_CONFIG package.

Common Use Cases and Queries

Typical scenarios include troubleshooting order-line configuration failures, auditing override activity, and reporting validation bottlenecks. A representative query filtering by system name:

• SELECT order_number, line_number, system_name, error_count, warning_count, suggestion_count FROM cz_errors_summary_v WHERE system_name = :system_name AND error_count > 0 ORDER BY order_number, line_number;
• Counting errors grouped by order type: SELECT order_type, SUM(error_count) FROM cz_errors_summary_v GROUP BY order_type;
• Listing autoselections by model: SELECT model_name, SUM(autoselection_count) FROM cz_errors_summary_v GROUP BY model_name;

Note that the ETRM metadata records this view as "Not implemented in this database" for the documented instance; confirm existence in the target environment before relying on it.