在客户端取profile value:

BEGIN
  fnd_global.APPS_INITIALIZE

    (user_id => 1110 , -- 要取的profle对应的user

     resp_id => 50321, -- 要取的profle对应的职责

      resp_appl_id =>101 -- 要取的profle对应的application

        );
END;

select FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME') from dual;

Application context related APIs. The server-side package FND_GLOBAL returns the values of system globals, such as the login/signon or "session" type of values. You should not use FND_GLOBAL routines in your forms (that is on the client side). On the client side, most of the procedures in the FND_GLOBAL package are replaced by a user profile option with the same (or a similar) name. You should use FND_PROFILE routines in your forms instead.

select FND_PROFILE.value('USER_ID') from dual

-- VALUE - returns the value of a profile options

如果前面有设   fnd_global.APPS_INITIALIZE 能取到user id,

也可以用select fnd_global.user_id, FND_GLOBAL.resp_id, FND_GLOBAL.resp_appl_id from dual

但是用，select FND_PROFILE.VALUE_SPECIFIC('USER_ID') from dual

-- VALUE_SPECIFIC - Get profile value for a specific user/resp/appl combo

取不到user_id

但是设的相应的profile value可以通过该方法取得

如： select FND_PROFILE.VALUE_SPECIFIC('GL_SET_OF_BKS_NAME',null,50322,101) from dual

可以取得，设的特定的profile value.

select * from   fnd_profile_option_values

这个表里存放具体profile option 的value。

其中level_id 标识，该profile option是设在那个层级下的，level_value是这个层级对应的id：

LEVEL_ID = 10001, site 级，level_value 全部为0，不使用；
LEVEL_ID = 10002, application级，level_value = application_id
LEVEL_ID = 10003,  responsibility级， level_value = responsibility_id
LEVEL_ID = 10004,  user级， level_value = user_id