Skip to main content

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.

@BillatREM Is the full Quick Report SQL Statement:

 

select * from c_pol_gl_sales_cogs_union_mv

 

 

 

 

@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.

@BillatREM

Try granting select to IFSSYS;

 

GRANT SELECT ON c_pol_gl_sales_cogs_union_mv to IFSSYS;

Reply


Terms & ConditionsCookie settings