Dynamically Setting the Delivery Options from Back End

In Oracle Release 12.1.3 Oracle have come up with a new functionality to deliver the output of the Concurrent Program by various methods.

 

 

when we click on the Delivery options button it will open up another form which contains the information in which the output can be delivered.

 

1.IPP Printer : we can specify the Printer IP adress and user name and password for the printer and the no of copies to be printed(can be used if the required information is available).

2.Email: we can specify the email to whom the output has to be mailed after completion.(Specify any valid email address).

3.Fax : we can specify the fax details so that the the output can be faxed once the request is complted.

4.FTP: specify the FTP details to move the output to a particular folder in the server so that it can be access by the employees.

 

I have taken the Example Email which is generally commenly used.

 

 

 

By default the From field is filled with the email address of the logged in user and subject has the instance name and the report name and the logged in user name.

 

we can edit and change the subject and give as per the requirement.

 

In the TO field and the CC fields specify the Email address to whom the output has to be emailed.

 

If multiple emails are there then seperate them by using the ','.

 

This is the functionality used from the front end.

 

If we want to use the same thing from the back end which we generally used to submit the conucurrent program from the back end.

 

Use the below code.

 

/* Formatted on 2/20/2013 1:52:15 PM (QP5 v5.139.911.3011) */

DECLARE
l_conc_id NUMBER;
l_user_id NUMBER
:=
3651;
l_resp_id NUMBER
:=
20420;
l_resp_ppl_id NUMBER
:=
0;
l_boolean BOOLEAN;
BEGIN
l_boolean :=
fnd_request.add_delivery_option (TYPE
=>
'E',
-- this one to speciy the delivery option as Email
p_argument1 =>
'Testing the Email option from back end',
-- subject for the mail
p_argument2 =>
'abx@xyz.com',
-- from address
p_argument3 =>
'xyz@abc.com','adf@abc.com',
-- to address
p_argument4 =>
'',
-- cc address to be specified here.
nls_language
=>
'');
-- language option);
IF l_boolean =
TRUE
THEN
FND_GLOBAL.APPS_INITIALIZE (l_user_id, l_resp_id, l_resp_ppl_id);
-- intialize the apps.
l_conc_id :=
fnd_request.submit_request (application =>
'FND',program
=>
'FNDSCURS',
start_time =>
SYSDATE,sub_request =>
FALSE);
END
IF;
END;

 

Hope this document will be useful to every one as this one is the common requirement coming up now a days with all the clients.

 

 

Cheerss!!!!!