New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
JoseG

Some values are not printing correctly

We are using Oracle Reports under Oracle eBS to print out serial numbers using the IDAutomation Code 128 Barcode Font Package.

The encoder is the PL/SQL’s Code128 function. For some values, we are getting barcodes where a box is shown:
image

One of the data strings that cause the error is ALB14087824315001. For this string, the encoded text we are getting from the PL/SQL’s Code128 function is ÌALBÇ.(n8?R!ÂÎ.

How can we solve this? Is this a recognized bug in the encoding or barcode font?


Application: Oracle eBS

07-24-15     1368 day(s) ago    

  Report Abuse

 

James

Best Answer

The encoded string ÌALBÇ.(n8?R!ÂÎ correctly represents ALB14087824315001 - make sure the font being applied is a standard Code 128 IDAutomation barcode font, having a font name that starts with IDAutomationC128.

If the above still does not produce the correct barcode in the environment, it may be that the issue is a regional characterset conflict. The solution would be to use the Universal Barcode Font Package and a respective Code 128 function from one of the Universal Font Encoders.

Posted 1368 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (2)

James
We cannot advise on an implementation-specific NLS_LANG setting.

Instead, use the Universal Fonts and the respective universal encoder function to resolve the issue (depending on the Oracle product used):

Oracle Reports: PLL Library (download, tutorial, and function list)
Oracle XML/BI Publisher: Java Barcode Font Encoder Class Library

Posted 1363 day(s) ago

()
()
   Report Abuse

JoseG
Our database characterset is defined as WE8MSWIN1252 in Oracle Reports (Oracle eBusiness Suite).

Using this characterset, do you think we will have the same issue?

Posted 1363 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook