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

User Name		Remember Me?
Password

Question Bank