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.