Validation rules and error messages
Validation is performed when you create or modify a validation rule. If validation fails,
the related error message is displayed, and the specified data is not saved.
The validation process verifies that all the required fields in the UI are populated. Else,
this message is
displayed:
This field is required.
This table list the error messages displayed for various validation failures:
Field | Validation Condition | Error Message |
---|---|---|
Name | Checks if the value is unique. | Cannot save Validation rule {0} because the name already exists. |
Name | Checks if populated. | Cannot save Validation rule {0}, Name is not specified. |
Enabled | Checks for possible values. | Validation rule "{0}" has an incorrect Enabled flag. Valid values are true or false. |
System | Checks for possible values. | Validation rule "{0}" has an incorrect System flag. Valid values are true or false. |
Record Source | Checks for possible values. | Cannot save Validation rule {0}, Record Source {1} is invalid. Possible values are ("Hold", “Reject”, “Warning”). |
Type | Checks for possible values when the target table is inbox table. | Cannot save Validation rule {0}, Type {1} is invalid. Possible values are (“CONSTANT”, “EXPRESSION”, “LOV”, “NOTNULL”, “REFERENCE”, “UNIQUE”, “CHILDREN”, “USERDATA”). |
Type | Checks for possible values when the target table is user data table. | Cannot save Validation rule {0}, Type {1} is invalid. Possible values are (“CONSTANT”, “EXPRESSION”, “LOV”, “NOTNULL”, “REFERENCE”, “UNIQUE”, “CHILDREN”). |
Column | Checks if a column is valid for the specified table. | Cannot Save validation rule {0}, Column {1} cannot be found in Table {2}. |
Column | Checks if populated, where Type = 'NOTNULL' | Cannot Save validation rule {0}, Column is required for type = Not Null. |
Condition | Checks that the logical (SQL) expression on the specified table is valid. | Cannot save Validation rule {0}, Condition {1} cannot be resolved. It must be a valid SQL expression on the specified Table. |
Constant value | Checks if populated, where Type = Constant. | Cannot Save validation rule {0}, Constant Value is required for type = Constant. |
Expression | Checks if populated, where Type = Expression. | Cannot save Validation rule {0}, Expression is not specified. |
Expression | Checks that the logical (SQL) expression on the specified table is valid. | Cannot save Validation rule {0}, Expression {1} cannot be resolved. It must be a valid SQL expression on the specified Table. |
List of Values Name | Checks if populated, where Type = List of Values. | Cannot Save validation rule {0}, List of Values Name is required for Type = List of Values. |
List of Values Name | Checks that the value is valid. | Cannot Save validation rule {0}, List of Values Name {1} cannot be found. |
Reference Constraint | Checks if populated, where Type = Reference. | Cannot save Validation rule {0}, Reference Constraint is required for Type = {1}. |
Reference Constraint | Checks if a parent is populated, where Parent Reference = Y. | Cannot save Validation rule {0}, Reference Constraint must be Parent reference = {1}. |
Reference Constraint | Checks that the value is valid and must be an active (Enabled = TRUE) Constraint in SCV. | Cannot save Validation rule {0}, Reference Constraint {1} cannot be found. |
Children Constraint | Checks if populated, where Type = Children. | Cannot save Validation rule {0}, Child Reference Constraint is required for Type = {1}. |
Children Constraint | Checks if a parent is populated, where Parent Reference = Y. | Cannot save Validation rule {0}, Child Reference Constraint must be Parent reference = {1}. |
Children Constraint | Checks that the value is valid and must be an active (Enabled = TRUE) Constraint in SCV. | Cannot save Validation rule {0}, Child Reference Constraint {1} cannot be found. |
Unique Constraint | Checks if populated, where type = Unique. | Cannot save Validation rule {0}, Unique Constraint is required for type = Unique. |
Unique Constraint | Checks if populated, where type = User Data. | Cannot save Validation rule {0}, Unique Constraint is required for type = User Data. |
Unique Constraint | Checks that the value is valid and must be an active (Enabled = TRUE) Constraint in SCV. | Cannot save Validation rule {0}, Unique Constraint {1} cannot be found. |