Customer invoice report error | IFS Community
Solved

Customer invoice report error

  • 15 November 2021
  • 8 replies
  • 100 views

Userlevel 1
Badge +1

After applying the UPD13 in Sandbox, we cannot preview customer invoice reports.

We did not modify the permissions.

Any idea on how to resolve this

Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method PrintReport/ReportFormatRequest ---> Ifs.Fnd.FndServerFaultException: Failed executing statement (ORA-01031: insufficient privileges)

icon

Best answer by Manoj Ruwanhewa 15 November 2021, 08:56

View original

8 replies

Userlevel 7
Badge +16

Hi @srkhdnnd ,

Can IFSAPP user view the reports.

If this issue happens for some other user, see the reports whether permission sets are granted for this user.

Userlevel 7
Badge +14

Hi @srkhdnnd ,

I found below article in the community which suggests to 

grant permission to 'IFSSYS' user.

 

Please try that in your case as well by running below code from plsql developer or sql developer tool

 

BEGIN
   Installation_SYS.Grant_Ifssys(TRUE);
END;  

 

Regards

Manoj

Userlevel 1
Badge +1

Thank you for you for the suggestions.

@Minoshini Fonseka , IFSAPP also results same error and other reports also cannot preview as ifsapp.

I verified the permissions for other users as well.

@Manoj Ruwanhewa  , I will try your method.

 

 

Userlevel 7
Badge +16

Hi @srkhdnnd ,

I found below article in the community which suggests to 

grant permission to 'IFSSYS' user.

 

Please try that in your case as well by running below code from plsql developer or sql developer tool

 

BEGIN
   Installation_SYS.Grant_Ifssys(TRUE);
END;  

 

Regards

Manoj



@srkhdnnd : Are these Crystal layout related reports?

Userlevel 1
Badge +1

@Minoshini Fonseka , Yes we have Crystal layouts in sales reports

@Manoj Ruwanhewa , I cannot open the link in your comment

Userlevel 7
Badge +14

Hi @srkhdnnd ,

Kindly ignore that URL as it seems a internally visible one. 

But that has suggested the solution for same error as your error stack which has solved by granting permission to 'IFSSYS' user

 

 

 

 

Regards

Manoj

Userlevel 7
Badge +16

 Hi @srkhdnnd ,

If you encounter the issue with Crystal reports, you could try granting as suggested by @Manoj Ruwanhewa.

This can be resolved by granting permission to 'IFSSYS' user.

'IFSSYS' is the user who impersonates the “Foundation1 user” and therefore needs access to all related database objects. Execute the below script on database to achieve that.

BEGIN    Installation_SYS.Grant_Ifssys(TRUE); END;  

 


As another option, please check whether DATABASE_SYS.SHRINK_LOB_SEGMENTS has run recently. If so, that should be investigated separately. 

Userlevel 7
Badge +15

@srkhdnnd - I’ve updated your permissions and you should have access to the knowledge base now!

Reply