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
raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Previous Topic: Costed_Flag = N in mtl_material_transactions
Next Topic: Internal Requistions Setup
Goto Forum:
  


Current Time: Thu Dec 08 06:06:17 CST 2016

Total time taken to generate the page: 0.16371 seconds