Search Results sys_prop_token

Overview

CZ_SIGNATURE_SYSPROPS_V is an APPS-owned view within the CZ (Configurator) product module of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. The view exposes the metadata that describes "system properties" — the configurable rule attributes attached to signature nodes — and how those properties are typed, sequenced, and returned by the Configurator engine. It is intended for diagnostic, reporting, and integration purposes rather than transactional data entry.

Its central purpose is to project, for each system property rule, the associated rule type, the signature (return type) used, collection and mutability characteristics, and the property's placement within the model. Because it joins model-level project context through CZ_DEVL_PROJECTS, the view is inherently model-scoped and is commonly used to inspect how properties are defined across a development project's configurable models.

Underlying Base Objects

Per ETRM metadata for 12.2.2, the view is defined over the following documented base objects: CZ_DEVL_PROJECTS (synonym), CZ_MODEL_PROP_ENGTYP_COMPAT_V (view), CZ_RULES (synonym), CZ_RULETYPECODES_LKV (view), CZ_SIGNATURES (synonym), CZ_TYPE_RELATIONSHIPS (synonym), and FND_PROFILE (package).

• CZ_RULES supplies the core property rule rows, including rule type, sequence number, template token, instance-set flag, and rule/signature identifiers.
• CZ_SIGNATURES is joined multiple times to resolve signature names, return types, collection behavior, and mutability for the rule and its return signature.
• CZ_TYPE_RELATIONSHIPS provides the CNV (conversion/attachment) relationships linking rules, signatures, and nodes to their subject and object types; deleted-flag filtering is applied.
• CZ_RULETYPECODES_LKV decodes rule type codes and labels, restricted to values 'SYS' and 'JSY'.
• CZ_MODEL_PROP_ENGTYP_COMPAT_V constrains results to signatures whose configuration engine type is compatible with the model.
• CZ_DEVL_PROJECTS anchors the model context through DEVL_PROJECT_ID, exposed as P_MODEL_ID.

Key Columns

• DETAILED_SIGNATURE_ID / DETAILED_SIGNATURE_TYPE / DETAILED_SIGNATURE_NAME — identify the signature node the property is attached to.
• SYS_PROP_NAME — the rule name representing the system property.
• SYS_PROP_TOKEN — derived from PRRUL.TEMPLATE_TOKEN; this is the template token the user searched for (sys_prop_token), identifying the property in template processing.
• SYS_PROP_RETTYPE_ID, SYS_PROP_RETTYPE_NAME, SYS_PROP_RETCOLL_FLAG, SYS_PROP_RETMUTABLE_FLAG — describe the return signature's type, collection flag, and mutability.
• SYS_PROP_RULE_ID, SYS_PROP_SIGNATURE_ID, SYS_PROP_SIGNATURE_NAME, SYS_PROP_SEQ_NBR — rule identity and property ordering.
• RULE_TYPE, RULE_TYPE_CODE, RULE_TYPE_LABEL — classify the property (SYS or JSY).
• PROPATTACH_SIG_NAME, PROPATTACH_SIGNATURE_ID — the node signature to which the property attaches.
• ALL_NUMERIC_SIGS_FLAG, INSTANCE_SET_FLAG, P_MODEL_ID — supporting flags and model identifier.

Common Use Cases and Queries

Typical scenarios include auditing system property definitions for a model, verifying return type and mutability behavior, and locating properties by their template token.

SELECT SYS_PROP_NAME,
       SYS_PROP_TOKEN,
       RULE_TYPE_LABEL,
       SYS_PROP_SIGNATURE_NAME,
       SYS_PROP_SEQ_NBR
  FROM APPS.CZ_SIGNATURE_SYSPROPS_V
 WHERE P_MODEL_ID = :model_id
 ORDER BY SYS_PROP_SEQ_NBR;

To resolve a specific token, filter on SYS_PROP_TOKEN = :sys_prop_token and inspect SYS_PROP_RETTYPE_NAME, SYS_PROP_RETCOLL_FLAG, and SYS_PROP_RETMUTABLE_FLAG. Because the definition is driven by profile- and model-compatibility logic (via FND_PROFILE and CZ_MODEL_PROP_ENGTYP_COMPAT_V), results should always be queried within an initialized EBS session so that profile-dependent engine-type resolution behaves correctly.