--模拟用户登录,该用户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;
原标题:获取EBS登录用户的ID
关键词:登录