Skip to main content

Hi all,

I’m setting up a custom event in IFSCloud that needs to get more information than is exposed in the default tables. I’ve created a package with a function that can retrieve the data I need. 

I can call this function from the custom event action and it’s recognised as I get an error if I specify too many arguments, however when I perform the step that triggers the event action I get the following error:

Database error occurred. Contact administrator.
Error details: t{"code":4067,"message":"ORA-04067: not executed, package body \"IFSAPP.XXX_CUSTOM_PCK\" does not exist"}]

I have already performed the following:

  • Checked there are no errors in the package
  • Compiled the package
  • Queried my package name to confirm SQL can find it
  • Refreshed all server caches, including dictionary
  • Looked to add it in permission sets - can’t find it
  • Checked if it existis within Entities - it does not

I thought that I might be missing a step when I have to create the package / assign the package in IFS or something similar.

Any advise of next steps for me to try would be appriciated.

Kind regards,

Josh

Be the first to reply!

Reply