XML PUBLISHER How to Show dynamic images in the RTF Template in Oracle

XML PUBLISHER How to Show dynamic images in the RTF Template in Oracle

How to Show dynamic images in Template which will be changed based on conditions or value of data.

Take example you are designing purchase order report in which you want to display item images of the item also. You have around 200 items in system, so we can cannot put if else condition in XML publisher rtf template to display item images based on Items.

For this scenario , you can put all the item images in your server and but image name should be your item name so that when your xml report will run then according to the items it will find item picture in server and prints that in output.

Note: This method only applies to Oracle E-Business Suite installations.
1. Insert a dummy image in your template.

2. In the Format Picture dialog box select the Web tab. Enter the following syntax in
the Alternative text region to reference the OA_MEDIA directory:
concat function to build the URL string. For example:
url:{concat(SERVER,’/’,IMAGE_DIR,’/’,IMAGE_FILE)}.

OR

Right Click on the Dummy Image an Select Edit Alt Picture.

Use the Concat Function url:{concat(SERVER,’/’,IMAGE_DIR,’/’,IMAGE_FILE)}.

In this case , we are using CF_ITEM is a dynamic variable to fetch the Items name from the Data Base.

XML PUBLISHER How to Show dynamic images in the RTF Template in Oracle