Home » Applications » Oracle Fusion Apps & E-Business Suite » how to execute concurrent program from backend.
how to execute concurrent program from backend. [message #212584] Sat, 06 January 2007 00:41 Go to next message
kishore_p
Messages: 8
Registered: December 2006
Junior Member
Hi,

Can anybody explain me how to execute concurrent program from backend.


Advance thanks for reply.
Re: how to execute concurrent program from backend. [message #212586 is a reply to message #212584] Sat, 06 January 2007 01:32 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Use FND_GLOBAL.APPS_INITIALIZE to set the responsibility and application.
FND_REQUEST.SUBMIT_REQUEST

Thanks,
Vamsi
Re: how to execute concurrent program from backend. [message #212754 is a reply to message #212586] Mon, 08 January 2007 03:29 Go to previous messageGo to next message
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 #215931 is a reply to message #212584] Wed, 24 January 2007 05:54 Go to previous messageGo to next message
hany_marawan
Messages: 195
Registered: April 2005
Location: Cairo - Egypt
Senior Member
I used this fuction but it gave me this error
"upsupported construct"
I search on this package "fnd_reuqets" in the FNDSQF lib but I did not found it
Can you help me
Thanks
Re: how to execute concurrent program from backend. [message #215939 is a reply to message #212586] Wed, 24 January 2007 05:59 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
vamsi kasina wrote on Sat, 06 January 2007 13:02
FND_GLOBAL.APPS_INITIALIZE
FND_REQUEST.SUBMIT_REQUEST

Cross check your spelling.

By
Vamsi
Re: how to execute concurrent program from backend. [message #215952 is a reply to message #215931] Wed, 24 January 2007 07:10 Go to previous messageGo to next message
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 #215953 is a reply to message #212584] Wed, 24 January 2007 07:16 Go to previous messageGo to next message
hany_marawan
Messages: 195
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Sorry for my worng spelling, I was busy so I did not read whate I wrote, sorry again.
About the guide you asking me to read, I did but as I said it gave me the error I wrote above.

tahnks
Re: how to execute concurrent program from backend. [message #216010 is a reply to message #215953] Wed, 24 January 2007 11:07 Go to previous messageGo to next message
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 Go to previous messageGo to next message
hany_marawan
Messages: 195
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
Oracle Finance Functional - Interview Questions [message #220069 is a reply to message #215931] Sun, 18 February 2007 09:55 Go to previous message
rupa@oracle.com
Messages: 1
Registered: February 2007
Location: Hyderabad
Junior Member

[Hi,

Please suggest the imp interview questions of Oracle Finance Functional.

thanks
Email: rupa_gsr@yahoo.com
Previous Topic: if i created 'RFQ' via 'Autocreate', how to find out from which requisition i created 'RFQ'..
Next Topic: GL Architecture
Goto Forum:
  


Current Time: Sun Dec 11 04:09:24 CST 2016

Total time taken to generate the page: 0.07537 seconds