|
|
| Re: Calling Journal Import Program thru Plsql Procedure [message #327822 is a reply to message #327338] |
Wed, 18 June 2008 02:15  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
| Quote: | SELECT fnd_profile.VALUE ('USER_ID'), fnd_profile.VALUE ('RESP_ID')
INTO x_user_id, x_resp_id
FROM DUAL;
fnd_global.apps_initialize (x_user_id, x_resp_id, x_appl_id);
|
to set fnd_global.apps_initialize you are using fnd_profile.VALUE!!!!!!
fnd_profile.VALUE won't be giving value, until you set fnd_global.apps_initialize.
You need to get the values of user_id and resp_id from normal sql's select user_id from fnd_user
where user_name = '&user';
select responsibility_id,application_id from fnd_responsibility_vl
where responsibility_name = '&resp_name';
By
Vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
