Scheduling quick report for mail using application server task
Hello,
I am trying to email an excel quick report but get this error:
Error (ID: c998fa03-ade4-46ce-99e0-84a102031eae) while invoking opertion: Insufficient privileges to export the quick report to Excel. Caused by: ifs.fnd.base.SystemException: Insufficient privileges to export the quick report to Excel.
I followed the instructions on IFS help, but there was nothing there to help me with the error.
Do we know what is the cause?
Thanks, Mark
Page 1 / 1
Hi @svrmhuebner ,
This error comes when the your user id do not have permission to view the report. You can check whether you have the permission using “Manage Grants” . You have to the detail view of the quick report and find the “Manage Grants”.
You can search for the quick report as below and grant the access.
Hello @svrmhuebner,
There is a check for presentation object grant for the current logged in user when exporting a SQL Quick Report to Excel.
This is to stop a user from executing and exporting a quick report to Excel when press object grants is not granted to the current logged in user.
You will see the "Insufficient privileges to export the quick report to Excel" error when trying to export a report to Excel when the press object grants are not given to that user. This works as designed.
To resolve this issue, either publish the report or grant the Quick Report press object to the user or to a permission set of the user.
Thank you.
I checked the permissions and made the changes, but the report is still not getting emailed.
I checked the permission set and updated per instructions above
The outbound message is in a “waiting” status:
The email address is correct, but it just never emails:
Any other ideas or thinks I can check?
Thanks!
Hi @svrmhuebner ,
I tried the same steps from my side.
Create Application Server Task
Now copy the Application Message ID.
RMB and go to Schedule Database Task.
Then you will get a pop up saying ”No Scheduled Job exists for this task. Do you want to create a Schedule”. For that say yes.
Now, add the Application Message ID, in the parameters.
Now you can schedule it according to your requirement.
For the example, I gave an interval to run this. You can calculate the Next Execution time as well. So then, you know when it will run.
Then save.
You can go to view background jobs to see how it will run. After time passes, you could noticed that background job has executed. Another execution time is added as the next schedule.
You will receive the mail as well.
*** Additionally I notice following. You have used file name without an extension.
This is the name of the attachment file in mails, but also the file name checked in to Document Management if the following option is used. The name should contain a name and a valid file extension. If using Document Management, the file extension should also be a valid extension that is defined in Document Management.
Now you could see that the file is usable.
*** Check the mail server is working as well.
Hello, I followed your procedure but I have this error in my background tasks :
However, I have correctly entered the value "FALSE" in my parameters:
What should I do? Thank you in advance!
Problem solved ! I had not entered the correct value ...