Am seeing the following error in the DB alert log when the event fires.
-4091: ORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see it
ORA-04091: table IFSAPP.FNDCN_APPLICATION_MESSAGE_TAB is mutating, trigger/function may not see it
I have seen people getting around this with an autonomous pragma - but cant insert as am not executing an SQL block but sending an email.
Best answer by duretteView original
Create a PL/SQL block that sends an email via a background job. (My example assumes you have a mail sender MAIL_SENDER_HTML. Yours is probably something like MAIL_SENDER1 if you haven’t changed it.)
Thanks this has really helped! Only issue now, is I cant seem to pull any of the event attributes into the output email - I really want to show the subject in the application message email output.
I’m having trouble getting this to work (post linked below). What version of IFS are you using (I’m on v10)?