Search Results cz_populators




Overview
Explore in AI Chat

Overview

The CZ_POPULATORS table is a core data repository within the Oracle E-Business Suite Configurator (CZ) module. It serves as the master table for storing definitions of Populators, which are critical business rules that automatically populate values for configurable item attributes, components, or options based on specific conditions. In the context of a product structure model, a Populator automates data entry, enforces business logic, and ensures consistency across configured product instances. Its role is integral to the runtime behavior of the Oracle Configurator engine, directly influencing how product configurations are generated and validated for orders, quotes, and other transactions.

Key Information Stored

While the provided metadata does not list specific columns beyond key relationships, the table's primary function is to store the metadata that defines a Populator rule. Based on its documented relationships and standard Configurator schema patterns, the table centrally stores the unique POPULATOR_ID as its primary key. Crucially, it links each Populator to its parent object in the product structure via the OWNED_BY_NODE_ID foreign key to CZ_PS_NODES. It also associates the rule with its governing condition through the FILTER_SET_ID foreign key to CZ_FILTER_SETS, which defines the "if" portion of the rule. Other columns typically define the Populator's execution sequence, data type, and the target attribute or item to be populated.

Common Use Cases and Queries

Primary use cases involve troubleshooting configuration logic, auditing rule dependencies, and performing data cleanups. Administrators and developers query this table to understand which automatic population rules affect a specific model node or to identify all populators using a particular filter set. A common reporting query retrieves all populators owned by a specific model node for review:

  • SELECT p.populator_id, p.name FROM cz_populators p WHERE p.owned_by_node_id = <node_id>;

Another critical pattern is joining to CZ_POPULATOR_MAPS to analyze which model nodes are targeted by a given populator's output, essential for impact analysis before modifying a rule.

Related Objects

The CZ_POPULATORS table is central to the Configurator schema, with documented relationships to several key tables:

  • CZ_PS_NODES: A Populator is owned by a specific product structure node (OWNED_BY_NODE_ID). Conversely, a node can be created as the output of a Populator (FROM_POPULATOR_ID).
  • CZ_FILTER_SETS: Defines the conditional logic (the "if" clause) that triggers the Populator, linked via FILTER_SET_ID.
  • CZ_POPULATOR_MAPS: Defines the specific target nodes and attributes (the "then" clause) that receive the populated values, linked by POPULATOR_ID.

These relationships form the complete definition of a Populator rule: its owner (CZ_PS_NODES), its condition (CZ_FILTER_SETS), and its execution targets (CZ_POPULATOR_MAPS).