Monday, 25 October 2021

How to show image/picture in bursting email body in oracle fusion

How to show image/picture in bursting email body in oracle fusion

Hi friends, we are going to discuss about how we can show the picture in the bursting emails body in oracle fusion. If we have an requirement to print some company logo or to put some product image in the bursting email body then we can achieve this requirement through this below feature. Oracle Fusion has given the flexibility to print any picture or image in auto bursting email body. We can implement this feature using the html option. We just need to embed the html code in the bursting query and we can print the logo or image/pictures in the bursting email body. We all know bursting emails are auto emails sends by application and we just write the syntax to write the emails body in this bursting process. We don't have the direct option to put the image or picture in the email body logic so that it will print while sending emails. 

In this post , we will show the complete logic , how we can embed any image or picture in the bursting email body so that we can show pictures in the bursting emails.



How to show image/picture in bursting email body in oracle fusion
How to show image/picture in bursting email body in oracle fusion

4 Important points to show image/picture in bursting email body in oracle fusion

1. First Important point, as we cannot embed the pictures directly in the bursting email body , so we need to put the image in the internet or upload in google.
2.After upload the image in google , just open that image in google and then copy that image url. This is very important step , Image or picture should be in the internet.

Steps to show image/picture in bursting email body in oracle fusion

Step 1:- As we said , we need to put the image in web and then open that image in google and copy the url.

Step 2:- After copy the url of the image , we need to use the HTML syntax to call the image from internet for display in any platform.


The HTML <img> tag is used to embed an image in a web page.

The <img> tag creates a holding space for the referenced image.

The <img> tag has two required attributes:

src - Specifies the path to the image
alt - Specifies an alternate text for the image

Syntax: 

<img src="url" alt="alternatetext">

The required alt attribute provides an alternate text for an image, if the user for some reason cannot view it (because of slow connection, an error in the src attribute, or if the user uses a screen reader).


Step 2:-

Here below is the syntax we are using in the Bursting email query in oracle fusion. In this below example , we are printing or displaying the Company image logo in the Email body which will be triggered from oracle fusion application. 

If it will not be displayed then you need to unblock image in the outlook form to display the image from wed to your outlook email account.

Sample Bursting Code to show image/picture in bursting email body in oracle fusion

Here below is the sample bursting email sql query in oracle fusion

select
Vendor_id as "KEY", 
'RTF NAME OF THE BIP REPORT.rtf' TEMPLATE, 
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT, 
VENDOR_NAME OUTPUT_NAME, 
'EMAIL' DEL_CHANNEL, 
'To Email Address' PARAMETER1,
'Cc Email Address' PARAMETER2,
'TestEmail.email.com PARAMETER3',
'Subject Of the Email' PARAMETER4, 
'<html>Hi
'||'Email body which will be show in the Bursting Email.
'||'Thanks & Regards
'||'Test Person
'||'<img src="https://www.w3schools.com/images/w3schools_green.jpg" alt="W3Schools.com" style="width:104px;height:142px;">
</html>' PARAMETER5, --Complete Email Body , we are converting into HTML syntax, so that we can use the HTML tag to print the image. --
'True' PARAMETER6,
:p_from_email  PARAMETER7 
from PO_VENDORS

How to show image/picture in bursting email body in oracle fusion




1 comments:

Anonymous said...

Some studies show that drinking alcohol, beer in moderation, in small doses will bring great benefits to health. does sprite zero have caffeine, d&d 5e vampire remove curse, is halloween a catholic holiday, urinary tract infection urinating after sexual intercourse, how to find a rich husband

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *