Solved

Quick Report Export to Excel Function Insufficient Privileges

  • 26 October 2020
  • 3 replies
  • 1293 views
B
Rank
Userlevel 4
Badge +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.

icon

Best answer by RutJWhalen 2 November 2020, 13:41

View original

3 replies

R
Rank
Userlevel 7
Badge +18

@BillatREM Is the full Quick Report SQL Statement:

 

select * from c_pol_gl_sales_cogs_union_mv

 

 

 

 

B
Rank
Userlevel 4
Badge +7

@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
Rank
Userlevel 7
Badge +18

@BillatREM

Try granting select to IFSSYS;

 

GRANT SELECT ON c_pol_gl_sales_cogs_union_mv to IFSSYS;

Reply


Terms & ConditionsCookie settings