Tuesday 13 March 2018

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.

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

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



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

 

2 comments:

Anonymous said...

Oracle Fusion Cloud Financials Training

Rifath said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
¬Oracle Fusion HCM Online Training

Post a Comment

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

Name

Email *

Message *