Skip to main content
Solved

QR Schedule Failed - ORA-06512

  • August 10, 2022
  • 6 replies
  • 785 views

Forum|alt.badge.img+10
  • Hero (Customer)
  • 98 replies

Hi Community, 

I am trying to Schedule Quick Report. It failed with below error

‘The directory id MY_USERID is not allowed to run the application.
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 341
ORA-06512: at "IFSAPP.LOGIN_SYS", line 329
ORA-06512: at "IFSAPP.LOGIN_SYS", line 136
ORA-06512: at line 1”

 Just to mention that I got IFS_ALL permission and I can also run the QR in the frontend. 

I tried other QR also without success.

When I change “Execute As” to ‘System’ it also fail with a different error ‘Entity instance not found. (QUICK_REPORT - QUICK_REPORT_ID=813974.0)’.

Also to mention that we are on APP10 update 15.

Much appreciate your help

Best answer by NMALKI

Just an update this error end up because the Single Sign on . 

To solve it , I changed “Execute As” to ‘System’ and granted IFSCONNECT IFS_ALL permission. 

6 replies

Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 98 replies
  • Answer
  • August 16, 2022

Just an update this error end up because the Single Sign on . 

To solve it , I changed “Execute As” to ‘System’ and granted IFSCONNECT IFS_ALL permission. 


KristenGastaldo
Superhero
Forum|alt.badge.img+18
  • Superhero
  • 400 replies
  • August 17, 2022

Thanks for coming back to let us know. I’m glad you were able to resolve it!


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 7 replies
  • August 19, 2025

@NMALIKI i have similar usecase (SSO plus we are hosted by IFS so no IFSAPP) and same error that i couldn’t resolve by changing “Execute As” to ‘System’ . 
could you expand on granting IFSCONNECT IFS_ALL permission.  which permission set we need to grant these.

 


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 98 replies
  • August 19, 2025

@Ukhalid so the user IFSCONNECT You must grant him IFS_ALL permission set.

 

 

 

 


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 7 replies
  • August 20, 2025

@NMALKI this worked. I could receive the email with attachement however the attachement says ‘No Data Found’ 😊


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 98 replies
  • August 20, 2025

@Ukhalid does IFSCONECT got access to the data you are trying to populate ? (like employees data got restricted access)