Uncertain Condition In Excel Rule Table Does Not Return The Conclusion But Returns Uncertain

(Doc ID 2116463.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Policy Modeling - Version 10.4.4.21.0 and later
Information in this document applies to any platform.

Symptoms

Customer having an issue with Uncertain condition in Excel Rule Table that does not return the conclusion, but returns uncertain

Description:
A value list is displayed in the interview where users could leave the attribute uncertain (blank).
Need to add this uncertain value in Excel rule table to return a conclusion.


Updated the Excel rule table of the example project "HealthyEating" as below:

the number of servings of grains the child eats per day conclusion the child's assessment for grains consumption the child's star rating for grains consumption
< 6 the child needs to eat more grains Too Low 0
< 11 the child’s intake of grains is acceptable Excellent 1
uncertain the child’s intake of grains is acceptable Excellent 1
else the child is consuming an excessive amount of grains Too High 0

But when the condition "the number of servings of grains the child eats per day " is "uncertain" the conclusions return "uncertain".
Expectation is to return the above conclusions (the child’s intake of grains is acceptable , Excellent, 1)

Moreover, if the condition value is "uncertain", the conclusion does not even jump to the "else" case, so that's why added the condition value "uncertain" in the column condition "the number of servings of grains the child eats per day".

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms