Search Results cz_config_usages




Overview
Explore in AI Chat

Overview

The CZ_CONFIG_USAGES table is a core data object within the Oracle E-Business Suite Configurator (CZ) module. It functions as a transactional audit log, systematically recording each instance where a specific configuration item is utilized by a client application. Its primary role is to establish and maintain traceability between the configurable components defined within the Configurator and their practical application across the EBS suite, such as within Order Management or Service contracts. This linkage is critical for understanding configuration dependencies, supporting lifecycle management of configuration data, and ensuring referential integrity when configurations are modified or purged.

Key Information Stored

The table's structure is designed to uniquely identify a usage event by combining identifiers for the calling application, the specific configuration header, and the individual configuration item. The primary key columns are CALLING_APPLICATION_ID, CALLING_APPLICATION_REF_KEY, CONFIG_HDR_ID, CONFIG_ITEM_ID, and CONFIG_REV_NBR. These columns store the application identifier (e.g., for OM or Service), a reference key from that application (like a line ID), the unique identifier for the configuration model header (CZ_CONFIG_HEADERS), the identifier for a specific item within that configuration (CZ_CONFIG_ITEMS), and the revision number of that configuration item. This composite key ensures a single usage of a specific item revision by a specific application transaction is recorded once.

Common Use Cases and Queries

A primary use case is impact analysis before deleting obsolete configuration data. Administrators can query this table to verify if a configuration item is still referenced in transactional systems. Another common scenario is generating reports to analyze which configurations are most frequently used across different business flows. Sample SQL patterns often involve joins to the related CZ_CONFIG_ITEMS and CZ_CONFIG_HEADERS tables to retrieve descriptive information.

  • Finding all usages for a specific configuration item: SELECT * FROM cz.cz_config_usages WHERE config_item_id = <item_id>;
  • Identifying which order lines reference a given configuration: SELECT calling_application_ref_key FROM cz.cz_config_usages WHERE calling_application_id = 'OM' AND config_hdr_id = <hdr_id>;

Related Objects

The CZ_CONFIG_USAGES table has a defined foreign key relationship with the CZ_CONFIG_ITEMS table, which is central to its integrity. The foreign key constraint enforces that a recorded usage must point to a valid, existing configuration item. The join is performed on three columns, reflecting the composite nature of the configuration item's identity:

  • Foreign Key Table: CZ_CONFIG_USAGES
  • Primary Key Table: CZ_CONFIG_ITEMS
  • Join Columns: CZ_CONFIG_USAGES.CONFIG_HDR_ID = CZ_CONFIG_ITEMS.CONFIG_HDR_ID, CZ_CONFIG_USAGES.CONFIG_REV_NBR = CZ_CONFIG_ITEMS.CONFIG_REV_NBR, and CZ_CONFIG_USAGES.CONFIG_ITEM_ID = CZ_CONFIG_ITEMS.CONFIG_ITEM_ID

This relationship ensures that usages cannot exist for configuration items that have been deleted, maintaining data consistency within the Configurator module.