Monday, March 31, 2008

BARCODE in XML Reports

For generating reports with barcodes

1) You should have barcode font in your system i.e. Font name FREE3OF9 (Find as attachment)

2) Copy and paste the attached “Free 3of9” font in your machine directories “C:\WINDOWS\Fonts” and $JAVA_HOME\ lib\fonts

Example Java path “C:\Program Files\Java\j2re1.4.2_10\lib\fonts”

3) There is one configuration file i.e. file name is “xdo” as attachment)

4) Copy and paste the configuration file in your “XML Publisher Desktop\Template Builder for Word\config”

Example “C:\Program Files\Oracle\XML Publisher Desktop\Template Builder for Word\config”
?xml version = '5.5.0' encoding = 'UTF-8'?
config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/"
fonts
font family="Free 3 of 9" style="normal" weight="normal"
truetype path="C:\Program Files\Java\j2re1.4.2_12\lib\fonts\FREE3OF9.TTF"/
/font
/fonts
/config

include the tags..i removed the tags.as some problems when posting..check the configuration file once..

5) Once you have done the above setups, you can see the “Free 3of 9” font type under your MSWORD font.

6) Which column you have to display as barcode, just put this font to that column.


One thing to take care is convert the data to upper case before generating the XML
do it at the SQL level only..

9 comments:

sarah said...

Hi Murthy,

I am trying to incorporate the barcode to one of my rtf xml template. I used the font 3 of 9 but i was not able to scan the barcode using my handheld device.
so i used the test sheet of IDAutomation_C128FontAdvantageDEMO and the reader read that. So i used the font IDAutomationSC128L. but I am new to java. So i dont know how to use the encoding java encoder and all. So can you please put a step by step method.

Thanks,
Sara

Anonymous said...

With 3 of 9, often called Code 39 you need to add a start and stop character "*" along with the barcoded data.

Hope this helps

Mike "O"
Advance computers & Electronics, Inc.

Anonymous said...

Hi Murthy,

can you please attach configuration file as well as code39 file in a suitable place.

Regards,
Kalyan

Saravanan (Saro) said...

My client buy material from his supplier and stock it to main Warehouse, then distribute the material to Level 1 Organization (Wholesale stores). Level 1 Org (Wholesale Stores), distribute the material to Level 2 (Retail Stores) and then to customers.

My client wants to track all the materials through Barcoding from .

Please let me know at what stage we can generate Barcoding/RFID and what would be the procedure to generate Barcoding/RFID?

Kindly let me know in detail.

Puneet said...

Hi Murthy

Please let me know if it is possible to print the barcode directly from Oracle without using the mobile supply chain module licenses.
We want to do it in two ways:
1/ Connect the lable printers directly with Oracle and print the bar code
2/ print the bar codes from Oracle directly on normal paper reports

Would appreciate your quick response.

Thanks
Puneet

Raju said...


barcode scaning is not working when we take print form EBS but when take print from rtf preview scan working propeerly pls help me on this

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.