HI all

(this is IFS2003 - I know, I know...)

I recall someone long ago creating a Saved query that could be shared amongst our users, that looked for (say) Approvals for that user. The dynamic code meant it could be passed around without need to change the Advanced query.

For instance, instead of USERID  = ‘BLOGGSF’,

I thought we could use USERID = (select Ifsapp.fnd_session_api.get_fnd_user()from dual)

but this generates the error “fnd_session_api is not a procedure or is undefined”

How can I get this to work, or is there an alternative?

Would be good to do this for PersonId too.

Thanks