Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Best way to send text output via email

Received Response
41
Views
2
Comments
mist123
mist123 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

Best way to send text output via email

Content

Hi All,

 

I have PLSQL stored procedure and displaying output in text format (fnd_file.put_line(fnd_file.output,v_statment1);)

 

Now i want to send this output via email , what is the best approach to send an email?

 

Apps R12.1.3

Answers

  • Violeta F
    Violeta F Rank 4 - Community Specialist

    Hi,

    You can use the API FND_REQUEST.ADD_DELIVERY_OPTION to deliver the output via email.

    Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it.

    Regards,

    Violeta

  • mist123
    mist123 Rank 4 - Community Specialist

    Thank you very much!