Results for “cz_properties”

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

Overview

CZ_PROPERTIES is a core Configurator (CZ) module table in Oracle E-Business Suite, holding the master definition of item properties used by the Configurator engine. In EBS 12.1.1 and 12.2.2, Configurator relies on properties to describe the configurable characteristics of models, option classes, and options — for example, the values that drive rules, user interface behavior, and validation logic. Each row in CZ_PROPERTIES defines a single property, including its identifier, data type, default value, and effectiveness dates, and is subsequently referenced by expression logic, UI layout, item type definitions, and property value storage.

From a Data Vault modeling perspective, CZ_PROPERTIES is classified heuristically as a hub. It carries a surrogate primary key (PROPERTY_ID) that is referenced by numerous dependent tables, making it a natural anchor for property-related links and satellites. Practitioners should treat this classification as a modeling suggestion rather than a documented Oracle construct.

Key Information Stored

The table exposes 28 documented columns in the 12.2.2 schema. The following are the most significant for functional and reporting purposes:

• PROPERTY_ID — Surrogate primary key (CZ_PROPERTIES_PK). It is the foreign key target for all dependent CZ tables.
• NAME and DESC_TEXT — The human-readable property name and its descriptive text.
• DATA_TYPE — Defines the property's underlying type (numeric, string, etc.), governing validation and conversion.
• DEF_VALUE and DEF_NUM_VALUE — Default values in character and numeric form respectively.
• PROPERTY_UNIT — Unit of measure associated with numeric properties.
• ORIG_SYS_REF and SRC_APPLICATION_ID — Traceability to the originating source system.
• USER_NUM01–04 and USER_STR01–04 — Extensible user-defined numeric and string attributes.
• EFF_FROM, EFF_TO, and EFF_MASK — Effectiveness date range and mask controlling when the property is active.
• DELETED_FLAG — Logical deletion indicator; combined with PROPERTY_ID in the unique index CZ_PROPERTIES_U1, it serves as a business-key candidate.
• Audit columns such as CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY.
• CHECKOUT_USER and SECURITY_MASK — Support concurrent development and access control in the Configurator authoring environment.

The documented unique indexes are CZ_PROPERTIES_PK on PROPERTY_ID and CZ_PROPERTIES_U1 on (DELETED_FLAG, PROPERTY_ID).

Common Use Cases and Queries

CZ_PROPERTIES is frequently queried when auditing property definitions, debugging configuration rules, or reporting on model characteristics across a Configurator deployment. A typical lookup by name resembles:

• SELECT property_id, name, data_type, def_value FROM cz.cz_properties WHERE deleted_flag = 'N' ORDER BY name;
• Joining to CZ_ITEM_TYPE_PROPERTIES to identify which item types expose a given property: SELECT p.name, itp.item_type_id FROM cz.cz_properties p JOIN cz.cz_item_type_properties itp ON itp.property_id = p.property_id;
• Reporting active properties by effectiveness window: filter on EFF_FROM and EFF_TO against sysdate.
• Extracting user-defined attributes for downstream analytics via USER_NUM01–04 and USER_STR01–04.

Because the table participates in rule evaluation, ad hoc reports often combine it with expression and UI node data to trace how a property influences configuration output.

Related Objects

The documented foreign-key relationships identify the primary dependents of this hub table:

• CZ_EXPRESSION_NODES — References CZ_PROPERTIES via PROPERTY_ID, linking rules and expressions to properties.
• CZ_ITEM_PROPERTY_VALUES — Stores per-item property values via PROPERTY_ID.
• CZ_ITEM_TYPE_PROPERTIES — Associates properties with item types through PROPERTY_ID.
• CZ_PS_NODES — References the property via PROPERTY_BACKPTR.
• CZ_PS_PROP_VALS — Holds property set values keyed by PROPERTY_ID.
• CZ_UI_NODES — References CZ_PROPERTIES twice: through PROPERTY_ID and OPTION_SORT_PROPERTY, controlling UI behavior and ordering.

Together these tables form the property definition, value, rule, and presentation layers of the Configurator data model, with CZ_PROPERTIES acting as the central reference point.