OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to execute concurrent program from backend.

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to execute concurrent program from backend.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to execute concurrent program from backend. [message #212584]

Sat, 06 January 2007 00:41

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.

Report message to a moderator

Re: how to execute concurrent program from backend. [message #212586 is a reply to message #212584]

Sat, 06 January 2007 01:32

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Use FND_GLOBAL.APPS_INITIALIZE to set the responsibility and application.
FND_REQUEST.SUBMIT_REQUEST

Thanks,
Vamsi

Report message to a moderator

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

Report message to a moderator

Re: how to execute concurrent program from backend. [message #215931 is a reply to message #212584]

Wed, 24 January 2007 05:54

hany_marawan
Messages: 198
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

Report message to a moderator

Re: how to execute concurrent program from backend. [message #215939 is a reply to message #212586]

Wed, 24 January 2007 05:59

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

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

Report message to a moderator

Re: how to execute concurrent program from backend. [message #215953 is a reply to message #212584]

Wed, 24 January 2007 07:16

hany_marawan
Messages: 198
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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Oracle Finance Functional - Interview Questions [message #220069 is a reply to message #215931]

Sun, 18 February 2007 09:55

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

Report message to a moderator

Previous Topic:	if i created 'RFQ' via 'Autocreate', how to find out from which requisition i created 'RFQ'..
Next Topic:	GL Architecture

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 18:25:39 CDT 2024