0 Replies Latest reply: Dec 28, 2012 10:43 AM by 982073 RSS

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

    982073
      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