I have subscribed a seeded business event 'oracle.apps.po.rcv.rcvtxn' and attached my custom code.
I have to use fnd_global.apps_initialize but when I am picking up the values from fnd_profile.value('USER_ID') etc... its not working.
Please suggest how can I use fnd_global.apps_initialize, from where can I pick the usei id , application id, resp id values?
There are many places telling how to get the parameters for fnd_global.apps_initialize, like http://orclpps.blogspot.com/2007/12/fndglobalappsinitialize-for.html
Now, to check the current session user you can simply use FND_GLOBAL.user_name. for instance
if FND_GLOBAL.user_name='SYSADMIN' then
Hope this helps.
Business Event is not taking values from fnd_profile.value('USER_ID');
If I am hardcoding the values like below:
fnd_global.apps_initialize ( user_id => 1864
,resp_id => 20634
,resp_appl_id => 401); */
Then Business event is working fine.
But when I am getting the values of user_id , resp_id and resp_appl_id from FND_PROFILE.VALUE then it is not working.