This discussion is archived
0 Replies Latest reply: Dec 28, 2012 8:43 AM by 982073 RSS

How to pass USER_NAME system variable as parameter for Omniportlet SQL type

982073 Newbie
Currently Being Moderated
Hello,

I am having a bit of trouble figuring out how to pass the USER_NAME system variable (##OP_USER_NAME##) as a parameter to an omniportlet sql type that I'm trying to build.
For example for the query :
select fnd.user_id
from fnd_user fnd
where fnd.username = {not sure what to put here}

I've tried several other methods such as setting the page parameter first and using bind variables to no avail. Perhaps I am missing a few steps. A quick walkthrough on how to accomplish this would be most appreciated. I have tried following previous threads but have had no success.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points