Results for “cz_filter_sets”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_FILTER_SETS is a Configurator (CZ) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines a Populator data filter by means of an Expression. Populators drive the runtime generation of configuration results in Oracle Configurator, and a filter set constrains which data rows those populators act upon. Each row in CZ_FILTER_SETS binds together a development project, an expression, and an optional rule, thereby describing the predicate logic applied when populating model data.

Based on the foreign-key structure documented in the ETRM metadata, the table exhibits satellite-leaning characteristics under a heuristic Data Vault classification. Its primary key (FILTER_SET_ID) is a surrogate identifier, while the non-key descriptive attributes — source type, source syntax, source view references, and effectivity columns — behave like descriptive context attached to a parent business key. This classification is offered as a modeling suggestion; in the EBS schema itself the table functions as a conventional relational entity.

Key Information Stored

The surrogate primary key is FILTER_SET_ID, enforced by the unique index CZ_FILTER_SETS_PK. The documented schema contains 20 columns, of which the most significant are:

• FILTER_SET_ID — surrogate primary key and unique business-key candidate.
• DEVL_PROJECT_ID — foreign key to CZ_DEVL_PROJECTS, scoping the filter set to a development project.
• EXPRESS_ID — foreign key to CZ_EXPRESSIONS, supplying the predicate logic that the filter evaluates.
• RULE_ID — foreign key to CZ_RULES, associating the filter with a configuration rule.
• SOURCE_TYPE — identifies the kind of source the filter selects against.
• SOURCE_VIEW_OWNER and SOURCE_VIEW_NAME — the schema and view from which qualifying data is drawn.
• SOURCE_SYNTAX — the literal or generated syntax used at runtime for the filter.
• SRC_APPLICATION_ID — the owning application of the source object.
• EFF_FROM, EFF_TO, EFF_MASK — date-effectivity and mask columns governing when the filter is active.
• SECURITY_MASK — access control attribute.
• DELETED_FLAG, CHECKOUT_USER — logical deletion indicator and the user holding the row under configuration check-out.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which filters are attached to a given project, tracing how an expression feeds a populator, and reporting on filter effectivity. A representative query lists filter sets with their expressions and rules:

• SELECT fs.FILTER_SET_ID, fs.EXPRESS_ID, fs.RULE_ID, fs.SOURCE_VIEW_OWNER, fs.SOURCE_VIEW_NAME FROM CZ.CZ_FILTER_SETS fs WHERE fs.DELETED_FLAG = 'N';
• Join to CZ_DEVL_PROJECTS on DEVL_PROJECT_ID to scope filters by project.
• Filter on EFF_FROM and EFF_TO to identify currently active filter sets.
• Query by CHECKOUT_USER to find rows under active configuration check-out.

Reporting use cases include impact analysis before modifying a shared expression, and validating that each populator referenced in CZ_POPULATORS resolves to a non-deleted filter set.

Related Objects

• CZ_DEVL_PROJECTS — referenced via CZ_FILTER_SETS.DEVL_PROJECT_ID.
• CZ_EXPRESSIONS — referenced via CZ_FILTER_SETS.EXPRESS_ID.
• CZ_RULES — referenced via CZ_FILTER_SETS.RULE_ID.
• CZ_EXPRESSION_NODES — references this table through CZ_EXPRESSION_NODES.FILTER_SET_ID.
• CZ_POPULATORS — references this table through CZ_POPULATORS.FILTER_SET_ID.

These relationships make CZ_FILTER_SETS a central junction for populator-driven filtering within Oracle Configurator.