Generate Barcodes in Oracle XML BI Publisher (BIP) & E-Business Suite (EBS)

This user guide explains how to generate barcodes in BI Publisher for Oracle developers who use E-Business Suite and similar products. IDAutomation also offers other implementation methods for Oracle:

• Streaming barcodes into Oracle BIP (An easier implementation without installing software)
• Oracle Reports Integration (For those using Oracle Reports instead of BIP)
• Crystal Reports Integration (for those using Crystal to connect to Oracle databases)
• Barcode Label Software for Windows (for those using Barcode Label Software to connect to Oracle databases)

NOTE: Only experienced developers with BIP report design, XML, and Java should perform the solution. IDAutomation only supports the Java barcode encoder available through our company. To troubleshoot barcode generation issues in BIP, ensure the Java barcode encoder performs in a stand-alone application (an example is included in the product).  If the Java barcode encoder performs in a stand-alone application but does not function in BIP, contact Oracle Support for more information.

The Java barcode encoder solution works with Oracle E-Business Suite (EBS) to print barcodes in BI/XML Publisher Reports which may be generated from the E-Business Suite concurrent program.

The implementation tutorial generates QR Code 2D barcodes in Oracle XML Publisher with RTF templates using the QR Code Font and Encoder. Version 2024 and greater of this product includes built-in support for ECI Encoding, Auto Mode, UTF-8, TLV and Base64, Swiss QR-Bill & Center Override.

• Other BIP Barcode Solutions:
  
  • Data Matrix
  • Code 128 and 1D barcodes
    
  • PDF417

• BIP Class Files:
  
  • IDAutomation_BIPublisher_DataMatrix.zip
    
  • IDAutomation_BIPublisher_Linear.zip
    
  • IDAutomation_BIPublisher_PDF417.zip
    
  • IDAutomation_BIPublisher_Universal.zip
    
  • IDAutomation_BIPublisher_QRCode.zip

• BIP QR Code Required Components for this Tutorial:
  
  • QR Code Font and Encoder Package (Developer License or greater includes a Developer Tools ZIP)
    
  • BI Publisher
  • Microsoft Word
  • barcodeutilQRCode.java file. Download the IDAutomation_BIPublisher_QRCode.zip.
  • Collection of JAR files from the jlib folder of the BI Publisher Desktop install.

BIP QR Code Implementation Tutorial

1. Install all BI Publisher requirements (BI Publisher, Microsoft Word).


2. Purchase, download, extract, and install the QR Code Font and Encoder(Developer License or greater).
   


3. The QR Code Font and Encoder Developer License includes the  Java Font Encoder class (stored in a .jar file) within the Developer Tools ZIP.
   


4. Place the JAR file in the classpath. Refer to the Java Classpath Instructions or view Oracle's documentation for additional help. Run the IDAutomation's "QRCodeBarcodeExample" program available in the Developer Tool's package to confirm the JAR file displays a scannable barcode or encoded data.
   


5. Download the IDAutomation_BIPublisher_QRCode.zip. It includes the barcodeutilQRCode.java and dependencies (Logger.class and XDOBarcodeEncoder.class) for creating the barcodeutilQRCode.class.
   
   
6. Open the barcodeutilQRCode.java file.
   


7. Update the barcode parameters in the .java file:
   

   /* Import the idautomation encoder class */
   import com.idautomation.fontencoder.qrcode.QRCodeEncoder;

   QRCodeEncoder qre = new QRCodeEncoder();
   boolean ApplyTilde = false;
   String EncodingMode = "Byte";
   int Version = 0;
   String ErrorCorrectionLevel = "M";
   boolean BestMask = false;
   return qre.FontEncode(DataToEncode,ApplyTilde,EncodingMode,ErrorCorrectionLevel,Version,BestMask);

   Class[] clazz = new Class[] { "".getClass() };  
    ENCODERS.put("qrcode",mUtility.getClass().getMethod("qrcode",clazz)); 



8. Compile the barcodeutilQRCode.java file to create the barcodeutilQRCode.class.


9. Access the jlib path and place the JAR files in the classpath: xdocore.jar, xmlparserv2.jar, collections.jar, aolj.jar, share.jar, xdoparser.jar, jewt4.jar, 18nAPI_v3.jar.


10. Place the barcodeutilQRCode.class into the barcodejar.jar.


11. Copy the IDAutomation_JavaFontEncoder_QRCode.jar and the barcodejar.jar to the jlib folder within the Template Builder for Word.
    


12. Place the JAR files into the RTF2PDF.jar, located in the jlib folder. In newer versions of BI Publisher, the JAR is named RTF2PDFv2.jar, it functions the same.
    


13. Make a backup copy of the RTF2PDF.jar file.


14. Open the RTF2PDF.jar using Winzip or 7-zip, then access the META-INF directory. Open and edit the MANIFEST.MF to include the JAR files at the end of the classpath list:
    

    Manifest-Version: 1.0
    Class-Path: ./activation.jar ./mail.jar ./xdochartstyles.jar ./bicmn.jar ./jewt4.jar 
    ./share.jar ./bipres.jar ./xdoparser.jar ./xdocore.jar ./xmlparserv2.jar 
    ./xmlparserv2-904.jar  ./i18nAPI_v3.jar ./versioninfo.jar 
    ./barcodejar.jar ./IDAutomation_JavaFontEncoder_QRCode.jar
    Main-Class: RTF2PDF

15. To render the barcode in a PDF report, reference the font within a config file in the BI Publisher config folder. Open the xdo example.cfg file:

16. Add a font entry for IDAutomation2D in the code area under the font setting:

    
    

    <!--IDAutomation 2D QR Code Font-->
    <font family="IDAutomation2D" style="normal">
    <truetype path="C:\windows\fonts\IDAutomation2D.ttf"/>
    </font>
    

17. In Word, access the BI Publisher file. Double-click the field to barcode and choose Add Help Text to open the Form Field.


18. In the Status Bar tab, enter the first command. Set the vendor to the specific class in the solution. For QR-Code, it is barcodeutilQRCode instead of BarcodeUtil.

    <?register-barcode-vendor:'ENCODER WRAPPER CLASS'; 'ENCODER NAME'?>
    

    
19. In the Help Key (F1), enter the second command:

    <?format-barcode:DATA_TO_ENCODE;'ENCODER_METHOD_NAME';'ENCODER_NAME'?>
    

    
20. To confirm the Java barcode font encoder encodes the data, view the document (PDF,RTF,HTML).
21. Return to the project and select the IDAutomation2D font from the font list. View the document.

JAR & Classpath Reference of IDAutomation Java Font Encoders

Additional Support

• How to Display Barcode Fonts (or other fonts) in Report Web Layout (Oracle Support Link)
  
• Oracle BI Publisher Report barcode is distorted
  
• IDAutomation Java Font Encoder class registry issue
  
• Installing Barcode Fonts on Unix or Linux for Oracle Reports
• Use Barcode Label Software Pro to print labels or reports directly from Oracle