How to set default value for an attribute in EO
GouthamMar 13 2012 — edited Mar 13 2012Hi,
I want to set the default value for the attribute StatusID in RequestEO but this attribute have its foreign key to LookupValueBaseEO, so i want to set LookupValueID of LookupValue= 'REQUEST_FOR_APPROVAL' as my default value.
This is my query to fetch lookupvalueid from database "select lookup_value_id from vik_lookup_value_b where lookup_value='REQUEST_FOR_APPROVAL'"
Is there any way to pass default value using Sql expression ?
My Jdeveloper version is 11.1.2.1.0