Technology Stack - EBS (MOSC)

MOSC Banner

when using FND_FLEX_FIND.QUERY_KFLEX_RANGE in pre-query it gives error unable to perform query

edited Aug 20, 2021 10:54AM in Technology Stack - EBS (MOSC) Question

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center