Oracle Financials Cloud General Ledger Validations
Validations enforce data integrity. The following validations run for Oracle Financials Cloud General Ledger applications.
In addition to these Oracle Financials Cloud General Ledger validations, system and generic validations are run on nodes, hierarchies, viewpoints, and properties in the application. See System Validations and Generic Validations.
Note:
For validations with a scope of Viewpoint in the table below, for hierarchy-set bound viewpoints the validation is run for the bound viewpoint.Validation Name | Description | Scope | Level |
---|---|---|---|
Duplicate (Shared Nodes) | A tree version contains a duplicate node at the leaf level but
Allow Duplicate Nodes is not
selected.
Note: Duplicate nodes at the rollup level are never allowed in Oracle Financials Cloud General Ledger applications. |
Viewpoint | Tree or Hierarchy Set |
Equivalent Nodes | Nodes with a Summary Flag set to False are not in at least one
location in all required related viewpoints. See Configuring Related Viewpoints.
Note: When you have a list viewpoint configured with several related hierarchy viewpoints, you must run this validation against the list viewpoint in order to see if the node is missing in any of the related hierarchy viewpoints. |
Related Viewpoints | Tree or Node Set |
Maximum Depth Check | Node cannot have a level greater than the Max Depth. If the Max Depth is -1 then the validation is not run. | Viewpoint | Tree or Hierarchy Set |
Maximum Length Node Name Text/Numeric | Node name exceeds the Maximum Character Length | Node | Value or Node |
Minimum/Maximum Node Name Text | Node name falls outside of the text range.
Note: Numeric names are allowed when the Value Type is text as long as a numeric value is entered as either the minimum or maximum values (or both). |
Node | Value or Node |
Minimum/Maximum Node Name Numeric | Node name falls outside of the numeric range.
Note: Text names are not allowed when the Value Type is numeric. |
Node | Value or Node |
Multiple Root Nodes | Multiple root nodes exist but Allow Multiple Root Nodes is not selected. | Viewpoint | Tree or Node Set |
Node Start / End Date | The End Date property is greater than the Start Date property for a node in a value set. | Node | Property |
Numeric Node Name |
|
Node | Value or Node |
Parent Summary Flag | The parent node must have the summary flag set to allow children. | Node | Tree or Hierarchy Set |
Summary Flag and Allow Posting Properties | Summary and Allow Posting properties are both enabled. Only one can
be enabled at a time.
If a node has children, Summary must be enabled. If Allow Posting is enabled, the node cannot have children. |
Node | Property |
Summary Node with Missing Children | A node marked as a summary node does not have at least one child in a hierarchy viewpoint. | Node | Tree or Hierarchy Set |
Tree Labels on Summary Node Only | A tree label exists on a node where the Summary Flag is not set to True. | Node | Property |
Uppercase Node Name | Name contains lowercase characters and Uppercase is selected. | Node | Value or Node |
Zero fill | Name contains fewer characters than the Maximum Character Length and Value Type is numeric or Zero Fill is selected. | Node | Value or Node |
Invalid Characters, First Characters, and Values for Oracle Financials Cloud General Ledger
When you register a Oracle Financials Cloud
General Ledger application, validations
for invalid characters, first characters, and values are automatically configured
for the Core.Name
property. For a list of these characters and
values, see Essbase Character and Word Limitations in
Implementing Enterprise Structures and General Ledger.
You can edit these values by editing the property parameters. For example, you can
add additional invalid characters or invalid first characters, such as
&
, by editing the property parameters on the
Core.Name
property for your application or node type. See
Editing Property Parameters.