原型：fnd_global.apps_initialize(user_ID, Responsibility_id,
Responsibility_application_id);
作用：在数据库的会话中设置全局变量，和用户概要信息。
首先找到三个参数的值：
user_id ,resp_id ,resp_appl_id
select user_id from fnd_user where user_name ='yourusername'
select RESPONSIBILITY_ID,APPLICATION_ID from fnd_responsibility where RESPONSIBILITY_KEY=yourrespkey ;
然后：执行
BEGIN
fnd_global.APPS_INITIALIZE(user_id => youruesr_id ,esp_id => yourresp_id,resp_appl_id =>yourresp_appl_id);
END;
这样就可以得到值正确的值了:
select fnd_profile.value('GL_SET_OF_BKS_ID') FROM DUAL;
参数获得：
参数一，用户号
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%';
参数三，代表该职责所属的应用程序(application)的编号
上面的SQL取得
运行:
BEGIN
fnd_global.APPS_INITIALIZE(youruesr_id, yourresp_id, yourresp_appl_id);
END;
测试：
select fnd_profile.value('GL_SET_OF_BKS_ID') FROM DUAL;
fnd_profile.value('USER_ID') --对应刚才的user_id
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11536986/viewspace-620038/ ，如需转载，请注明出处，否则将追究法律责任。
