关于在oracle客户端正确取道PROFILE值的解决办法:fnd_global.APPS_INITIALIZE的说明
首先找到三个参数的值:
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 ,resp_id => yourresp_id,resp_appl_id =>yourresp_appl_id);
END;
这样就可以得到值正确的值了:
select fnd_profile.value('GL_SET_OF_BKS_ID') FROM DUAL;
OU初始化
/*BEGIN
fnd_client_info.set_org_context(236);
END;*/