Unable to Use Independent Valuesets in Contract Expert Questions (Doc ID 2072631.1)

Last updated on DECEMBER 07, 2015

Applies to:

Oracle Procurement Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : R12.X version, Contract Expert

When attempting to create and save a contract expert question, using Response type "List of values" and an Independent Value Set,
the following error is encountered:

ERROR
-----------------------
Query used for valueset PO_FROM_RECEIPT_OR_PO is invalid.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Contract terms library administrator > Contract Expert > Questions
2. Create question
3. Response Type: List of values
4. Value Set: PO_FROM_RECEIPT_OR_PO
5. Intent: Buy
6. Click on Apply and receive the error
It does not error out if the value set validation type is not Independent

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