|
|
|
|
|
|
| Re: How to automatic mail at specific time [message #384493 is a reply to message #384490] |
Wed, 04 February 2009 01:52   |
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 #384499 is a reply to message #384494] |
Wed, 04 February 2009 02:10 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
