4 Replies Latest reply: Nov 19, 2013 6:39 AM by Sant Jose-Oracle RSS

    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