Planning and FreeForm Validations
Validations ensure data integrity. The following validations run for Planning, FreeForm, and Planning Modules applications.
Name | You'll Get a Validation Error If | Level |
---|---|---|
Name Uniqueness |
Member name is not unique across all nodes used in an application |
Application |
Member Name |
Member name is the same as a dimension name, a cube, or an attribute dimension defined for the current application |
Member |
First Character |
Name and Alias use specific characters as the first character |
Member |
Invalid Characters |
Name and Alias use specific invalid characters |
Member |
Max Length |
Name and Alias exceed the maximum length |
Member |
Leading or Trailing Spaces |
Name and Alias have leading or trailing spaces |
Member |
Reserved Words |
Name and Alias match any of a list of reserved words defined for the application |
Member |
Alias Uniqueness |
Alias are not unique among a group of sibling nodes |
Dimension |
Shared Members |
Shared members are not in the same dimension |
Dimension |
Shared Member before Base Member |
Shared members appear above base members in a hierarchy | Dimension |
Ownership Approval Permission |
An ownership approval property for a node refers to a user who does not have at least Participant (Read) access to the viewpoint. See Understanding Ownership Approvals. This validation is disabled by default. |
Dimension |
Plan Types |
Plan Type is set to True but the parent does not have a True value Note: This validation is skipped if the parent is a predefined member. |
Dimension |
Data Storage |
Default Data Storage is Shared or Label Only but Data Storage for cube is not Shared or Label Only Note: This is not checked if the member is not in the cube. |
Property |
Exchange Rate Type |
Exchange Rate Type is not None and Data Type is not Currency |
Property |
Formula Allowed |
Data Storage is not Dynamic Calc or Dynamic Calc and Store |
Property |
Smart List Required |
Smart List is missing for member if Data Type is Smart List |
Property |
Solve Order |
Solve Order is not within the minimum and maximum values for the property |
Property |
Source Plan Type |
Source Plan Type is not a valid Plan Type for the member |
Property |
Variance Reporting |
Variance Reporting is not Expense when Account Type is Expense or Variance Reporting is Non-Expense if Account Type is anything other than Expense or Saved Assumption. |
Property |
Numeric Attribute Name |
Bottom level node names in a numeric attribute dimension are not in numeric format |
Property |
Date Attribute Name |
Bottom level node names in a date attribute dimension are not in |
Property |
The following validations run for Planning Modules applications only.
Name | You'll Get a Validation Error If | Level |
---|---|---|
Predefined Member Edit |
An action other than a move is performed on a predefined member |
Node |
Predefined Member Property |
Predefined Member property is modified |
Property |
Note:
In Planning Modules applications, most application-specific validations are not run against predefined members (that is, nodes with PLN.Enterprise Predefined Member set to True), because these members are imported from the external application and are not able to be edited in Oracle Enterprise Data Management Cloud.
The only application-specific validations that are run against predefined members in Planning Modules applications are the Predefined Member Edit, Predefined Member Property, and Alias Uniqueness validations.
Note:
The Source Plan Type, Formula Allowed, and Plan Type validations are not checked on shared nodes (Data Storage = shared). The imports and exports at the application level transform these values as required by Planning and Planning Modules.