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

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.