raman av

 Profile Answers by raman av Questions by raman av

• Dec 26th, 2007

 

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

diyareplies

 Profile Answers by diyareplies 

• Apr 21st, 2011

 

You can try FND_REQUEST.SET_REPEAT_OPTIONS to run at specific times

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

shatagni

 Profile Answers by shatagni 

• Mar 7th, 2014

 

If dependency is there on previous submitted request.

1. FND_REQUEST . WAIT
2. FIND_REQUEST.Submit_request

Priyanka

• Jul 15th, 2014

 

It is FND_REQUEST.Submit_request

naresh kotapati

• Jul 31st, 2014

 

FND_REQUEST.SUBMIT_REQUEST

Veeresh

• Nov 7th, 2014

 

we can user this API > fnd_request.set_repeat_options

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

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;
/

aditya

• Nov 2nd, 2017

 

Code