Search Results cz_config_hdrs




Overview
Explore in AI Chat

Overview

The CZ_CONFIG_HDRS table is the central configuration header table within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS). It serves as the master record for every unique configuration session or saved configuration instance created within the system. Each row represents a specific configuration, capturing its essential metadata, lineage, and state. This table is fundamental to the Configurator's architecture, acting as the primary parent entity that links a configuration to its constituent items, inputs, messages, and related transactional data such as quotes and opportunities. Its role is critical for tracking the lifecycle of configured products throughout the order-to-cash process.

Key Information Stored

The table's primary key is a composite of CONFIG_HDR_ID and CONFIG_REV_NBR, enabling version control for configurations that may be revised. Key columns, as indicated by its foreign key relationships, store identifiers that establish critical linkages. These include COMPONENT_ID, linking to the configured model definition in CZ_PS_NODES; UI_DEF_ID, referencing the user interface definition in CZ_UI_DEFS; and OPPORTUNITY_HDR_ID, connecting the configuration to a sales opportunity in CZ_OPPORTUNITY_HDRS. It also tracks user context via USER_ID_FOR_WHOM_CREATED and USER_ID_CREATED, referencing the CZ_END_USERS table, and manages runtime context through EFFECTIVE_USAGE_ID, which points to CZ_MODEL_USAGES.

Common Use Cases and Queries

A primary use case is retrieving the complete details of a saved configuration for review, revision, or conversion to a quote line. Support and development teams often query this table to diagnose configuration issues by tracing a configuration's model and inputs. Common SQL patterns include joining to child detail tables to generate a comprehensive configuration bill of materials or to audit configuration history. For example:

  • Finding all configurations for a specific opportunity: SELECT * FROM cz_config_hdrs WHERE opportunity_hdr_id = <ID>;
  • Listing configurations created for a particular end user: SELECT config_hdr_id, config_rev_nbr FROM cz_config_hdrs WHERE user_id_for_whom_created = <ID>;
  • Joining to child tables to report on a configuration's items: SELECT h.*, i.* FROM cz_config_hdrs h, cz_config_items i WHERE h.config_hdr_id = i.config_hdr_id AND h.config_rev_nbr = i.config_rev_nbr AND h.config_hdr_id = <ID>;

Related Objects

As the core header table, CZ_CONFIG_HDRS has extensive relationships. It is referenced as a foreign key by numerous detail tables, including CZ_CONFIG_INPUTS (runtime user selections), CZ_CONFIG_ITEMS (output items and BOM), CZ_CONFIG_MESSAGES (validation and error messages), and CZ_QUOTE_MAIN_ITEMS (link to quoted items). It also references several master tables: CZ_PS_NODES (model structure), CZ_UI_DEFS (interface layout), CZ_OPPORTUNITY_HDRS (sales opportunity), CZ_END_USERS (users), and CZ_MODEL_USAGES (deployed model version). This network of relationships underscores its pivotal position in the Configurator's data model.