Skip to main content

Hello IFS Community,

 

I’m running into an issue with a custom PDF_REPORT_CREATED event action that needs to use a specific sender.

 

I’m sending the email with this procedure:

 

COMMAND_SYS.Mail( sender_ => 'YY_MAIL_PU',

from_ => 'IFS@noreply',

to_list_ => to_email_,

cc_list_ => to_buyer_email,

subject_ => 'PO ' || order_no_,

text_ => mail_body_, attachments_ => attachments_ );

When I trigger an Event Action of type E-Mail, the message sends and the specified sender is used correctly.

However, when I use Execute Online SQL (calling COMMAND_SYS.Mail as above) the email fails to send with the desired sender.

Any ideas why sending via COMMAND_SYS.Mail would fail or ignore the sender, while the E-Mail event action works? If there is a default sender it will user the default one but it is not the correct sender to be used.

 

Thanks in advance!

 

I need to use this one

PROCEDURE Mail(
   sender_        IN VARCHAR2,
   from_          IN VARCHAR2,
   to_list_       IN VARCHAR2,
   cc_list_       IN VARCHAR2 DEFAULT NULL,
   bcc_list_      IN VARCHAR2 DEFAULT NULL,
   subject_       IN VARCHAR2,
   text_          IN CLOB,
   attachments_   attachment_arr,
   mail_sender_   IN VARCHAR2 DEFAULT NULL)


Reply