How might one create a barcode image as a custom field in Apps?
(I found this unanswered on OpenIFS.)
Best answer by durette 12 March 2021, 00:01
Custom fields do not support BLOBs, so doing this as a proper image is out of the question. However, I was able to develop a work-around using a text field, in Code 39, using Unicode characters for the fat and thin bars.
First, create a custom package. (See attached for C_BARCODE_API. You may need to edit the grants.)
Next, create a custom field, read-only, of type “Expression”. In this example, the barcode shows the order number on a Shop Order.
Idea: push the image in a sticky noteNot that easy, but it would contain possibly the following steps:Create a barcode image of the key object (ie. shop order number and sticky note will contain barcode of the number)Insert a row in fnd_note_bookInsert a row in fnd_not_page with the note_id as prepared for fnd_note_book. The note text will contain the image.
There are several web services available that can be called from Oracle to pull down a BLOB of a barcode image.
You can store the BLOB image in the sticky note, but the image needs to be converted to an RTF format if you want it displayed as an image/picture.
I like the idea of the project, but it would take some research to find a BLOB to RTF conversion utility for Oracle (unless someone has one handy).
Here’s an open-source PL/SQL package that outputs a barcode image:
(Its license is permissive, provided the attribution notice is retained.)
Why not add this as document attachment? APIs are available and fairly simple to use..
Alternatively attach as media attachment.
Ask the community for help!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.