0 Replies Latest reply on Dec 28, 2012 4:43 PM by 982073

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


      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.