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: [{"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