Issues with trying to define a Context Sensitive DFF with a value-set that has Validation type of Table (Doc ID 1485288.1)

Last updated on JULY 07, 2014

Applies to:

Oracle Fusion Applications Common Components - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

Trying to define a Context Sensitive DFF with a value-set that has Validation type of Table, Now as part of making the value set table-validated, We have to select the Value Data Type of the value-set as 'Number' since the Value Column Type of the Value Column Name selected in the definition is 'Number', However when we define a Context Sensitive DFF and try to refer to this value-set, it does not appear in the list of values. Only those value-sets that have Value Data Type of 'Character' not 'number', appear in the LOV, Now given the table value column name we are referring to in our value-set definition, We have to select the value data type as 'Number'.
(See attached Screenshots)
 

Solution

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