Search Results cz_config_items




Overview
Explore in AI Chat

Overview

The CZ_CONFIG_ITEMS table is a core data repository within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the detailed transactional record of a configured product, storing every individual component, option, and feature selected by a user during a configuration session. Each row in this table represents a single selected item within a specific configuration instance. The table is fundamental to the configurator's operation, as it persists the complete output of the configuration engine, enabling downstream processes like bill of material (BOM) explosion, pricing, and order fulfillment.

Key Information Stored

The table's structure is designed to manage complex, hierarchical configurations. Its primary key uniquely identifies each configured item through a combination of CONFIG_HDR_ID, CONFIG_REV_NBR, and CONFIG_ITEM_ID. This links the item to its parent configuration header in CZ_CONFIG_HDRS. Critical relational columns define the item's position within the configuration structure: PARENT_CONFIG_ITEM_ID establishes parent-child relationships between items, ROOT_BOM_CONFIG_ITEM_ID identifies the top-level assembly for BOM processing, and PS_NODE_ID links the item back to its source model definition in the CZ_PS_NODES table. Additional columns, not fully detailed in the excerpt but typical for this table, would store the inventory item identifier, quantity, and operational flags.

Common Use Cases and Queries

This table is central to extracting configuration details for integration, reporting, and troubleshooting. A common use case is generating a component list for a sales order or quote. A typical query would join CZ_CONFIG_HDRS to find the configuration and then CZ_CONFIG_ITEMS to list all selected components, often using a hierarchical CONNECT BY query to respect the item structure. Another critical scenario involves validating configuration data or debugging issues by tracing selected items back to their model definitions via the PS_NODE_ID. Sample SQL to retrieve all items for a configuration header would be:

  • SELECT ci.* FROM cz.cz_config_items ci, cz.cz_config_hdrs ch WHERE ci.config_hdr_id = ch.config_hdr_id AND ci.config_rev_nbr = ch.config_rev_nbr AND ch.config_hdr_id = <ID>;

Related Objects

As indicated by its extensive foreign key relationships, CZ_CONFIG_ITEMS is the central hub for detailed configuration data. The primary parent table is CZ_CONFIG_HDRS, which stores the configuration's header information. Key child tables that store additional attributes and relationships for each configured item include CZ_CONFIG_ATTRIBUTES, CZ_CONFIG_EXT_ATTRIBUTES, and CZ_CONFIG_USAGES. The table has a recursive relationship with itself via PARENT_CONFIG_ITEM_ID and ROOT_BOM_CONFIG_ITEM_ID to manage hierarchies. It is also referenced by CZ_CONFIG_INPUTS (for compatibility rules), CZ_DRILL_DOWN_ITEMS, and CZ_PS_NODES, linking runtime selections back to the design-time model.