Oracle Cloud Blog

Today we are going to see how to print QR Code in Oracle Cloud BI Publisher. I am going to show this using dummy data. I have created a BI Data Model using below SQL SQL: select 'Invoice Number: 12345' || chr(10)  || 'Invoice Date: 2020-01-01' comments from dual Result: BI Publisher QR Code Test I have created a RTF template using below code to print QR Code. <?qrcode:COMMENTS; 100?> Below is the syntax for QR Code: <?qrcode: <DATA>; <SIZE>[; <CHARSET>]?> where DATA – Data to be encoded in the QR code format. SIZE – QR code size dimension in points(pt). CHARSET – (Optional) Character set for encoding the data. Default is UTF8. My DATA is present in the attribute "comments" and I have given the QR Code SIZE as 100. I have ignored the CHARSET as it is optional. I have attached this RTF template to a BI Report. Below is my output. BI Publisher QR Code Output To verify the QR Code, I have saved the QR C...

In this blog, we are going to see how to generate output using eText Template in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Word Document and save it as type "Rich Text Format" Add a format setup which is given below <TEMPLATE TYPE> FIXED_POSITION_BASED <OUTPUT CHARACTER SET> UTF-8 <NEW RECORD CHARACTER> Carriage Return Add a Header table which is given below. For headers, give the header name within quotes ex: 'Emplid'. For headers, use the level DATA_DS which is the top level and appears only once in the XML <LEVEL> DATA_DS <POSITION> <LENGTH> <FORMAT> <PAD> <DATA> <COMMENTS> <NEW RECORD> DATA_DS Alpha ‘Emplid’ ...