Skip to main content
Solved

How to send e-mail with attachments in CLOUD

  • September 10, 2024
  • 5 replies
  • 225 views
N
Do Gooder (Customer)
Forum|alt.badge.img+6

Hello,

In APPS9 we were able to be send e-mail with attachment and specified mail sender with the following api:
---------------------------------
ifsapp.COMMAND_SYS.Mail(
                                  from_user_name_ => ifs_from_user_name_,
                                  to_user_name_   => ifs_to_user_name_,
                                  text_           => ifs_text_,
                                  attach_         => attachments_,
                                  cc_             => ifs_cc_list_,
                                  subject_        => ifs_subject_,
                                  mail_sender_    => ifs_mail_sender_                                 
                               );  
----------------
But in IFS cloud this does not work. What is the correct typo of the api to send e-mail with attachment and identifying the mail sender?

Best answer by SimonTestard

I can’t really tell if something changed from Apps9 to Cloud as I don’t have access to an Apps9 environment, but in Apps10/Cloud, the only method that uses from_user_name_ and_user_name_ is :

 

PROCEDURE Mail (
   from_user_name_ IN VARCHAR2,
   to_user_name_   IN VARCHAR2,
   text_           IN VARCHAR2,
   error_text_     IN VARCHAR2 DEFAULT NULL,
   attach_         IN VARCHAR2 DEFAULT NULL,
   cc_             IN VARCHAR2 DEFAULT NULL,
   subject_        IN VARCHAR2 DEFAULT NULL,
   timer_          IN VARCHAR2 DEFAULT NULL,
   audit_          IN VARCHAR2 DEFAULT NULL,
   from_alias_     IN VARCHAR2 DEFAULT NULL,
   label_          IN VARCHAR2 DEFAULT NULL);

 

That method does not allow mail_sender_ as a parameter, but neither does it allow in in Apps 10, at least in UPD23.

 

If you want to use mail_sender_, you can use the only two declarations (but they don’t use from/to username)

 

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,
   attach_        IN CLOB,
   rowkey_        IN VARCHAR2 DEFAULT NULL,
   mail_sender_   IN VARCHAR2 DEFAULT NULL);

 

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);

 

It’s possible Apps 10 introduced a couple variations and changed the basic one. Typically I use I use that third one if I want to send multiple attachments, or the second one if there’s none or only one attachment.

 

Both allow specificying the mail_sender.

5 replies

S
Hero (Customer)
Forum|alt.badge.img+12
  • SimonTestard
  • Hero (Customer)
  • 340 replies
  • September 10, 2024

What do you mean it does not work in Cloud?

 

There should not be a problem utilizing this call as long as it’s executed from within a PL/SQL customized method?

N
Do Gooder (Customer)
Forum|alt.badge.img+6
  • nachzehn
  • Author
  • Do Gooder (Customer)
  • 12 replies
  • September 10, 2024

it gives error stating that “wrong number of types of arguments”

S
Hero (Customer)
Forum|alt.badge.img+12
  • SimonTestard
  • Hero (Customer)
  • 340 replies
  • September 10, 2024

Where ? How are you calling this, in what context ?

S
Hero (Customer)
Forum|alt.badge.img+12
  • SimonTestard
  • Hero (Customer)
  • 340 replies
  • Answer
  • September 10, 2024

I can’t really tell if something changed from Apps9 to Cloud as I don’t have access to an Apps9 environment, but in Apps10/Cloud, the only method that uses from_user_name_ and_user_name_ is :

 

PROCEDURE Mail (
   from_user_name_ IN VARCHAR2,
   to_user_name_   IN VARCHAR2,
   text_           IN VARCHAR2,
   error_text_     IN VARCHAR2 DEFAULT NULL,
   attach_         IN VARCHAR2 DEFAULT NULL,
   cc_             IN VARCHAR2 DEFAULT NULL,
   subject_        IN VARCHAR2 DEFAULT NULL,
   timer_          IN VARCHAR2 DEFAULT NULL,
   audit_          IN VARCHAR2 DEFAULT NULL,
   from_alias_     IN VARCHAR2 DEFAULT NULL,
   label_          IN VARCHAR2 DEFAULT NULL);

 

That method does not allow mail_sender_ as a parameter, but neither does it allow in in Apps 10, at least in UPD23.

 

If you want to use mail_sender_, you can use the only two declarations (but they don’t use from/to username)

 

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,
   attach_        IN CLOB,
   rowkey_        IN VARCHAR2 DEFAULT NULL,
   mail_sender_   IN VARCHAR2 DEFAULT NULL);

 

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);

 

It’s possible Apps 10 introduced a couple variations and changed the basic one. Typically I use I use that third one if I want to send multiple attachments, or the second one if there’s none or only one attachment.

 

Both allow specificying the mail_sender.

N
Do Gooder (Customer)
Forum|alt.badge.img+6
  • nachzehn
  • Author
  • Do Gooder (Customer)
  • 12 replies
  • September 11, 2024

I can’t really tell if something changed from Apps9 to Cloud as I don’t have access to an Apps9 environment, but in Apps10/Cloud, the only method that uses from_user_name_ and_user_name_ is :

 

PROCEDURE Mail (
   from_user_name_ IN VARCHAR2,
   to_user_name_   IN VARCHAR2,
   text_           IN VARCHAR2,
   error_text_     IN VARCHAR2 DEFAULT NULL,
   attach_         IN VARCHAR2 DEFAULT NULL,
   cc_             IN VARCHAR2 DEFAULT NULL,
   subject_        IN VARCHAR2 DEFAULT NULL,
   timer_          IN VARCHAR2 DEFAULT NULL,
   audit_          IN VARCHAR2 DEFAULT NULL,
   from_alias_     IN VARCHAR2 DEFAULT NULL,
   label_          IN VARCHAR2 DEFAULT NULL);

 

That method does not allow mail_sender_ as a parameter, but neither does it allow in in Apps 10, at least in UPD23.

 

If you want to use mail_sender_, you can use the only two declarations (but they don’t use from/to username)

 

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,
   attach_        IN CLOB,
   rowkey_        IN VARCHAR2 DEFAULT NULL,
   mail_sender_   IN VARCHAR2 DEFAULT NULL);

 

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);

 

It’s possible Apps 10 introduced a couple variations and changed the basic one. Typically I use I use that third one if I want to send multiple attachments, or the second one if there’s none or only one attachment.

 

Both allow specificying the mail_sender.

thank you ver much Simon


Terms & ConditionsCookie settingsAccessibility statement