Search Results cz_signatures




Overview
Explore in AI Chat

Overview

CZ_SIGNATURES is a Configurator (CZ) module table in Oracle E-Business Suite, owned by the CZ schema. Its documented description is a data type specification table. In the Configurator architecture, this object defines the signature metadata used to describe the arguments, data types, and behavioral characteristics of functions and methods invoked within the configuration engine. Each signature record specifies how a rule or programmatic procedure expects its inputs to be typed and constrained, thereby supporting the runtime evaluation and validation of configuration rules.

The table is present in both 12.1.1 and 12.2.2 environments and is marked VALID. In 12.2.2 it carries the ZD_EDITION_NAME column, reflecting the editioning/online patching model. The metadata carries a heuristic Data Vault classification of standalone, meaning no upstream foreign key dependencies were mined. From a modeling suggestion perspective, CZ_SIGNATURES most closely resembles a hub whose business key is the signature identity combined with edition context; it functions as a reference entity that other rule and e-signature tables point to, rather than a transactional link or satellite.

Key Information Stored

The table contains 21 documented columns. The most significant include:

Common Use Cases and Queries

Typical uses include diagnosing rule failures, auditing seeded versus custom signatures, and reporting on Configurator rule bindings. A representative query listing active user-defined signatures follows:

  • SELECT s.SIGNATURE_ID, s.NAME, s.SIGNATURE_TYPE, s.DATA_TYPE, s.ARGUMENT_COUNT FROM CZ.CZ_SIGNATURES s WHERE s.DELETED_FLAG = 'N' AND s.SEEDED_FLAG = 'N' ORDER BY s.NAME;
  • Joining to CZ_RULES to list rules per signature: ... FROM CZ.CZ_SIGNATURES s JOIN CZ.CZ_RULES r ON r.SIGNATURE_ID = s.SIGNATURE_ID;
  • Edition-aware filtering in 12.2.2 using ZD_EDITION_NAME.

Related Objects

  • CZ_RULES — joins on SIGNATURE_ID; rules referencing a signature definition.
  • CZ_IMP_RULES — joins on SIGNATURE_ID; imported/derived rule records.
  • EDR_ESIGNATURES — joins on SIGNATURE_ID; electronic signature definitions.
  • EDR_PSIG_DETAILS — joins on SIGNATURE_ID; parameter signature detail rows.
  • EDR_PSIG_SIGN_PARAMS_B — joins on SIGNATURE_ID; parameter signature bindings.

These foreign keys confirm CZ_SIGNATURES as a central reference entity shared across Configurator rule and e-signature subsystems.