Issues with trying to define a Context Sensitive DFF with a value-set that has Validation type of Table
Last updated on JULY 07, 2014
Applies to:Oracle Fusion Applications Common Components - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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)
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