Barcode with BI publisher report

Barcode with BI publisher report

Step#1 Local Machine Font Setup

 

Install the font on the local machine where XML template is being developed.

For barcode I have used font C39P24DmTt (V100025_.TTF)

Download the font and place it under windows font directory (C:\WINNT\Fonts)

Step#2 Assign the barcode font to the field in XML template

 

Add a placeholder and change the font of it to C39P24DmTt, place the asterix (*) in prefix and suffix to the barcode field.

 

Step#3 uploading the font on server

 

A.   Font file creation

Login to BI publisher responsibility

Under Administration tab -> Font Files ->Create Font file

Name the font file as C39P24DmTtand upload the TTF file.

 

 

 

B.   Create Font Mapping

Login to BI publisher responsibility

Under Administration tab ->Font Mapping->Create Font Mapping

 

C.   assigning the font to the report template

Login to BI publisher responsibility

Templates -> Open the template of the concurrent program you wanted to put barcode -> Click on the edit configuration on the right corner You will see all the configurable options 

Finally run the report you shall see the barcode is being shown on the field

                          XML Publisher report handling special characters 

XML Publisher report handling special characters 

Problem definition- The standard report runs fine when the output format is "Text" but errors out when it "XML".  The XML is generated partially with error message like “The XML page cannot be displayed or Authentication failed.”

Solution-

Open the underlying RDF file and update the below value as

<?xml version="1.0" encoding="ISO-8859-1"?>

Once changed save the report , migrate it and test the XML output.

                                                      Code 128 Barcode with XML Publisher

STEP#1 XML Tags and template 

 

Create or use existing oracle reports concurrent program. Change the output format under concurrent program definition to XML, run the concurrent program and get the XML tags. Map the RTF based on the XML tags generated.

STEP#2 Getting barcode fonts 

 

For barcode I have used Code 128 from IDAutomation (you can download from their site)

After installing the font on local machine assign one of the IDAutomation font to the field in RTF template (for example an order number and font can be eg: IDAutomationSC128M)

STEP#3 Barcode font reading by handheld or scanner 

 

To make the barcode to be read by scanner, the encoder java code provided by vendor has to be compiled and convert it into a java class file.

A.      Below is the class code save the code in a notepad and rename it as BarcodeUtil.java

B.      Move the class file with EBSO file structure, put it under JAVA_TOP ($JAVA_TOP/oracle/apps/xdo/template/rtf/util)

C.      Compile the Java file with .class file as

$ cd $JAVA_TOP/oracle/apps/xdo/template/rtf/util  

$ javac -g BarcodeUtil.java  This command will generate the class file as BarcodeUtil.class.