Search Results cz_autoselection_items




Overview
Explore in AI Chat

Overview

CZ_AUTOSELECTION_ITEMS is a configuration management table within the Oracle E-Business Suite Bills of Material (BOM) module, specifically belonging to Oracle Configurator (CZ schema). It stores the definition of automatic selection items — the items that the Configurator engine automatically includes in a configuration based on rules, constraints, or ranges rather than explicit user selection. This table is central to how Oracle Configurator models "auto-include" behavior during runtime configuration, ensuring that dependent or mandatory components are populated without manual user intervention.

Based on the documented foreign key topology, the heuristic Data Vault classification for this table is link. This classification reflects its role as an associative structure that resolves relationships between constraint assignments, autoselection ranges, and inventory items, rather than acting as an independent hub of business keys or a pure descriptive satellite.

The metadata notes that this object is "Not implemented in this database," meaning the table may not exist in every EBS instance, since Oracle Configurator is an optional licensed component. Its presence depends on whether the Configurator module has been installed and configured.

Key Information Stored

The primary key of the table is defined by the constraint CZ_AUTOSELECTION_ITEMS_PK, whose key column is AUTOSELECTION_ID. This surrogate key uniquely identifies each autoselection item record and is the anchor for child references and joins. Beyond the surrogate key, the business-relevant columns documented through the foreign key definitions include:

  • AUTOSELECTION_ID — Surrogate primary key uniquely identifying each autoselection item row.
  • ASSIGNMENT_ID — Foreign key referencing CZ_CONSTRAINT_ASSIGNMENTS; ties the autoselection item to the constraint assignment that governs its inclusion behavior.
  • RANGE_ID — Foreign key referencing CZ_AUTOSELECTION_RANGES; associates the item with a range definition that determines the quantity or condition under which it is selected.
  • INVENTORY_ITEM_ID — Foreign key referencing MTL_SYSTEM_ITEMS_B; identifies the inventory item that is autoselected.
  • ORGANIZATION_ID — The inventory organization context for the referenced item, forming part of the composite reference to MTL_SYSTEM_ITEMS_B.

The composite foreign key relationship to MTL_SYSTEM_ITEMS_B (INVENTORY_ITEM_ID plus ORGANIZATION_ID) reflects the standard EBS pattern for item references, where items are defined per organization. Together, AUTOSELECTION_ID, ASSIGNMENT_ID, RANGE_ID, and the item/organization pair constitute the meaningful business context of each row.

Common Use Cases and Queries

Typical usage involves tracing which items are auto-included under a given constraint, validating configurator rule definitions, and reconciling configured orders against their auto-populated components. A common query joins the table to the item master to resolve item descriptions:

  • Listing autoselection items with their item details: join CZ_AUTOSELECTION_ITEMS to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • Finding autoselection items governed by a specific constraint assignment: filter on ASSIGNMENT_ID after joining CZ_CONSTRAINT_ASSIGNMENTS.
  • Reconciling ranges to items: join to CZ_AUTOSELECTION_RANGES on RANGE_ID to evaluate quantity or condition logic.
  • Auditing configuration completeness: count autoselection items per inventory organization to detect missing or duplicated auto-include definitions.

Reporting use cases commonly feed product configurator validation reports, order-to-BOM reconciliation, and diagnostics of unexpected auto-added components during sales order entry.

Related Objects

The most significant objects related to CZ_AUTOSELECTION_ITEMS, derived from the documented foreign key relationships, are:

  • CZ_CONSTRAINT_ASSIGNMENTS — via CZ_AUTOSELECTION_ITEMS.ASSIGNMENT_ID; defines the constraint governing autoselection.
  • CZ_AUTOSELECTION_RANGES — via CZ_AUTOSELECTION_ITEMS.RANGE_ID; defines selection ranges and quantities.
  • MTL_SYSTEM_ITEMS_B — via INVENTORY_ITEM_ID and ORGANIZATION_ID; the item master providing item identity and organization context.
  • CZ_AUTOSELECTION_ITEMS_PK — the primary key constraint anchoring the table.

Because the object is classified as a link resolving references among these parent tables, analysis should always be performed in the context of the constraint and range definitions it connects rather than in isolation.