You can achieve this by shell scripting either by scripting via CONCSUB utility (invoked from OS) or you can use the FND_SUBMIT package (through PL/SQL package), and in the script itself you can create the outputs or any hardcode messages to a file, and then mail the output to your desired mail address.
If you use mail or mailx command using the OS utility then you can even send mail to external users which should not necessarily be a registered EBS users.
Google, Forum Search and metalink will provide you loads of articles on how to use CONCSUB and FND_SUBMIT packages.
Thanks for your Reply.
I got the shell script from google and I know how to register a program of "Host" Execution method. But I dont know anything about the creation of a symbolic link for it..
Can you help me do this?....
Thanks in Advance.
Yes sure, please follow the below:
1) Create a shell script with the .prog extension and plac it in XXCUST_TOP/bin (for an example)
2) Then define the Concurrent Program with Executable Type = Host and Execution File Name = Name of .prog file without extension
3) Create symbolic link by executing below commands on Unix Server
ln -s $FND_TOP/bin/fndcpesr your_script.prog
Hope this helps!