How to schedule the concurrent programs from Back end(PLSQL) -not from SRS form.

Showing Answers 1 - 28 of 28 Answers

fnd.request.submit_request( Concurrent_program_name,
                                              application_short_name
                                               description,
                                               parameters)
                                                ,

Sreenivas

  • Oct 2nd, 2011
 

We also can able to submit from back end by using API called 'fnd_request.submit_request',it consist following
program,Description,arguments .Before this we must initialize by using fnd_apps.global_intialize

  Was this answer useful?  Yes

Priyanka

  • Jul 15th, 2014
 

It is FND_REQUEST.Submit_request

  Was this answer useful?  Yes

naresh kotapati

  • Jul 31st, 2014
 

FND_REQUEST.SUBMIT_REQUEST

  Was this answer useful?  Yes

Veeresh

  • Nov 7th, 2014
 

we can user this API > fnd_request.set_repeat_options

  Was this answer useful?  Yes

shivasharma

  • Nov 12th, 2014
 

Pls can u tell me with out using FND_REQUEST.SUBMIT_REQUEST ,how to schedule the concurrent program from back end.

thanks& regards
shiva sharma

  Was this answer useful?  Yes

Hemendra

  • Aug 5th, 2016
 

DECLARE
l_responsibility_id NUMBER;
l_application_id NUMBER;
l_user_id NUMBER;
l_request_id NUMBER;
l_boolean boolean;
BEGIN
SELECT DISTINCT fnd.user_id, fresp.responsibility_id, fresp.application_id
INTO l_user_id, l_responsibility_id, l_application_id
FROM fnd_user fnd, fnd_responsibility_tl fresp
WHERE fnd.user_name = SYSADMIN
AND fresp.responsibility_name LIKE UEM Purchasing Superuser;
--To set environment context. --
apps.fnd_global.apps_initialize (l_user_id, l_responsibility_id, l_application_id);
--Submitting Concurrent Request --
l_boolean :=fnd_request.set_repeat_options
(repeat_time => null--to_char(sysdate,hh24:mi:ss),
,repeat_interval => 5 --Applies only when releat_time is null
,repeat_unit => MINUTES--Applies only when releat_time is null
,repeat_type => START --Applies only when releat_time is null
--,repeat_end_time =>
--,increment_dates => Y-- Increment the date parameters for next run
);

l_request_id :=
fnd_request.submit_request (application => UHXX
,program => UHXX prg
,description =>
,start_time => null
,sub_request => null
);
COMMIT;
IF l_request_id = 0
THEN
DBMS_OUTPUT.put_line (Concurrent request failed to submit);
ELSE
DBMS_OUTPUT.put_line (Successfully Submitted the Concurrent Request);
END IF;
--
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( Error While Submitting Concurrent Request
|| TO_CHAR (SQLCODE)
|| -
|| SQLERRM
);
END;
/

  Was this answer useful?  Yes

aditya

  • Nov 2nd, 2017
 

Code
  1. l_request_id := fnd_request.submit_request (

  2. application => ONT,

  3. program => xx_test1,

  4. description => XXTest Employee Details,

  5. start_time => SYSDATE,

  6. sub_request => FALSE,

  7. argument1 => Smith

  8. );


  9. IF l_request_id = 0


  10. DBMS_OUTPUT.put_line (Concurrent request failed TO submit);

  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