My Oracle Support Banner

Cross Validation Rule Using Parent Values Not Allowing To Create Account Combination (Doc ID 1469573.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion General Ledger - Version and later
Oracle Fusion General Ledger Cloud Service - Version and later
Information in this document applies to any platform.


A cross validation rule (CVR) was defined using a parent value and a hierarchy operator like 'Is a child of' or 'Is descendant of' in the validation.
When entering a new combination using a child value, the cross validation error message fires and does not allow the account combination to be entered.

An example of the cross validation rule defined is:
 Name: XX - CO-1003
 Description: XX - Validation for Company 1003 Cost Centers
  Condition details: Company Equals to 1003
  Validation details: CostCenter Is a child of P1003
  Error Message: XX - The Cost Center entered is not valid for Company 1003

Expect the account combination to be created successfully since the child value is part of the hierarchy.

The issue can be reproduced with the following steps:
1. Define a hierarchy for a segment
2. Validate, activate and flatten the tree version.
3. Define a cross validation rule.
4. Try to enter a combination that should pass the validation. Instead the cross validation error message comes up.

Additionally when trying to edit the CVR a Remote Region error appears on the screen preventing the rule from being edited or deleted.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.