Creating SCV validation rule

  1. Select Configuration > SCV > Validation > Rules. The Rules window is displayed.
  2. Click New. The SCV Validation Rule window is displayed.
  3. Specify this information on the Details tab:
    Name
    A unique name of the validation rule.
    Note: You cannot modify this value after the validation rule is created.
    Description
    The description of the SCV validation rule.
    Table
    The name of the SCV Inbox and Planning Configuration table for which the Validation Rule is defined.
    Record Status
    Indicates the action to be performed for the validated record if the validation rule fails. Possible options:
    • Reject
    • Hold
    • Warning
    Enabled
    Indicates the current status of the validation rule. Possible values:
    • On: Active
    • Off: Inactive
    Note: 
    • By default, the value is set to On.
    • The enabled validation rules are only applicable for the corresponding tables or columns.
    System
    Indicates if the validation rule is system defined or user defined.
  4. Specify this information on the Rule tab:
    Type
    Indicates the type of the validation rule. Possible values:
    • Constant
    • Reference
    • LOV
    • Not Null
    • Unique
    • Expression
    • User Data
    • Children
    Note: User Data is available only when the target table is Inbox table.
    Column
    The column for which the validation rule is defined. The possible values are retrieved from column names of the specified Table in the Details tab.
    Note: 
    • The possible values are retrieved from the columns name of the specified Table in the Details tab.
    • If this value is not specified, the validation rule is applicable for the record (row). For example, Reference, Children, and Unique type validations are applicable at record level.
    Condition
    A valid SQL logical expression for the specified Table in the Details tab to determine whether the validation rule is to be executed.
    Note: 
    • If the logical expression is evaluated as True, the validation rule must be executed.
    • If the logical expression is evaluated as False, the validation rule must not be executed. The validation rule is returned as successful.
    Constant Value
    Indicates the constant value to be used to validate the value of the specified column.
    Note: You must specify this value if Type is set to Constant.
    Expression
    Indicates the logical expression to be used to validate the value of the specified column or record.
    Note: You must specify this value if Type is set to Expression.
    List of Values Name
    Validates the value with a list of possible values for the specified column.
    Note: You must specify this value if Type is set to LOV.
    Reference Constraint
    Indicates the foreign key constraint to be used to identify the referenced table and columns. This field lists the specified Constraints in SCV that are enabled.
    Note: 
    • The possible values are retrieved from the Constraints (enabled) defined in SCV.
    • You must specify this value if Type is set to Reference.
    Reference Validation Status
    Indicates the validation status of a referenced record to mark the check box as valid. Possible values:
    • Valid
    • Reject
    • Warning
    • Hold
    • Select All
    Note: 
    • You must specify the Reference Validation Status if you select the validation rule Type as Reference.
    • If the validation status is specified, the validation process verifies that the referenced record exists, and the validation status belongs to the specified values.
    • If the validation status is not specified, the validation process only verifies that the referenced record exists.
    Child Reference Constraint
    Indicates the child table and columns to be used between the specified table and the child table. This field lists the FK constraints that are Enabled and marked as "parent reference" from any child table.
    Note: 
    • The possible values are retrieved from active FK constraints that are marked as ‘parent reference’ in a child table and pointing to the target parent table specified in this rule.
    • You must specify this value if Type is set to Children.
    • The child table and the columns can be identified for validation using this Constraint in the reverse direction.
    Unique Constraint
    Indicates the primary or unique key constraint to be used for identifying the unique key columns. This field lists the unique constraints that are Enabled on the selected table.
    Note: 
    • • The possible values are retrieved from a list of unique constraints (PK or UK constraint) that are active on the specified Table.
    • You must specify this value if Type is set to Unique or User Data.
  5. Click Save. A new SCV validation rule is created after the successful validation of the specified information.
    Note: An error message is displayed, and the data is not saved if validation errors occur.
You can use this page to:
  • Create a duplicate of the existing SCV validation rule and modify the parameters as required using the Duplicate option.
  • Delete SCV validation rule using the Delete option.