To implement business policies and practices, you can build data validation rules that are checked when conditions are met in forms. Validation messages can be generated if entered data violates validation rules. You can also build limits on submitted planning unit data using validation rules, and designate a reviewer, owner, or notifier to review data that meets some condition.
For example, data validation can ensure that a department’s capital expenses adhere to company policies by preventing planners from submitting budgets that contain capital expenditures that fall outside the company’s guidelines. Sample scenarios that can be addressed using data validation rules are described in Data Validation Rule Scenarios.
Defining data validation rules involves these main tasks:
Identifying the data cells or location that you want to display with validation messages or in different colors when conditions are met.
Identifying the cells that need to participate during rule evaluation, and defining the rule accordingly.
Creating the data validation rule at the location identified, as described in this topic.
Watch this video to learn about building validation rules and processing cells in Planning.
To create and update validation rules:
Select Administration, then Manage, and then Forms and Ad Hoc Grids. Create or edit a form, and then click the Layout tab in the Form Management page.
In the Layout tab, right-click the grid, row heading, column heading, or cell for which you want to add or update the validation rule.
Note:
When you hover the cursor over cells in the Layout tab, a context menu displays whether the cell contains a validation rule. To view the validation message, select Show Data Validation Messages. The context menu also displays when a single cell is selected.
To add a rule, click Add Rule and enter a name and description for the rule.
If necessary, move the rule by selecting an option from Location. To create a rule similar to an existing rule, click Duplicate and then update the rule. To view rules, click View Rule. See Viewing Data Validation Rules.
Under Condition, click
and select an option to begin the condition statement: If, Else If, Else, Then, Check Range, or Range.The first part of a rule must include an If condition. Rules must also contain some form of Then condition. See Conditions Supported by the Rule Builder.
From Source Type, select an option for evaluation by the rule.
The Source Type list displays the appropriate options for the Condition. For example, If conditions can include Current Cell Value, Cell Value, Column Value, Row Value, Member Name, Member, Cross-Dim Member, Account Type, Version Type, Var Reporting Type, UDA, or Attribute. For detailed information about each type of condition, see Conditions Supported by the Rule Builder.
If applicable for the selected Source Type, enter a value in Source Value by clicking
to select an option, or 
to enter a free form value.Select the appropriate operator for the evaluation: =, !=, <, <=, >, >=, Equals, Not Equals, Contains, Starts With, or Ends With, In, or Not In.
For examples, see Data Validation Conditional Operators.
Select an option for the appropriate Target Type for the rule.
Update conditions by clicking an icon in the Actions area on the right side of the condition builder:
Add a condition next to the current row.
Delete a condition at the current row.
Select conditions or condition blocks to update.
To update condition blocks, click an icon in the Condition area, at the top of the condition builder:
Add a condition block within the validation rule starting with If. You can expand or collapse the condition. See Conditions Supported by the Rule Builder.
Delete the selected condition block.
Delete selected conditions, and copy them to paste in a new location.
Copy selected conditions.
Paste selected conditions to a new location.
Group the selection within a condition, and add a grouping parenthesis. In addition to groupings that you set, the If statement in the grouping block is grouped when a condition is grouped, and the Custom Grouping option is enabled.
Ungroup the selected conditions. The grouping parentheses are removed from the selected condition. One grouping is removed from the condition each time Ungroup is selected.You can also set your own grouping for conditions by selecting Custom Grouping, then setting up the grouping in the rule definition area.
Selected conditions are displayed as shaded. To clear selected conditions, click once more to the left of the Condition column.
Click the Process Cell icon
in the rightmost column to add processing instructions. When you are ready to enable the rule to make it available in the form, select Enable Validation Rule.
When you finish updating the rule, validate the rule.
Click Validate.
The validation status displays at the top of the dialog box. You must correct errors before you save changes. If you close the dialog box without validating rules and fixing errors noted during validation, updates are not saved.
After fixing any errors noted during validation, ensure that Enable Validation Rule is selected above the rule definition area to enable the rule for the application.
Optional: In the Form Management page, view and update rules.
In the Validation Rules pane on the right side of the Form Management page, add, edit, or delete rules by clicking
, 
, or 
.To view rules at the current level or higher, click in the Manage Form page, and then select an option from the Validation Rules drop-down list.
If multiple rules are defined at the same location, you can change the order in which rules are processed when rules have the same precedence. To move a rule up, down, or to the top or bottom of the list, select the rule and click the arrows. See Order of Evaluation and Execution for Data Validation Rules.
To prevent validations associated with the form from executing when validating the planning unit if the currently logged in user does not have access to the form, select Validate only for users with access to this form.
In the Form Management page, preview and validate the form, resolve any validation errors, and then save changes.
For forms that have data validation rules enabled, rules are validated when the form is loaded or saved. Data validation rules are saved when the form is saved. See Creating Simple Forms.
When users open the form, they can view and resolve validation messages using the Data Validation Messages pane. See Working with Planning for Oracle Planning and Budgeting Cloud Service.