初始化

 

 关于在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;*/