Resolved Questions

JoseG

Some values are not printing correctly

Tagged With:-

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:

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 9.3 year(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 character set 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 9.3 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

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 9.3 year(s) ago

(0)

Report Abuse

JoseG

Our database character set is defined as WE8MSWIN1252 in Oracle Reports (Oracle eBusiness Suite).

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

Posted 9.3 year(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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