Question

Scheduling quick report for mail using application server task

  • 20 April 2021
  • 6 replies
  • 687 views
S
Rank
Userlevel 5
Badge +8

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

This topic has been closed for comments

6 replies

Dumeesha Wanigarathna
Rank
Userlevel 7
Badge +16

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.

 

- Dumeesha -
Imal Thiunuwan
Rank
Userlevel 6
Badge +16

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.

S
Rank
Userlevel 5
Badge +8

I checked the permissions and made the changes, but the report is still not getting emailed.

  1. I checked the permission set and updated per instructions above
  2. The outbound message is in a “waiting” status:
  1. The email address is correct, but it just never emails:

Any other ideas or thinks I can check?

Thanks!

Minoshini Fonseka
Rank
Userlevel 7
Badge +19

Hi @svrmhuebner ,

I tried the same steps from my side.

  1. Create Application Server Task
  2. Now copy the Application Message ID.
  3. RMB and go to Schedule Database Task.
  4. 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.
  5. Now, add the Application Message ID, in the parameters.
  6. Now you can schedule it according to your requirement. 
  7. 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. 
  8. Then save.
     
  9.  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.
  10. You will receive the mail as well.

    *** Additionally I notice following. You have used file name without an extension. 

  1.  
    Added the file name with extension

    Now you could see that the file is usable.


    *** Check the mail server is working as well. 

 

/Mino
T
Rank
Userlevel 5
Badge +11

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!

T
Rank
Userlevel 5
Badge +11

Problem solved !
I had not entered the correct value ...

 

thank you for all those informations !! 

Terms & ConditionsCookie settings