Search Results cz_effectivity_sets




Overview
Explore in AI Chat

Overview

The CZ_EFFECTIVITY_SETS table is a core repository within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a master list for named and shared effectivity definitions. Effectivity, a fundamental concept in product configuration, governs the conditions under which a specific configuration rule, component, or feature is valid or applicable. This table enables the centralized management of these condition sets, allowing them to be defined once and referenced by multiple other configuration entities. Its primary role is to provide a reusable, standardized mechanism for controlling the activation and deactivation of configuration logic based on criteria such as dates, model numbers, or other business attributes, thereby enforcing complex product lifecycle and compatibility rules.

Key Information Stored

While the provided metadata does not list specific columns, the structure and purpose of the table indicate it contains key identifiers and descriptive data for each effectivity set. The central column is EFFECTIVITY_SET_ID, which serves as the primary key and unique identifier for each named effectivity set. Other columns typically include a name or code for the set (e.g., EFFECTIVITY_SET_NAME), a description, and potentially flags indicating its status (e.g., active). The table itself does not store the detailed condition logic (like specific date ranges or attribute comparisons); instead, it acts as a header record. The detailed effectivity rules are managed elsewhere within the Configurator schema, linked via this ID.

Common Use Cases and Queries

This table is primarily accessed for administrative reporting, data integrity checks, and impact analysis. Common operational scenarios include identifying all configuration objects governed by a specific effectivity set before modifying it, or generating a list of all shared effectivity sets in use. A fundamental query retrieves the basic master list of effectivity sets. For impact analysis, a join with a governed table, such as CZ_RULES, is essential to understand dependencies. For instance, to find all rules using a particular effectivity set named 'MODEL_YR_2024', one would query the CZ_EFFECTIVITY_SETS and CZ_RULES tables using the EFFECTIVITY_SET_ID as the join key. Data validation queries are also common, such as identifying effectivity sets defined in CZ_EFFECTIVITY_SETS that are no longer referenced by any active configuration objects, which could indicate orphaned data.

Related Objects

The CZ_EFFECTIVITY_SETS table has defined foreign key relationships with several critical Configurator tables, as documented in the metadata. These relationships demonstrate where named effectivity sets are applied:

  • CZ_PS_NODES: References CZ_EFFECTIVITY_SETS via the column CZ_PS_NODES.EFFECTIVITY_SET_ID. This governs the effectivity of items in the product structure.
  • CZ_RULES: References CZ_EFFECTIVITY_SETS via the column CZ_RULES.EFFECTIVITY_SET_ID. This controls when specific configuration logic rules are active.
  • CZ_RULE_FOLDERS: References CZ_EFFECTIVITY_SETS via the column CZ_RULE_FOLDERS.EFFECTIVITY_SET_ID. This allows for effectivity to be applied at the folder level, potentially affecting groups of rules.

In all cases, the join column from the related table points to the EFFECTIVITY_SET_ID primary key in CZ_EFFECTIVITY_SETS.