Hi,

I am trying to create prompt "presentation variable" and insert under "default selection" the below SQL which should return the Rate amount

(in BIP i can see the value) ,but after insert the SQL to the prompt i didn't get any value , please advice?

SQL:

select gd.conversion_rate

from gl_daily_rates gd

where gd.conversion_type='Corporate'

and gd.from_currency='USD'

and gd.to_currency='TWD'

and gd.conversion_date=TO_DATE('21-01-2024','DD-MM-YYYY')

Prompt :

result :"test" field is null.