Cross Validation Rule Does Not Recognize Hierarchy Operator Is Descendent Of (Doc ID 1543931.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

Create a cross validation rule (CVR) that uses a condition filter of a single value and a validation filter with operator "is descendent of" another segment.
The rule is preventing the creation of account combinations that do not violate the rule, i.e., of account combinations that use a child value of the segment that is specified in the rule definition.

It appears the Is descendent Of operator is not working as expected.
The combinations using child values that meet the rule should be created successfully.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Define a hierarchy for the segment of interest.
2. Validate and activate the tree code.
3. Flatten the row and column for the tree code.
4. Associate the tree code to the segment definition.
5. Deploy the flexfield
6. Define the cross validation rule
7. Try to create an account combination that violates the rule and the CVR error message appears as expected.
8. Try to create an account combination that does not violate the rule and the CVR error message still appears. This is not expected.

Cause

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