Search Results cz_config_ext_attributes




Overview
Explore in AI Chat

Overview

The CZ_CONFIG_EXT_ATTRIBUTES table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS). Its primary role is to support the integration between the Configurator and the Installed Base (IB) module. It acts as a fully-normalized repository for extended attributes that are attached to configuration items. When a product is configured within Oracle Configurator, the resulting configuration is composed of individual items. This table stores additional, user-defined attribute data for those items, enabling the detailed specification of component characteristics that can be passed to and stored in Installed Base for asset tracking and service management.

Key Information Stored

The table's structure is designed to uniquely identify an attribute value for a specific configuration item within a specific configuration revision. The primary key is a composite of four columns, ensuring a unique record for each attribute on each item. The critical columns include CONFIG_HDR_ID and CONFIG_REV_NBR, which together identify the specific configuration instance and its revision. The CONFIG_ITEM_ID pinpoints the exact component or item within that configuration. The ATTRIBUTE_NAME column stores the identifier for the extended attribute (e.g., 'SerialNumber', 'Wattage'), while the corresponding ATTRIBUTE_VALUE column (implied by standard design, though not explicitly listed in the provided metadata) would hold the actual data for that attribute. This normalized design allows for a flexible and extensible set of properties on any configurable item.

Common Use Cases and Queries

The primary use case revolves around extracting detailed component information for downstream processes. A common requirement is to generate a report of all configured items with their extended attributes for a sales order or service request. This is critical for creating accurate service histories and asset records in Installed Base. A typical query would join this table to the configuration header and items tables. For example, to find all extended attributes for items in a specific configuration, one might use:

  • SELECT cea.* FROM cz_config_ext_attributes cea WHERE cea.config_hdr_id = &header_id AND cea.config_rev_nbr = &revision;

Another frequent operation is validating that required attributes (like serial numbers for serviceable components) have been populated before the configuration is released to manufacturing or installed base.

Related Objects

The CZ_CONFIG_EXT_ATTRIBUTES table has a direct and critical foreign key relationship with the CZ_CONFIG_ITEMS table, which stores the master list of items within a configuration. The relationship is defined on three key columns, ensuring data integrity: the CONFIG_HDR_ID, CONFIG_REV_NBR, and CONFIG_ITEM_ID in CZ_CONFIG_EXT_ATTRIBUTES must exist as a composite key in CZ_CONFIG_ITEMS. This enforces that extended attributes can only be attached to valid configuration items. Consequently, any process or report querying extended attributes will invariably join to CZ_CONFIG_ITEMS and likely further to CZ_CONFIG_HEADERS to obtain the full context of the configuration.