Question

SQL Quick Reports - Custom Function

  • 20 January 2023
  • 2 replies
  • 76 views
K
Rank
Badge +2
  • Kyle
  • Do Gooder (Customer)
  • 2 replies

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!

2 replies

ChanakaAmarasekara
Rank
Userlevel 7
Badge +15

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

 

- Chanaka Am -
K
Rank
Badge +2

That’s what I was missing, need to grant to permission set.  Runs as IFSAPP just fine.  

Thank you!

Reply


Terms & ConditionsCookie settings