AOL - How do I submit a concurrent request from PL/SQL?

GeekInterview.com > Interview Questions > Oracle Apps > AOL

Go To First | Previous Question | Next Question

AOL | Question 8 of 34

How do I submit a concurrent request from PL/SQL?

Use FND_REQUEST.SUBMIT_REQUEST
Example: req_id := FND_REQUEST.SUBMIT_REQUEST('FND', 'FNDSCARU');
Note that this can only be called from a concurrent program See the Coding Standards for parameter details

Total Answers and Comments: 12

Last Update: August 02, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

February 08, 2006 06:50:26

anil

RE: How do I submit a concurrent request from PL/SQL?

by using fnd_request.submit_request(parameters)

Is this answer useful? Yes | No

February 13, 2006 09:27:58

Bonthu

RE: How do I submit a concurrent request from PL/SQL?

Use below query :

FND_REQUEST.SUBMIT_REQUEST ( ' Parameters');

Cheers,

Bonthu.

Is this answer useful? Yes | No

March 03, 2006 03:37:24

poojar

Member Since: January 2006 Contribution: 5

RE: How do I submit a concurrent request from PL/SQL?

using fnd_request.submit_request('cp name','parameters');

Is this answer useful? Yes | No

March 07, 2006 04:53:36

MukeshBabu

RE: How do I submit a concurrent request from PL/SQL?

begin

v_request_id := fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)

commit;

if v_request_id > 0 then

dbms_output.put_line('Successfully submitted')

else

dbms_output.put_line('Not Submitted');

end;

Regards,

Mukesh

Is this answer useful? Yes | No

April 12, 2006 01:59:39

manish gakare

RE: How do I submit a concurrent request from PL/SQL?

How do I submit a concurrent request from PL/SQL trigger

Is this answer useful? Yes | No

April 13, 2006 11:09:36

Madhu

RE: How do I submit a concurrent request from PL/SQL?

Himanish gakareIn the plsql trigger also u write plsql code only so there is no difference.Here is the code FND_REQUEST.SUBMIT_REQUEST ( 'Application Name', 'Report Short name', '', '', FALSE, 'R', -- P_report_type '', -- P_agent_name_num '', -- P_po_num_from '', -- P_po_num_to '', -- P_release_num_from '', -- P_release_num_to '', -- P_date_from '', -- P_date_to '', -- P_approved_flag '', -- P_test_flag 'Y', -- P_print_releases '', -- P_sort_by v_user_id, -- P_user_id '2', -- P_qty_precision 'Y', -- P_fax_enable NAME_IN('FAX.FAX_FAX_NUMBER'), -- P_fax_num 'Y', -- P_CANCEL_LINE 'N', -- P_BLANKET_LINES '','','','', -- 22 '', '', '', '', '', '', '', '', '', '', --32 '', '', '', '', '', '', '', '', '', '', --42 '', '', '', '', '', '', '', '', '', '', --52 '', '', '', '', '', '', '', '', '', '', --62 '', '', '', '', '', '', '', '', '', '', --72 '', '', '', '', '', '', '', '', '', '', --82 '', '', '', '', '', '', '', '', '', '', --92 '', '', '', '', '', '', '', ''); --100 Thanks,Madhu

Is this answer useful? Yes | No

May 12, 2006 05:34:19

Mohammed Abdul Rahman

RE: How do I submit a concurrent request from PL/SQL?

we first need to initialise oracle applications session using fnd_global.apps_initialize(user_id,responsibility_id,application_responsibility_id) and then run fnd_request.submit_request

begin

fnd_global.apps_initialize(user_id,resp_id,appl_resp_id)

v_request_id := fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)

commit;

if v_request_id > 0 then

dbms_output.put_line('Successfully submitted')

else

dbms_output.put_line('Not Submitted');

end;

Is this answer useful? Yes | No

May 17, 2006 12:09:50

vishnu

RE: How do I submit a concurrent request from PL/SQL?

If one want to submit the conc req from backend (from OS), use CONCSUB utility.

Is this answer useful? Yes | No

June 06, 2006 07:35:18

shravanamsharat

Member Since: June 2006 Contribution: 10

RE: How do I submit a concurrent request from PL/SQL?

I think u dont neet to intialize oracle application sessions using fnd_global.apps_intialize. If u submit the request it will be automatically intialized. So u dont need to intialize it

Is this answer useful? Yes | No

July 17, 2007 01:41:39

#10

t1.venki

Member Since: May 2007 Contribution: 5

RE: How do I submit a concurrent request from PL/SQL?

FIRST WEHAVE TO START SESSION WITH APPS
APPS.INTIALIZE(RESP_ID,USER_ID,ORG_ID);
-- U CAN FIND THIS IN MENU HELP DIGNASTICTS EXAMINE LOGIN FROM USER

begin

v_request_id := fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)

commit;

if v_request_id > 0 then

dbms_output.put_line('Successfully submitted'V_REQUEST_ID)

else

dbms_output.put_line('Not Submitted');

end;

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top