4 Replies Latest reply on Nov 19, 2013 12:39 PM by Sant Jose-Oracle

    How can I get the ENTERPRISE_ID of the logged in user?

    Sant Jose-Oracle

      Hi,

       

      Is there a PL/SQL function that I could use to get the ENTERPRISE_ID of the logged in user so that I can use it in a report query for example as below.

       

      SELECT package.function

      FROM DUAL;

       

      'package.function' should be able to return the ENTERPRISE_ID of the logged in user.

       

      Regards,

      Santhosh Jose