Printing Dynamic Signatures on PO Output for Communication Report

By | July 29, 2015

Recently I got a requirement to print signatures of Purchasing Buyer dynamically on PO Output for Communication report. Since this report uses seeded data definition, it is not possible to store signature file name in database. Hence I came up with a solution to store signature file in $OA_MEDIA path with file name in the below format

 "<< DOCUMENT_BUYER_FIRST_NAME >>_<< DOCUMENT_BUYER_LAST_NAME >>.jpg" 

since first and last name of the buyer are readily available in data definition.

Below are the steps to implement this:

Insert a dummy image, right click the image and select ‘Format Picture’ and then go to ‘Alt Text’ tab and then enter the URL as given below

url:{concat('${OA_MEDIA}/signatures/',/PO_DATA/DOCUMENT_BUYER_FIRST_NAME,'_',/PO_DATA/DOCUMENT_BUYER_LAST_NAME,'.jpg')}

Format Picture 1 - XMLP

Format Picture - XMLP

To find physical unix path of $OA_MEDIA top, use the query in the below URL:
SQL Query to findout Application Tops unix physical path

Note: If at all the dummy signature image is inserted in a table in rtf layout then ‘Format Picture’ option will not be available, in that case the dummy image must be inserted into a non table layout and then set the URL in ‘Alt Text’ then copy back the picture in the table layout.

Click here to download the sample RTF file demonstrated in this article.

WOW! Did you like this post? We'll send more interesting posts like Printing Dynamic Signatures on PO Output for Communication Report to you!
Enter your Email Address: