Results for “cz_signatures”

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

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:

• SIGNATURE_ID — surrogate primary key, defined by CZ_SIGNATURES_PK and additionally part of the composite PK with ZD_EDITION_NAME in 12.2.2.
• NAME and DESCRIPTION — human-readable identification of the signature.
• SIGNATURE_TYPE — categorizes the signature, and forms part of the business-key candidate index CZ_SIGNATURES_U1 with DELETED_FLAG and SIGNATURE_ID.
• DATA_TYPE and JAVA_DATA_TYPE — the Configurator data type and its Java counterpart.
• ARGUMENT_COUNT — number of arguments the signature expects.
• TOP_LEVEL_CONSTRAINT_FLAG and COLLECTION_FLAG — indicate structural constraints over arguments.
• MUTABLE_FLAG and EVENT_BINDING_SCOPE — behavioral attributes governing mutability and event scope.
• CONFIG_ENGINE_TYPE and ORIG_SYS_REF — engine classification and source-system reference.
• SEEDED_FLAG and DELETED_FLAG — Oracle-seeded versus user-defined, and soft-delete status.
• ZD_EDITION_NAME — edition discriminator in 12.2.2.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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.