Hi,
There is a difference in how the BR report is executed when the parameter value in entered manually and selected from LOV.
Selecting from LOV

Typing manually

This happens for both ‘Year’ and ‘Month’. They are of number type. But this is how the queries are formed.

using to_char() or to_number() in advanced filter criteria didn’t work.
Converting the field in the IAL using to_char() also didn’t work.
Is there any other way to resolve this?
Best Regards,
Nisansala