前台
Help->diagnostics->examine
Block->$PROFILES$
Field->USER_ID(RESP_ID,RESP_APPL_ID)
查看对应value值
后台
原型:fnd_global.apps_initialize(user_id => 1007906,
resp_id => 50559,
resp_appl_id => 222);
resp_id => 50559,
resp_appl_id => 222);
作用:在
数据库的会话中设置全局变量,和用户概要信息。
参数获得:
参数一,用户ID
select user_id
from fnd_user
where user_name like '%OPERATIONS%'; -- ID of OPERATIONS:1318
参数二,职责编号(responsibility id)
select RESPONSIBILITY_ID, APPLICATION_ID, RESPONSIBILITY_KEY
from fnd_responsibility
--where APPLICATION_ID = 140
where RESPONSIBILITY_KEY like '%ASSETS_VISION_OPERATIONS%';
from fnd_responsibility
--where APPLICATION_ID = 140
where RESPONSIBILITY_KEY like '%ASSETS_VISION_OPERATIONS%';
参数三,代表该职责所属的应用程序(application)的编号
上面的
SQL取得