Financial Consolidation and Close Validations

Validations ensure data integrity. The following validations run for Financial Consolidation and Close 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
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
Default Movement Level	The Default Movement property is defined on a node other than a bottom level node	Property
Is Default Movement Level	The Is Default Movement property is defined on a node other than a bottom level node	Property
Is Default Movement Ancestor	The Is Default Movement property is defined on a node that is not a descendant of FCCS_Mvmts_Subtotal	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 mm-dd-yyyy format	Property

Note:

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 are the Predefined Member Edit, Predefined Member Property, and Alias Uniqueness validations.