获取ＥＢＳ登录用户的ＩＤ

--模拟用户登录，该用户ID为1010

 

  fnd_global.apps_initialize(user_id      => 1010,

 

                             resp_id      => 20420,

 

                             resp_appl_id => 1);

                             end;

 

--获取当时登录的用户的ID

 

DECLARE

 

  l_user_id       NUMBER := fnd_global.user_id;

  l_employee_name VARCHAR2(30);

 

BEGIN

 /* SELECT ppf.full_name

    INTO l_employee_name

    FROM per_people_f ppf,

         fnd_user     fu

   WHERE fu.user_id = l_user_id

     AND fu.employee_id = ppf.person_id;

     dbms_output.put_line(l_employee_name);*/－－注释部分为根据user_id得到对应的人员

     dbms_output.put_line(l_user_id);

END;

转载于:https://www.cnblogs.com/jasmine-001/p/5415807.html