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 22.214.171.124.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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document