Printing labels from OracleEBS
Comments
-
the approach is explained but more details on the kind of code or solution developed will help
0 -
I guess on 11i.R12, the label prints are directly possible. Even the programs can be set in such a way that it would call the printer agent.
So, is this different that what is already available in Oralce?
0 -
I guess on 11i.R12, the label prints are directly possible. Even the programs can be set in such a way that it would call the printer agent.
So, is this different that what is already available in Oralce?
Hi
Printing labels with Bar Codes was the requirement and the customer wanted to get the Bar Code labels printed only on their shared resource ZABRA Printers.To get the Label output to the tune of zebra printer it needed an intermediate software which we actually bypassed by writing scripts directly to the Printer's post script code.
This solution was given in 11i10.
I am not sure if R12 has provided an out of box feature and it helps the above.
Please share the details so I can update the document accordingly.
regards,
Raha Mohan
1 -
This is great!. We are looking for a similar solution, can you pl outline the approach that could help our tech team to write the codes? Appreciate your help!
--RS
0 -
This is great!. We are looking for a similar solution, can you pl outline the approach that could help our tech team to write the codes? Appreciate your help!
--RS
hi, I can not answer for the a shared case study (btw thanks a lot for this to Raha Mohan ). However we followed a similar approach, however we generate much more labels than mentioned in the case study. All runs smoothly without any 3rd party software. We used XSLT layout templates in BI Publisher to generate labels in a printer specific language (in our case Intermec, however we could implement any language as long as it's not some binary format).
We made a 3 steps approach:
1. generic data definition that fetches almost any data that might be needed on a certain label
2. different layout templates that generate different labels depending on the different needs
3. generic sub-templates that help to simplify the development of new layout templates from step 2, e.g. some pre-defined XSLT templates for generating barcodes etc.
So I'd say: check what your label printer's languages are. Most of them have some (proprietary) language for printing, or do it as mentioned in the case study and generate postscript files (putting barcodes in there with some barcode fonts for example, or get licenses for barcode-image generations and put the images into the postscript) and then send the postscript output to the printers.
All that goes quite fine with BI Publisher.
regards,
David.
PS: Forgot to mention, but WAY BETTER approach with all this: latest label printers support XML based printing. You generate a label layout with some (proprietary) software and store the layout files for example directly on the printers. Then just send pure XML files with data and of course a reference to the layout file and the printer will generate the output. That's the approach I'd recommend nowadays. Just pure XML output from the ERP either with the standard XML output that comes with Warehouse Management or with some custom BI Publisher reports.
0 -
hi, I can not answer for the a shared case study (btw thanks a lot for this to Raha Mohan ). However we followed a similar approach, however we generate much more labels than mentioned in the case study. All runs smoothly without any 3rd party software. We used XSLT layout templates in BI Publisher to generate labels in a printer specific language (in our case Intermec, however we could implement any language as long as it's not some binary format).
We made a 3 steps approach:
1. generic data definition that fetches almost any data that might be needed on a certain label
2. different layout templates that generate different labels depending on the different needs
3. generic sub-templates that help to simplify the development of new layout templates from step 2, e.g. some pre-defined XSLT templates for generating barcodes etc.
So I'd say: check what your label printer's languages are. Most of them have some (proprietary) language for printing, or do it as mentioned in the case study and generate postscript files (putting barcodes in there with some barcode fonts for example, or get licenses for barcode-image generations and put the images into the postscript) and then send the postscript output to the printers.
All that goes quite fine with BI Publisher.
regards,
David.
PS: Forgot to mention, but WAY BETTER approach with all this: latest label printers support XML based printing. You generate a label layout with some (proprietary) software and store the layout files for example directly on the printers. Then just send pure XML files with data and of course a reference to the layout file and the printer will generate the output. That's the approach I'd recommend nowadays. Just pure XML output from the ERP either with the standard XML output that comes with Warehouse Management or with some custom BI Publisher reports.
Excellent David!
Really appreciate for sharing your approach to address this issue. I will work with our tech team to think this this direction.
Thanks again for a great input!
--RS
0