21 Understanding Validations and Constraints

Validations and constraints preserve data integrity and enforce business logic in Oracle Enterprise Data Management Cloud.

There are three types of validations that run in Oracle Enterprise Data Management Cloud:

  • System Validations: General system checks. For example, a validation checks to see if you're trying to create a node type that already exists. For a list of system validations, see System Validations. System validations are enforced on all data, and you cannot disable them.

  • Application-specific Validations: Validations that are specific to an external application such as Planning. Application-specific validations are enforced on all bound data in a dimension, but you can disable them at the dimension level. See Managing Enforcement of Application-Specific Validations.


    To preserve data integrity, application-specific validations run for data objects with these binding statuses. See Binding Status.
    • Bound viewpoints run all application-specific validations.
    • Hierarchy viewpoints that are node set bound or hierarchy set bound run all application-specific validations.
    • Hierarchy viewpoints that are node type bound run these validations:
      • All node type-level (such as property validations) and application-level validations (such as name uniqueness) are run.
      • Structure-based validations (such as parent-child validations) are run on the hierarchy set in the viewpoint. These validation results may be different from the bound hierarchy set.
    • List-type viewpoints that are node type bound run all application-specific validations except structure-based validations (such as parent-child validations).
  • Custom Validations: User-created validations to enforce business logic that is unique to a specific implementation. See Working with Custom Validations.

Constraints check for specific conditions (such as name uniqueness) that can go across node types and dimensions in an application. For example, a constraint could enforce node name uniqueness at the application level, as opposed to a custom validation that runs on nodes for specific node types or hierarchy sets only. They are similar to application-specific validations, but you can configure the application or dimension that they apply to and you can add them to Universal applications. See Working with Constraints.

Validations and constraints run when you:

  • Import data from an external application

  • Export data to an external application, if Validate before Export is set to Warn or Abort. See Managing Export Options.

  • Manually enter changes in a viewpoint

  • Load a file with request changes to a viewpoint

  • Validate a request item

  • Validate a request

  • Validate a viewpoint