when using FND_FLEX_FIND.QUERY_KFLEX_RANGE in pre-query it gives error unable to perform query
hi am using FND_FLEX_FIND.QUERY_KFLEX_RANGE in custom form to open the range of KFF
as in document followed the steps
in the query Find
SYNCHRONIZE;
fnd_flex_find.find_kflex_range('SQLGL', 'GL#',
v_num,
'acc_num',
other_tokens=>'TITLE="' || 'Chart of Accounts' || '"');
and in
FND_FLEX_FIND.QUERY_KFLEX_RANGE('SQLGL', 'GL#', v_num,
:PARAMETER.acc_num_low,
:PARAMETER.acc_num_high,
'budgetDetail.Acc_num')
so when query it gives error unable to perform query and the query end in acc_id in (select code_combination_id)
so is there something missing or it can't be used in custom forms?