Search Results cz_filter_sets




Overview
Explore in AI Chat

Overview

The CZ_FILTER_SETS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS). It serves as the repository for defining data filters used by Configurator Populators. A Populator is a mechanism that automatically loads data, such as items or prices, into a configuration model at runtime. The table defines these filters by storing a reference to a Boolean expression (EXPRESS_ID), which determines the specific subset of data the Populator will retrieve from the source system. This enables the dynamic population of configuration models based on complex, rule-driven criteria, which is fundamental to delivering accurate and context-sensitive product configurations.

Key Information Stored

The table's primary key is FILTER_SET_ID, a unique identifier for each filter definition. The most critical columns establish relationships to other Configurator entities. The EXPRESS_ID column holds a foreign key to the CZ_EXPRESSIONS table, linking to the actual Boolean expression that constitutes the filter logic. The DEVL_PROJECT_ID column links the filter to a specific development project in the CZ_DEVL_PROJECTS table, organizing it within the correct Configurator workspace. The RULE_ID column provides an optional foreign key to the CZ_RULES table, allowing the filter to be associated with a specific configuration rule for further contextual integration.

Common Use Cases and Queries

The primary use case is the creation and management of Populator filters during the development of configuration models. A developer defines an expression in the Configurator Developer UI, and the system persists the filter definition in this table. Common reporting queries involve analyzing filter usage across projects or troubleshooting Populator behavior. For example, to list all filters within a specific development project, one might use:

  • SELECT fs.filter_set_id, e.name AS expression_name FROM cz_filter_sets fs, cz_expressions e WHERE fs.express_id = e.express_id AND fs.devl_project_id = <project_id>;

Another critical query joins to CZ_POPULATORS to identify which populators utilize a given filter set, which is essential for impact analysis before modifying a filter's underlying expression.

Related Objects

As documented in the ETRM metadata, CZ_FILTER_SETS has integral relationships with several other Configurator tables. It is the parent table referenced by CZ_POPULATORS (via POPULATORS.FILTER_SET_ID) and CZ_EXPRESSION_NODES (via EXPRESSION_NODES.FILTER_SET_ID). It is a child table dependent on CZ_DEVL_PROJECTS (via DEVL_PROJECT_ID), CZ_EXPRESSIONS (via EXPRESS_ID), and CZ_RULES (via RULE_ID). These foreign key relationships underscore its central role: it links a development project and an optional rule to a reusable expression, and this composite filter set is then consumed by both populators and the expression node structure itself.