Oracle Reports Parameter

[lasd]

Hi
Hope someone can help me here. I am currently working on a report. I am trying to add a parameter for flr.last_used to my report. Below is my sql code and i was going to do it like this but it isn't working. no errors come up but it doesn't give back any information. it blocks all the info.

flr.last_used = _last_used

In reports there the parameter is defined having the value set FND_DATE. should i be using a different value set.


select flr.last_used last_used
from (select ls.user_id user_id,
lr.responsibility_id responsibility_id,
max(greatest(lr.start_time,nvl(lr.end_time,lr.start_time))) last_used
from fnd_logins ls,
fnd_login_responsibilities lr
where lr.login_id = ls.login_id
group by ls.user_id, lr.responsibility_id) flr

where flr.user_id (+) = ur.user_id
and flr.responsibility_id (+) = ur.responsibility_id

hope you can help
kindest regarsd

lasd

 

[lewisp]

You have flr.last_used in your SELECT but not in your WHERE. How exactly are you trying to use this parameter?

If you have added it to the WHERE clause, do you supply the correct date format for the parameter?

If so, you may need to use TRUNC() on your dates.