Search Results cz_rel_types




Overview
Explore in AI Chat

Overview

The CZ_REL_TYPES table is a metadata table within the Oracle E-Business Suite Configurator (CZ) module. Its documented purpose is to qualify or categorize the parent-child relationships defined in the CZ_ITEM_PARENTS table, which is central to modeling configurable product structures. However, a critical detail from the official documentation is that this table is explicitly marked as "NEVER USED." This indicates that while the table was created as part of the schema with a defined intent, the functionality to utilize relationship type classifications was not implemented in the released versions of Oracle EBS 12.1.1 and 12.2.2. Its role is therefore structural and historical rather than functional in live configurations.

Key Information Stored

Based on its schema definition and intended purpose, the primary column in the CZ_REL_TYPES table is the REL_TYPE_ID, which serves as the table's primary key. This column would presumably store a unique identifier for a type of relationship (e.g., "Component Of," "Optional Feature," "Substitute For"). While other descriptive columns likely exist (such as a name or description field), the provided metadata does not detail them. The core takeaway is that any data present in this table is not actively referenced by the Configurator runtime engine, as the table is not in use.

Common Use Cases and Queries

Given its "NEVER USED" status, there are no operational use cases for the CZ_REL_TYPES table within standard Oracle Configurator implementations. It does not drive configuration logic, reporting, or integration. The most likely interaction with this table would be during schema analysis or data cleanup initiatives. A database administrator might run a query to confirm its lack of active data. A sample validation query would be:

SELECT COUNT(*) FROM cz.CZ_REL_TYPES;

This would typically return zero or a minimal set of seed data. Any custom extensions attempting to leverage this table for enhanced relationship tracking would be unsupported and would require careful analysis of the CZ_ITEM_PARENTS foreign key constraint.

Related Objects

The table maintains a defined, albeit unused, foreign key relationship within the Configurator schema. The documented relationship is:

  • Primary Key: CZ_REL_TYPES_PK on column CZ_REL_TYPES.REL_TYPE_ID
  • Foreign Key Reference: The CZ_ITEM_PARENTS table contains a column, CZ_ITEM_PARENTS.REL_TYPE_ID, which is defined as a foreign key referencing CZ_REL_TYPES.REL_TYPE_ID. This structural link confirms the original design intent to classify item relationships.

Despite this constraint, the operational behavior of the CZ module does not depend on values in CZ_REL_TYPES, as the relationship qualification feature was not activated.