EBS fnd_global.apps_initialize的使用

型：fnd_global.apps_initialize(user_ID, Responsibility_id,

                                          Responsibility_application_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%';

参数三，代表该职责所属的应用程序(application)的编号

上面的SQL取得

方便的方法：Help->Diagnostics->Examin, Block: $PROFILES$, Field: RESP_ID(以及其他的)

运行:
BEGIN
fnd_global.APPS_INITIALIZE(youruesr_id, yourresp_id, yourresp_appl_id);
END;

测试：

select fnd_profile.value('GL_SET_OF_BKS_ID') FROM DUAL;

select fnd_profile.value('USER_ID') from dual; --对应刚才的user_id

转载于:https://www.cnblogs.com/gutirez/archive/2011/02/21/1959543.html