Hello Community,
I need to send one quick report output to management as email at the morning 9 am.
Please help.
Hello Community,
I need to send one quick report output to management as email at the morning 9 am.
Please help.
hi
in IFS Apps 8 you would need to use “scheduled PL/SQL” to run some logic, assemble a dataset and send it in an email body.
You can do this using code, if comfortable and you have access, or via Data Migration module.
The key command is Command_Sys.Mail()
Thank you
I will check and let you know if it works.
hi
in IFS Apps 8 you would need to use “scheduled PL/SQL” to run some logic, assemble a dataset and send it in an email body.
You can do this using code, if comfortable and you have access, or via Data Migration module.
The key command is Command_Sys.Mail()
If you prefer coding method, may be Scheduled execution of a custom script | IFS Community could help to set up the scheduling part. I’d suggest to have the quick report SQL as a cursor and add it in the email body but there could be other ways to do it as well.
below thread explains how to add content in the email body as HTML.
Event Action condition setup | IFS Community
Hope it helps!
Damith
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.