Displaying image / picture dynamically in XML Publisher (BI Tools) RTF template

Below two examples will demonstrate displaying image dynamically in XML publisher in Microsoft Office 2007 and onwards version.

Displaying Company logo image dynamically in XML Publisher (BI Tools) in RTF Template :

1. Insert any dummy placeholder image in RTF template (Insert a Picture)
2. Right click on image and click “Size” then goto “AltText” tab and enter dynamic path in “Alternative Text” field  e.g. url:{concat(‘${OA_MEDIA}’,’/XX_Logo.jpg’)}.

$OA_MEDIA path TOP is actual path in Oracle App instance where images are stored . DBA may help to get $OA_MEDIA Top path to upload XX_Logo.jpg file.

Displaying signature dynamically in XML Publisher (BI tools) RTF template

1. Insert any dummy placeholder image in RTF template (Insert  a Picture)
2. Right click on image and click “Size” then goto “AltText” tab and enter dynamic path in “Alternative Text” field  e.g. url:{concat(‘${OA_MEDIA}/XX_buyer_’,/PO_DATA/DOCUMENT_BUYER_FIRST_NAME ,’_’,/PO_DATA/DOCUMENT_BUYER_LAST_NAME ,’.jpg’)}

$OA_MEDIA path TOP is actual path in Oracle App instance where images are stored. DBA may help to get $OA_MEDIA Top path to upload buyer’s signature file. Below examples will demonstrate displaying image dynamically in XML publisher in Microsoft Office 2003 which obsolete in MS office 2007 and onward versions.

Dynamic Image loading in XML publisher / BI tools