Home » Applications » Oracle Fusion Apps & E-Business Suite » How to automatic mail at specific time (Version 10g Application server)
How to automatic mail at specific time [message #384471] Wed, 04 February 2009 00:09 Go to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
pls tell me how to mail report at specific time.

thanx in advanced
Re: How to automatic mail at specific time [message #384487 is a reply to message #384471] Wed, 04 February 2009 01:36 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi,
Can u please elaborate your question.

Kittu.
Re: How to automatic mail at specific time [message #384490 is a reply to message #384487] Wed, 04 February 2009 01:44 Go to previous messageGo to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
Sir I have a report and i want to Execute at 10 pm daily after
run succesfully then mail to Specified mail id ;

how can do this
Re: How to automatic mail at specific time [message #384493 is a reply to message #384490] Wed, 04 February 2009 01:52 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi,
You need another pl/sql stored procedure, in which u call your report,ok,check success of the report then use a API to send that output.

You register this as a concurrent prog and schedule it for 10pm everyday.

The API i have used for same kind was UTL_MAIL.send_raw_data

This will work in 10g only and need to download from metalink.


Try....

Kittu.
Re: How to automatic mail at specific time [message #384494 is a reply to message #384493] Wed, 04 February 2009 01:56 Go to previous messageGo to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
explane brefly
pls
Re: How to automatic mail at specific time [message #384499 is a reply to message #384494] Wed, 04 February 2009 02:10 Go to previous message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi,
u write a pl/sql prog.
then submit your rep using fnd_submit.submit_request... ok
get request_id
....
pass request_id to below API...
fnd_concurrent.wait_for_request

test return values
dev_phase ='COMPLETE',
dev_status ='NORMAL'
then

use UTL_MAIL.SEND_ATTACH_RAW


Please do some research work based upon my suggestions....ok

then u come to know how we can do it.... its not a single answer to question..... lot of things will come to know when u search for UTL_MAIL.ok

The whole package u register a concurrent prog and schedule.


I think this is maximum to start with.


Kittu.
Previous Topic: what's the difference between R12 and 11i in Master-Detail Form Develop??
Next Topic: Concurrent program writing in excel file automatically removing leading zeros
Goto Forum:
  


Current Time: Sat Dec 03 04:14:56 CST 2016

Total time taken to generate the page: 0.12221 seconds