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

Current Time: Mon Oct 24 08:10:22 CDT 2016

Total time taken to generate the page: 0.17137 seconds