Hi,
I created a custom oracle function in app owner schema.
I granted EXECUTE to IFSAPP, IFSINFO, IFSPRINT and IFSSYS on the function.
The SQL Quick report that uses this function is throwing a ORA-00904 error which I know means it can’t find it.
I am calling the function within a SQL statement as <appowner>.<myfunction>.
Are we able to use custom functions in a quick report?
And if so, what user needs access to it? I thought it was IFSPRINT but apparently I am wrong.
Thanks!
Hi,
If you are running the SQL Quick Report through IFS EE the SQL query us run as the client login user to maintain row base security etc. login user. Try granting to function to the user or a permission set the end users who run this report.
Yet, if you run the report as IFSAPP then you should not see the error. If so, then it’s something else that is causing the issue.
Regards,
Chanaka
That’s what I was missing, need to grant to permission set. Runs as IFSAPP just fine.
Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.