Tuesday, February 2, 2021

How to create Barcode in Oracle EBS and Report 10g,11g,12c.. using jar file

01. Place the 1 jar files and 1 class files in the F:\Middleware\product\reports\jlib\ folder
(oraclebarcode.jar, qrcode.class)

02. Edit the REPORTS_CLASSPATH as below

Regedit >

( oraclebarcode.jar )

F:\Middleware\product\reports\jlib\oraclebarcode.jar;F:\Middleware\product\reports\jlib


REPORTS_PATH

F:\Middleware\product\reports\jlib\oraclebarcode.jar;F:\Middleware\product\reports\jlib


03. Modify 2 Lines the Reports Server configuration file (rwserver.conf) in order to add/modify the classPath Reports engine attribute :

<engine minEngine="1" maxIdle="30" maxEngine="1" id="rwEng" engLife="50" class="oracle.reports.engine.EngineImpl" classPath="F:\Middleware\product\reports\jlib\oraclebarcode.jar;F:\Middleware\product\reports\jlib">


For building BARCode report:


1. import java class file 'barcode.class' in report.

2. create this funtion:




function CF_1Formula return VarChar2 is
myFileName varchar2(500);
result varchar2(500);
barcodeData VarChar2(50) := :empno || :deptno;
begin
myFileName := srw.create_temporary_filename;
barcodemaker.setBarWidthInch(globals.bcobj, 0.005);
barcodemaker.setBaseCodeData(globals.bcobj,barcodeData);
barcodemaker.setBarCodeType(globals.bcobj,globals.barcode_to_use);
barcodemaker.setFullPath(globals.bcobj, myFileName);
barcodemaker.renderBarCode(globals.bcobj);
return(myFileName);
end;










-------------


https://renaps.com/en/blog/how-to/quick-reference-to-building-a-paper-report-with-a-barcode-javabean?fbclid=IwAR0IB2bHk4gn79MIHffVxomGoPXr3BeuVHRsxLnVZ926jBzbxVKuc4ETppM

https://oradbvn.wordpress.com/2014/06/10/install-configure-barcode-fonts-in-oracle-report-server/

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...