Customer invoice report error

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.

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

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.

@srkhdnnd : Are these Crystal layout related reports?

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

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

 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. 

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