Search Results cz_config_attributes




Overview
Explore in AI Chat

Overview

The CZ_CONFIG_ATTRIBUTES table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the master repository for storing attribute values assigned to configuration items during a runtime configuration session. This table is essential for capturing the detailed, user-selected specifications of a configured product, such as the color, size, or material of a component. The data stored here represents the final, instantiated output of the configurator engine, linking abstract model definitions to concrete transactional records for orders, quotes, or service requests.

Key Information Stored

The table's structure is designed to uniquely identify an attribute value within a specific configuration instance. Its primary key is a composite of five columns, ensuring precise data integrity. The most critical columns include:

Common Use Cases and Queries

This table is central to reporting and downstream processing of configured items. A common use case is extracting the complete bill of materials with specifications for transferring to an order management line. Another is auditing configuration history. A typical query pattern joins to the configuration header and items tables to retrieve a human-readable report.

SELECT cha.config_hdr_id, chi.item_name, ca.attribute_code, ca.attribute_char_value
FROM cz.cz_config_attributes ca,
     cz.cz_config_items chi,
     cz.cz_config_hdrs cha
WHERE ca.config_hdr_id = chi.config_hdr_id
  AND ca.config_rev_nbr = chi.config_rev_nbr
  AND ca.config_item_id = chi.config_item_id
  AND ca.config_hdr_id = cha.config_hdr_id
  AND cha.config_hdr_id = :p_config_hdr_id;

Related Objects

As indicated by the provided foreign key metadata, CZ_CONFIG_ATTRIBUTES has a direct and fundamental relationship with the CZ_CONFIG_ITEMS table. Each attribute record must correspond to a valid item instance within a configuration. The table is also intrinsically linked to CZ_CONFIG_HDRS, which provides the master context for the configuration session. In practice, it is frequently accessed via configurator runtime APIs and is a primary source for the CZ_CFG_ATTRIBUTES_V and similar reporting views that aggregate configuration data for business intelligence.