Results for “cz_config_messages”

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

Overview

CZ_CONFIG_MESSAGES is a Configurator (CZ) module table in Oracle E-Business Suite that stores configuration messages generated during the configuration runtime. It resides in the CZ schema and holds a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. The table captures the diagnostic and informational messages that the Configurator engine emits as it validates and processes a configured item, including messages tied to specific configuration headers, revisions, and model nodes. This makes the table a critical audit and troubleshooting source for configuration integrity, rule violations, and constraint enforcement.

From a Data Vault modeling perspective, the documented foreign keys and structure suggest that CZ_CONFIG_MESSAGES is best classified heuristically as a link entity. Its 22 documented columns include multiple references and descriptive attributes, so it can also be viewed as a link with bagged satellite attributes. This classification is a modeling suggestion derived from the FK topology rather than a prescribed physical design.

Key Information Stored

The primary key is the surrogate column MESSAGE_SEQ, backed by the unique index CZ_CONFIG_MESSAGES_PK. The most significant business-key and descriptive columns include:

• MESSAGE_SEQ — Surrogate primary key uniquely identifying each configuration message row.
• CONFIG_HDR_ID — Foreign key to CZ_CONFIG_HDRS, linking the message to its configuration header.
• CONFIG_REV_NBR — Configuration revision number associated with the header reference.
• CONFIG_ITEM_ID — The configured item instance the message pertains to.
• INSTANCE_HDR_ID / INSTANCE_REV_NBR — Instance header and revision that generated the message.
• PS_NODE_ID — Foreign key to CZ_PS_NODES, identifying the model node that produced the message.
• RULE_ID — Identifier of the rule whose evaluation triggered the message.
• CONSTRAINT_TYPE — Classification of the constraint or rule that fired.
• MESSAGE — The actual message text delivered to the user or log.
• OVERRIDE — Flag indicating whether the message condition was overridden.
• DELETED_FLAG — Soft-delete indicator for logical removal.
• EFF_FROM / EFF_TO — Effective dating range for the message record.
• SECURITY_MASK / EFF_MASK — Masking attributes controlling visibility and effectivity.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO audit columns.

Common Use Cases and Queries

Support and implementation teams query CZ_CONFIG_MESSAGES to diagnose why a configuration failed validation, to identify which model node or rule produced a message, and to report on override activity. Typical SQL patterns join to the header and node tables:

• Retrieve all messages for a configuration: SELECT m.MESSAGE FROM CZ.CZ_CONFIG_MESSAGES m WHERE m.CONFIG_HDR_ID = :hdr_id AND m.DELETED_FLAG = 'N';
• Trace messages to their originating node: SELECT m.MESSAGE, m.PS_NODE_ID FROM CZ.CZ_CONFIG_MESSAGES m WHERE m.PS_NODE_ID = :node_id;
• Report overrides and constraint types: SELECT CONSTRAINT_TYPE, OVERRIDE, COUNT(*) FROM CZ.CZ_CONFIG_MESSAGES WHERE OVERRIDE = 'Y' GROUP BY CONSTRAINT_TYPE, OVERRIDE;
• Audit messages raised within an effective range using EFF_FROM / EFF_TO.

Related Objects

The following objects are most directly related through documented foreign keys and functional dependency:

• CZ_CONFIG_HDRS — Parent of the message via CONFIG_HDR_ID and CONFIG_REV_NBR.
• CZ_PS_NODES — Parent node reference via PS_NODE_ID.
• CZ_CONFIG_MESSAGES_PK — Primary key unique index on MESSAGE_SEQ.
• CZ_CONFIG_ITEMS — Configured items referenced by CONFIG_ITEM_ID.
• CZ_CONFIG_HDRS instance linkage via INSTANCE_HDR_ID and INSTANCE_REV_NBR.
• Configurator runtime validation and rules engine components that generate and consume message rows.