Results for “rel_type_id”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CZ_REL_TYPES is a table in the CZ (Configurator) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. The ETRM metadata explicitly records a description of "NEVER USED," noting that the table was intended to qualify parent-child relationships for CZ_ITEM_PARENTS. This is a critical distinction: the object exists, is VALID, and carries a documented physical schema and primary key, but Oracle's own reference documentation states that the Configurator runtime never populated or consumed it. It is best understood as a vestigial design artifact — a lookup table that was modeled during the original Configurator data design and then superseded, presumably because relationship semantics were folded directly into CZ_ITEM_PARENTS or handled through the Configurator's rule engine rather than through a type code.
From a Data Vault modeling perspective, the heuristic classification mined from its foreign-key structure is hub-leaning. This is consistent with the object's shape: a narrow surrogate-keyed entity with a descriptive attribute and effective-dating columns, which is the classic profile of a hub that other tables reference by key. The classification is offered as a modeling suggestion only, since the table's "NEVER USED" status means it holds no transactional history in typical production instances.
Key Information Stored
The documented physical schema for 12.2.2 comprises 13 columns. The most significant are:
- REL_TYPE_ID — the surrogate primary key, enforced by unique index CZ_REL_TYPES_PK. This is the only documented unique index and therefore the only business-key candidate; no alternate unique key on NAME is documented.
- NAME — the descriptive label for a relationship type. This would have been the user-facing identifier for a parent-child qualification had the table been used.
- DELETED_FLAG — soft-delete indicator, consistent with the orphaned-row pattern used elsewhere in the CZ schema.
- EFF_FROM and EFF_TO — effective-dating boundaries, indicating the design anticipated date-tracked relationship definitions.
- EFF_MASK and SECURITY_MASK — Configurator multi-organization and security filtering columns.
- CHECKOUT_USER — the Configurator checkout/versioning column, indicating the table was intended to participate in the Configurator's check-in/check-out model.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns.
Common Use Cases and Queries
Because the table is documented as never used, the primary practical use case is verification rather than reporting. Consultants performing impact analysis, migrations, or data-cleanup exercises will typically confirm emptiness before assuming any dependency:
SELECT COUNT(*) FROM cz.cz_rel_types;— a zero count is the expected result and confirms the "NEVER USED" designation.- Row counts are equally relevant on the referencing tables, since CZ_ITEM_PARENTS.REL_TYPE_ID and CZ_IMP_ITEM_PARENT.REL_TYPE_ID are the only documented inbound foreign keys.
SELECT rel_type_id, name FROM cz.cz_rel_types ORDER BY name;— a defensive query when auditing a legacy or upgraded instance for stray populated rows.
Reporting against this table is not recommended in a functional sense, but it should be included in schema inventory and drop-safety assessments during upgrades from 12.1.1 to 12.2.2.
Related Objects
- CZ_ITEM_PARENTS — the principal referencing table; its REL_TYPE_ID column is the documented foreign key to CZ_REL_TYPES, and this is the parent-child structure the type table was meant to qualify.
- CZ_IMP_ITEM_PARENT — the interface/import counterpart, also carrying REL_TYPE_ID as a foreign key to CZ_REL_TYPES.
- CZ_REL_TYPES_PK — the unique index enforcing the surrogate primary key on REL_TYPE_ID.
No views or public APIs are documented against this table. Any custom code joining to it should be reviewed, as the join will always return no qualifying rows in a standard instance.
-
NEVER USED. Intended to qualify parent-child relationships for CZ_ITEM_PARENTS.
-
NOT USED.
-
NOT USED
-
NEVER USED. Intended to qualify parent-child relationships for CZ_ITEM_PARENTS.
-
NOT USED.
-
NOT USED
-
TABLE: CZ.CZ_REL_TYPES 12.1.1
-
VIEW: CZ.CZ_REL_TYPES# 12.2.2
-
VIEW: CZ.CZ_ITEM_PARENTS# 12.2.2
-
VIEW: CZ.CZ_IMP_ITEM_PARENT# 12.2.2
-
TABLE: CZ.CZ_ITEM_PARENTS 12.1.1
-
TABLE: CZ.CZ_ITEM_PARENTS 12.2.2
-
TABLE: CZ.CZ_REL_TYPES 12.2.2
-
VIEW: CZ.CZ_REL_TYPES# 12.2.2
-
VIEW: CZ.CZ_ITEM_PARENTS# 12.2.2
-
VIEW: CZ.CZ_IMP_ITEM_PARENT# 12.2.2
-
TABLE: CZ.CZ_IMP_ITEM_PARENT 12.2.2
-
TABLE: CZ.CZ_IMP_ITEM_PARENT 12.1.1
-
eTRM - CZ Tables and Views 12.2.2
Import control table responsible for NOUPDATE flags
-
eTRM - CZ Tables and Views 12.1.1
Import control table responsible for NOUPDATE flags
-
eTRM - CZ Tables and Views 12.2.2
Import control table responsible for NOUPDATE flags
-
eTRM - CZ Tables and Views 12.1.1
Import control table responsible for NOUPDATE flags