Here we will discuss on how to automatically print Barcodes on a zebra printer from Oracle concurrent program.
Below are the 3 approaches that we tried and was successful with the third approach.
1) Print Labels on a Zebra printer using BI Publisher
The first approach we tried was to print barcodes using BI(formerly XML) Publisher. The report generates a PDF output and should print directly on a Zebra printer using PASTA driver. For some reason the report was not printing directly on a printer. The PDF opened in window and printed seperately/manually using Windows driver was working fine but not meeting our requirement of automatic printing. Hence we had to try second approach.
2) Print Labels using Zebra Enterprise Connector Solution
The Zebra Enterprise Connector Solution is designed to streamline the printing
process for companies using ERP systems such as Oracle BI Publisher. The Zebra
Enterprise Connector Solution helps to lower middleware costs, overhead, and
pre-printer licensing fees. It can be used with an unlimited number of
Zebra ZPL-II printers without additional per-printer licensing fees. We didnt do much research on this as were looking for an approach with minimal cost. More details on this is available at the website of Zebra
3) Print Lables on Zebra printers using Zebra Programming Language(ZPL)
The second and successful approach was to print labels using ZPL. A text output with all the zebra codes was created and which would ultimately print Barcode images on a printer. A normal regular lp command for printing text is used to print over Zebra Printers.
Below is an example of how to print Barcodes
^XA
^FO40,35^AR,10,10^FDItem :^FS
^FO40,115^AR,10,10^FDItem Description:^FS
^FO40,165^AR,10,10^FDQuantity :^FS
^FO40,245^AR,10,10^FDDiscrete Job# :^FS
^FO40,295^AR,10,10^FDSupply Sub :^FS
^FO40,375^AR,10,10^FDLocator :^FS
^FO40,455^AR,10,10^FDDestination Sub :^FS
^FO40,505^AR,10,10^FDLocator :^FS
^FO40,555^AR,10,10^FDOrder # :^FS
^FO40,635^AR,10,10^FDLine # :^FS
^FO40,715^AR,10,10^FDOrder Type :^FS
^FO40,765^AR,10,10^FDDepartment :^FS^FO305,765^AR,10,10^FDResource Group :^FS
^FO40,845^AR,10,10^FDWork Center :^FS^FO305,845^AR,10,10^FDItem Sequence :^FS
^FO40,925^AR,10,10^FDAsm Item # :^FS^FO305,925^AR,10,10^FDAsm Item Desc :^FS
^FO265,35^BY3^B3N,N,50,Y,Y^FD199395B^FS
^FO265,115^AR,10,10^FDFILTER, LUBE OIL.^FS
^FO265,165^BY3^B3N,N,55,Y,N^FD2^FS
^FO265,245^AR,10,10^FD613467^FS
^FO265,295^BY3^B3N,N,50,Y,N^FDASM^FS
^FO265,375^BY3^B3N,N,50,Y,N^FDASM.REW..^FS
^FO265,555^BY3^B3N,N,50,Y,N^FD1264076^FS
^FO265,635^BY3^B3N,N,55,Y,N^FD1^FS
^FO265,715^AR,10,10^FDMove Order^FS
^FO50,795^AR,10,10^FD6400^FS
^FO375,795^AR,10,10^FD0047^FS
^FO70,875^AR,10,10^FDASMVH12.4.5.A^FS
^FO335,875^AR,10,10^FD3^FS
^FO70,955^AR,10,10^FDL7044GSI-1021598^FS
^FO335,955^AR,10,10^FDP2212J13 L7044 GSI W/ESM & AFR^FS
^XZ
More details on how to write codes using ZPL can be found in the website of zebra
The output of the above code is shown below.
31 Comments:
Hi Suresh!
Can I validate a Flexfield? I have a Flexfield that holds the barcode of the products, and I want to validade this so the user can´t type the same barcode twice.
Thanks and congratulations for the nice blog, it helps me a lot.
How are you storing bar code in the attribute field.
Do you mean to say that you have item number in one of the attribute and need to display this value conditionally.
Hi Suresh,
We have a requirement to print barcode lables through Zebra printer.We are running in Sun solaris system and will ZPL will work in Sun Solaris system?
As discussed in the post you can achieve that using either the ZPL language or the method discussed.
Hi Mr. Vaishya, i'm developing oracle forms on my ERP system to print serial number LABEL with barcodes.
I have a little problem:
I cannot find a solution (ZPL command) to center a barcode on LABEL. There's any ZPL command i could use?
Luca, I dont have Zebra printer anymore as I had done this with one of my previous clients. I will still try to find out and let you know if I know anything.
Thanks,
Suresh
Hi Vaishya,
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.
How do you transact item from Level1 ORg to Level2 Org and at what stages you are printing a report.
If this is being done using a scanning process then you would need barcode at each stage for Item, source org, source subinv, dest org and dest subinv. Also locators if item is locator controlled in the respective subinventory.
Regards,
Suresh
Hi Suresh,
I have a oracle report made with ZPL.When I print to a file and later to the Zebra printer it works. But if I print directly to the printer it doesn't work.
What I'm doing wrong ?
Please, help me.
Luís Horta
We had similar problem when I was building one of the barcode report to be printed on Zebra printer directly from oracle applications.
The alternate solution that we approached is discussed in this post.
Suresh,
We are trying to print a label created with oracle 6i. It doesn't contain any barcodes. But when we send the output to print in Zebra printer it prints with very small fonts and all the data comes at the top left corner of the page. After reading ur blog i was wondering to take the zpl method but couldn't understand how to integrate that with Oracle SRS and print through unix. Can you provide some help?
Anindya,
How does your report look when you view in the output. Is it a text report or PDF report?
Create a PDF report, if output contains only text then that should just work fine.
Thanks Suresh, this site is really useful for me.
www.pdaprinter.blogspot.com
Hello Suresh,
The barcode labels that we print on our Zebra Printer using Oracle BI Publisher are not readable by the scanner.
The same barcode labels printed using OPTIO software are getting read by the scanner.
What are we missing?
Suresh
Zebra printers were purchased by one of customer and thought of going ahead with ZPL for Label generation. Just thought of knowing is there any license cost involved for usage of ZPL.Hope since Printers were purchased ,separate licenses were not required to buy.Do u have any idea on this
Ramesh
This is great. I need a printer for my Plastic card printing purpose.
Thanks for the detailed and informative explanation and example of how to print a Barcode using ZPL.
I still don't see exactly what ZPL command actually triggers the Barcode, but I will find out after I review the ZPL commands, I'm sure.
Thanks.
Hi,
Can you explain me the complete steps for zebra printer configuration in oracle apps 11i.
I have a similar requirement to print barcode labels directly from oracle concurrent program.
Thanks
Sudheer.
Hi I just want to ask if is it possible to align barcode automatically base on character length?or can i use field block in barcode?if yes how can i do it?
Thanks
Angelo
Dear Suresh,
I'm not sure if you will see this message or not. We are trying to print labels from Oracle to a Zebra printer using ZPL language. Only problem is it is printing the zpl code and not the intended labels. Did you come across such an issue and if so what could be the problem?
Please advise.
Thank You,
--Raghu
Dear Suresh,
I'm not sure if you will see this message or not. We are trying to print labels from Oracle to a Zebra printer using ZPL language. Only problem is it is printing the zpl code and not the intended labels. Did you come across such an issue and if so what could be the problem?
Please advise.
Thank You,
--Raghu
Best printer ever!
hi,
i am using oracle application express, i have created one sample applications. i have created the envirionment on the apex.oracle.com, and my details are below;
workspace=idrees
user=demo
password=demo
application=scott
page=barcode-copy
i have the print button, but i don't know how to code so the particular row's barcode is sent to printer.
i have oracle forum thread for it,
https://community.oracle.com/thread/3943276
Kindly look into it and let me know if you could give some guidance
Regards.
Muhammad Idrees.
hi,
I had a problem with this below coding, not able make equip_id in the second line,
now both coming in the same line
anybody please help to sort this
^XA
^PR5
^FO40,35^AR,10,10^FDCOMPANY^FS
^FO140,115^AR,10,10^FDEQUIP_ID^FS
^PQ1
^XZ
Hello Suresh,
I need your help with printing barcode labels using Zebra ZE500 Printer in Oracle apps 11i. After Label printer setup i just tired printing simple text file with Zebra codes as its working fine. Now when i install Enterprise designer, am not able to open xml file using datafile. Would appreciate if someone could confirm how to setup this.
Thanks,
Mustafa
Nice Blog! This Blog is very informative. Keep sharing this type of blog. We also provide barcode printer at right price. We have expertise in supplying hardware and software. For more info visit.
Hello, i have found your blog on google while searching about the Barcode printer and here i have read your valuable and helpful information...your blog have impressive blog content...Thank you and keep updating with some new blog post in printer...
Are you looking for a shipping label printer in Dubai? If yes, then your search ends here. Whether you print labels, tags or wristbands, we provide you with top quality, and advanced functionality based barcode printers at the best rate. You can shop printers at our site or let our team recommend the right barcode printer for you. https://barcosofttech.doodlekit.com/home
Very useful post i really appreciate thanks for sharing such a nice post. printing services website
This Blog is very informative. Keep sharing this type of blog.
A barcode scanner can read the specific sequence of bars and spaces, which indicate numbers and other things. Similarly, a Zebra barcode printer is available to print the barcode labels.
i just want to say your content is very informative it will help you if you addwhere to buy zebra printersthis in your article
Post a Comment