Wednesday, 2 January 2019

How to capture Images and Logos in Excel Report Output from Oracle XML RTF Template - Oracle EBS R12

https://xmlpublishertemplate.blogspot.com/2019/01/how-to-capture-images-and-logos-in.html

How to capture Images and Logos in Excel Report Output from Oracle XML RTF Template - Oracle EBS R12


Oracle don't support image embedding for Excel output.
Please use external image reference method instead of image embedding for Excel output.
Oracle can display the logo in Excel from an RTF template by following these steps.

Copy the Picture/Image in RTF Template
Oracle Supports gif, png and jpg Formats. Please don't use JPEG Format

After Copy paste the image in RTF Template. Click the image and navigate to Picture Tools > Format > Alt Text

Copy paste the Below url as it is:
url:{'${OA_MEDIA}/IMAGE_FILE.png'}



Copy IMAGE_FILE file to $OA_MEDIA directory.

Test Report

For Office 2007, please have a look at Note:1286323.1 - How To Format the Image URL in a BI Publisher RTF Template Using MS Word 2007?
it seems that the syntax changed in Office 2007
from
    url:{'$[OA_MEDIA]/image.jpg'}
to
     url:{'${OA_MEDIA}/image.jpg'}

-->>  {} instead of []

In the above URL "IMAGE_FILE" is the File name which you will place it in the $OA_MEDIA directory with the same name. Anyhow, you can change the name as you like. But, keep the names same which you have in Alt Text box and the file you have copied in $OA_MEDIA directory.

http://oracleapps88.blogspot.com/2016/03/how-to-insert-images-and-logo-in-xml.html


No comments:

Post a Comment