Provide Support for Table Validated Value Sets in User Defined Variables in the Contract Expert (Doc ID 2881347.1)

Last updated on JULY 05, 2022

Applies to:

Symptoms

Contract Expert Rule Activation is raising an Error due to using a Table Validated Value Set.

ERROR
Variable pto_option_classes_v0 has invalid query for valueset XXIT_OPTION_CLASSES

STEPS
1. Create Table Validated Value Set sourced from mtl_system_items_b
2. Create User Defined Variable and SAVE
3. Assign Value Set from Step 1 to the user defined variable and SAVE
4. Create Rule
5. Add Variable from Step 2 as a Rule Condition
6. Select Logical Operator For Condition
7. Select 2 Records to ADD
8. Save Rule
9. Activate Rule
10. Receive the indicated error.

Changes

Cause

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