Skip to main content
Solved

PDF_REPORT_CREATED no sending the email using the SENDER

  • August 15, 2025
  • 1 reply
  • 96 views

ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14

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!

 

Best answer by ZTC ZTC JGOTA

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)

1 reply

ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • Answer
  • August 15, 2025

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)