Technology Stack - EBS (MOSC)

MOSC Banner

Form Personalisation; Using fnd_lookup in CONDITION

edited Aug 20, 2021 10:49AM in Technology Stack - EBS (MOSC) 4 commentsAnswered
Hi All,

Is it possible when creating a forms personalisation to use a select query in the CONDITION section of the form.

For instance, this is what i am wanting to do:

${item.inv_sum_folder.vendor_name.value} not in (select lookup_code from fnd_lookup_values where lookup_type = 'INV_EVAL_NOT_REQUIRED')
and ${item.inv_sum_folder.vendor_id.value} is not null
and ${item.inv_sum_folder.attribute12.value} is null
and ${item.inv_sum_folder.attribute13.value} is null
and ${item.inv_sum_folder.approval_status_display.value} != 'Cancelled'

I've validated the code within the form, and it validates, but it isn't working.

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