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

Showing Answers 1 - 18 of 18 Answers

anil

  • Feb 8th, 2006
 

by using fnd_request.submit_request(parameters)

  Was this answer useful?  Yes

Bonthu

  • Feb 13th, 2006
 

Use below query :

FND_REQUEST.SUBMIT_REQUEST ( ' Parameters');

Cheers,

Bonthu.

  Was this answer useful?  Yes

MukeshBabu

  • Mar 7th, 2006
 

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        

  Was this answer useful?  Yes

manish gakare

  • Apr 12th, 2006
 

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

  Was this answer useful?  Yes

Madhu

  • Apr 13th, 2006
 

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

  Was this answer useful?  Yes

Mohammed Abdul Rahman

  • May 12th, 2006
 

 hi

  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;

vishnu

  • May 17th, 2006
 

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

  Was this answer useful?  Yes

 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;

  Was this answer useful?  Yes

Usha

  • Jul 31st, 2007
 

I am not able to see the userid or org-id going to the home page of applications under the help menu.  There is no diagnostics menu at all when I expand it...I don't know where to see it atll.

Thanks,

Usha

  Was this answer useful?  Yes

Hi Usha,

If you wanna find out the USER_ID, ORG_ID, RESP_ID, RESP_APPL_ID, connect to the system and open any window and flow the below mentiioned navigation to find the values..

Help -> Diagnostics -> Examine -> you get a small window (dialog box)

select as mentioned :

Block : $PROFILES$
Field  : USER_ID
Value : (You get this Value once u select the Field)

Let me know whether u r able to get the required.


Regards,
Kiran

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions