Oracle Financials Cloud General Ledger Validations
Validations enforce data integrity. The following validations run for Oracle Financials Cloud General Ledger applications.
| Validation Name | You'll Get a Validation Error If | Level |
|---|---|---|
| Account Type Required | The Account Type property is blank for a node in a natural account segment. | Property |
| 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. |
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. |
Tree or Node Set |
| Max Depth Check | Node cannot have a level greater than the Max Depth. If the Max Depth is -1 then the validation is not run. | Tree or Hierarchy Set |
| Max Length Node Name Text/Numeric | Node name exceeds the Maximum Character Length | Value or Node |
| Min/Max 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). |
Value or Node |
| Min/Max Node Name Numeric | Node name falls outside of the numeric range.
Note: Text names are not allowed when the Value Type is numeric. |
Value or Node |
| Multiple Root Nodes | Multiple root nodes exist but Allow Multiple Root Nodes is not selected. | Tree or Node Set |
| Node Name Unique in Value Set | The name of a node is not unique in a value set. | Value Set or Dimension |
| Node Name Invalid Characters | Node name uses specific invalid characters. See Naming Conventions for Essbase.
Tip for
Implementers: You can add additional invalid characters or
invalid first characters, such as |
Value or Node |
| Node Name Invalid Keywords | Node name uses specific invalid keywords. For the full list, see Naming Conventions for Essbase. | Value or Node |
| Node Start / End Date | The End Date property is greater than the Start Date property for a node in a value set. | Property |
| Numeric Node Name |
|
Value or Node |
| 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 |
| Parent Summary Flag | The parent node must have the summary flag set to allow children. | 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. |
Property |
| Summary Node with Missing Children | A node marked as a summary node does not have at least one child in a hierarchy viewpoint. | Tree or Hierarchy Set |
| Tree Label on Summary Node Only | A tree label exists on a node where the Summary Flag is not set to True. | Property |
| Text Uppercase | Name contains lowercase characters and Uppercase is selected. | Value or Node |
| Zero fill | Name contains fewer characters than the Maximum Character Length and Value Type is numeric or Zero Fill is selected. | Value or Node |