Skip to main content
Solved

Quick Report Export to Excel Function Insufficient Privileges

  • October 26, 2020
  • 3 replies
  • 1620 views
B
Sidekick (Customer)
Forum|alt.badge.img+7

Does anyone know why I am getting the following error message when I try to export my Quick Report to Excel?

Excel Plugin Error: ORA-06550: line 1, column 43:
PL/SQL: ORA-01031: insufficient privileges

The Quick Report runs fine in IFS and, once run, I can output the results to excel, but I can not simply  do the report function “Export to Excel”.  The report is written against a materialized view in IFS.  I can see the view in IFS SQL Query Tool and can preform searches on the view.

The report is written using the following SQL statement:

select * from c_pol_gl_sales_cogs_union_mv

I have tried using &AO., IFSINFO., prefixes to view name with no luck.

Best answer by RutJWhalen

@BillatREM

Try granting select to IFSSYS;

 

GRANT SELECT ON c_pol_gl_sales_cogs_union_mv to IFSSYS;

View original

3 replies

R
Superhero (Partner)
Forum|alt.badge.img+18
  • RutJWhalen
  • Superhero (Partner)
  • 364 replies
  • November 2, 2020

@BillatREM Is the full Quick Report SQL Statement:

 

select * from c_pol_gl_sales_cogs_union_mv

 

 

 

 

B
Sidekick (Customer)
Forum|alt.badge.img+7
  • BillatREM
  • Author
  • Sidekick (Customer)
  • 13 replies
  • November 2, 2020

@johnw66 

Yes, the full sql statement is as follows, no where clause.

select * from c_pol_gl_sales_cogs_union_mv

 

We want the report to be a complete data dump of the materialized view.

R
Superhero (Partner)
Forum|alt.badge.img+18
  • RutJWhalen
  • Superhero (Partner)
  • 364 replies
  • Answer
  • November 2, 2020

@BillatREM

Try granting select to IFSSYS;

 

GRANT SELECT ON c_pol_gl_sales_cogs_union_mv to IFSSYS;

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings