Forum Stats

  • 3,759,183 Users
  • 2,251,510 Discussions
  • 7,870,526 Comments

Discussions

Set Apps Initialize

SELECT USER_ID,

RESPONSIBILITY_ID,

RESPONSIBILITY_APPLICATION_ID,

SECURITY_GROUP_ID

into

lv_user_id,

lv_resp_id,

lv_resp_app_id,

lv_sec_grp_id

FROM

FND_USER_RESP_GROUPS

WHERE USER_ID = ( SELECT USER_ID

FROM

FND_USER

WHERE USER_NAME like '<USERNAME>')

AND RESPONSIBILITY_ID = (SELECT RESPONSIBILITY_ID

FROM

FND_RESPONSIBILITY_VL

WHERE

upper(RESPONSIBILITY_KEY) like upper('<Responsibility key>'));





Fnd_Global.Apps_Initialize(lv_user_id, lv_resp_id, lv_resp_app_id, lv_sec_grp_id);