Home » Applications » Oracle Fusion Apps & E-Business Suite » how to execute concurrent program from backend.
|
|
Re: how to execute concurrent program from backend. [message #212754 is a reply to message #212586] |
Mon, 08 January 2007 03:29 |
yamini.perumalla
Messages: 3 Registered: December 2006 Location: HYDERABAD
|
Junior Member |
|
|
hi
for submiting request from backend we have fnd_request package
b4 that u need to initialize using fnd_global package
step1
fnd_global.apps_initialize(user_id,resp_id,resp_appl_id);
u can get user_id,resp_id,resp_appl_id from fnd_responsibility_tl table
step2
fnd_request.submit_request('app_sht_name','executable_sht_name');
thats it
yamini
|
|
|
|
|
Re: how to execute concurrent program from backend. [message #215952 is a reply to message #215931] |
Wed, 24 January 2007 07:10 |
adragnes
Messages: 241 Registered: February 2005 Location: Oslo, Norway
|
Senior Member |
|
|
Hany,
Though Dijkstra no doubt was right that after a certain mathematical inclination the most important skill for a programmer was a good command of ones native language, it seems that a good command of English is more or less required for us non-native speakers as well.
The package you are looking for is "FND_REQUEST". You can read more about this package in Chapter 21 PL/SQL APIs for
Concurrent Processing in the Oracle Application Developer's Guide.
BTW: Most E-Business Suite manuals are freely available for download from OTN. Navigate to Documentation>Applications.
--
Aleksander Dragnes
|
|
|
|
Re: how to execute concurrent program from backend. [message #216010 is a reply to message #215953] |
Wed, 24 January 2007 11:07 |
adragnes
Messages: 241 Registered: February 2005 Location: Oslo, Norway
|
Senior Member |
|
|
Hany,
I do not have much to go on, but are you trying to start the concurrent program from a trigger in Forms or Reports? If so, you could try creating a database stored procedure to call fnd_request.submit_request and then call that stored procedure from your Forms or Reports trigger and see if that helps.
--
Aleksander Dragnes
|
|
|
Re: how to execute concurrent program from backend. [message #216785 is a reply to message #212584] |
Tue, 30 January 2007 06:44 |
hany_marawan
Messages: 198 Registered: April 2005 Location: Cairo - Egypt
|
Senior Member |
|
|
Hello,
I used this code to send a request from a form
declare
req_id number;
vRESP_APPL_ID number;
vRESP_ID number;
vUSER_ID number;
errbuf varchar(1000);
BEGIN
vRESP_APPL_ID := apps.fnd_profile.value('RESP_APPL_ID');
vRESP_ID := apps.fnd_profile.value('RESP_ID');
vUSER_ID := apps.fnd_profile.value('USER_ID');
apps.fnd_global.apps_initialize vUSER_ID,vRESP_ID,vRESP_APPL_ID);
req_id := apps.fnd_request.submit_request('FND','All Jobs','JOBS','',FALSE,
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','');
if req_id=0 then
FND_MESSAGE.RETRIEVE;
FND_MESSAGE.ERROR;
end if;
commit;
end;
It gave me the error which I sent.
can you help me to solve this ptoblem
Thanks
|
|
|
|
Goto Forum:
Current Time: Sat Oct 05 08:37:04 CDT 2024
|