Home » Applications » Oracle Fusion Apps & E-Business Suite » Calling Journal Import Program thru Plsql Procedure (11.5.10)
Calling Journal Import Program thru Plsql Procedure [message #327338] Mon, 16 June 2008 02:45 Go to next message
Messages: 19
Registered: February 2008
Junior Member
Here is the Procudure For calling Journal import Program.
Re: Calling Journal Import Program thru Plsql Procedure [message #327822 is a reply to message #327338] Wed, 18 June 2008 02:15 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
SELECT fnd_profile.VALUE ('USER_ID'), fnd_profile.VALUE ('RESP_ID')
INTO x_user_id, x_resp_id
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';

Previous Topic: APS DBA, DBA, SYSADMIN Role
Next Topic: Non-remitted deferred prepaid invoice
Goto Forum:

Current Time: Sun Aug 20 12:32:31 CDT 2017

Total time taken to generate the page: 0.00993 seconds