Search Results constraint_type_name

Overview

ICX_CONFIG_MESSAGES_V is a reporting view exposed by Oracle iProcurement (product code ICX) that consolidates configurator validation messages generated during constraint processing. The view surfaces the contents of the CZ_ERRORS table joined to constraint definitions, constraint groups, and sales quote lines, so that users and integrators can inspect why a configured item or quote line failed constraint validation. Because configurator constraints drive configurability rules in Oracle Configurator, the messages captured here are the authoritative record of rule violations, forced selections, and auto-selection outcomes associated with a given header, line, or group.

The view is documented as a Configurator Validation Messages View with no implementation in the reference database, meaning it is deployed only where Oracle Configurator and its dependent schema (CZ) are installed. In Oracle EBS 12.1.1 and 12.2.2, the view is used primarily for diagnostics, exception reporting, and downstream integration, allowing validation errors to be extracted and reconciled against Quote Management structures without querying the base CZ schema directly.

Underlying Base Objects

The view text defines an inner join across six referenced objects:

• CZ_ERRORS (aliased CZ) — the central error/validation message fact table, supplying ERROR_ID, message text, status, header, group, assignment, and audit columns.
• CZ_CONSTRAINTS_VL (CC) — the constraint definition, contributing constraint name, constraint type, and message text.
• CZ_CONSTRAINT_ASSIGNMENTS (CA) — the constraint-to-model assignment, contributing constraint group and auto-selection type.
• FND_COMMON_LOOKUPS (FND1) — lookup 'CZ_CONSTRAINT_TYPES', providing the meaning for constraint type.
• FND_COMMON_LOOKUPS (FND2) — lookup 'CZ_CONSTRAINT_GROUPS', providing the meaning for constraint group.
• AS_QUOTE_LINES (AQL) — the sales quote line, joined on QUOTE_LINE_ID.

The ETRM metadata documents no referenced base objects and no owner, though the embedded SQL clearly establishes the joins above.

Key Columns

• ERROR_ID — surrogate key of the validation error record.
• CONSTRAINT_NAME, CONSTRAINT_TYPE, CONSTRAINT_TYPE_NAME — identity and decoded type of the violated constraint.
• CONSTRAINT_GROUP, CONSTRAINT_GROUP_NAME — group classification of the constraint assignment.
• AUTOSELECTION_TYPE — indicates whether the constraint auto-selected an option.
• MESSAGE_TEXT, MESSAGE_STATUS — the validation message itself and its processing status.
• HEADER_ID, LINE_ID, GROUP_ID, ASSIGNMENT_ID — foreign keys locating the message within the configuration hierarchy; LINE_ID resolves to AS_QUOTE_LINES.QUOTE_LINE_ID.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context that generated the message.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
• ROW_ID — row identifier derived from CZ_ERRORS.ROWID.

Common Use Cases and Queries

A frequent scenario is validating that a quote line configured correctly by reviewing all errors for a given line, which is often what users mean when they search for "cz_errors":

• List validation messages for a quote line:
  SELECT header_id, line_id, constraint_name, constraint_type_name, message_text, message_status FROM icx_config_messages_v WHERE line_id = :quote_line_id;
• Summarize errors by constraint group:
  SELECT constraint_group_name, COUNT(*) FROM icx_config_messages_v GROUP BY constraint_group_name;
• Identify auto-selection outcomes:
  SELECT line_id, constraint_name, autoselection_type, message_text FROM icx_config_messages_v WHERE autoselection_type IS NOT NULL;
• Audit by concurrent request:
  SELECT * FROM icx_config_messages_v WHERE request_id = :request_id;