QR Codes in Oracle Reports

 QR codes are pretty popular, especially for paper based workflows and in logistics. "Quick Response Code" is a two dimensional (2D) visual representation of any alphanumeric string. Main purpose - same as with barcodes - is to integrate paper with computers, aka offer machine readability.

Depending on the use case, different variations of QR codes are established, like Micro-QR-Code, Secure-QR-Code (SQRC), iQR-Code. Typically their specifications differ in dimension and number of elements (which basically refers to the amount of data  that can be represented with it).

Also several (country specific) industrial standards (like JIS X 0510, GB/T 18284, ISO/IEC 18004) as well as de-facto standards (like OpenSource XZing) are in place, and so do many programs generating them (QR Code Generator).

QR Code Sample

Oracle Reports has the ability to integrate external Java programs while the report is executed. Existing reports can be modernized that way and additional functionality can be added. A nice use case is demonstrated for the Barcode Bean. The barcode is generated on the fly and added for any destination format. Find details about the concept, implementation and coding in

Chptr. 43 Building a Report with a Barcode

of the main reference manual Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports 11g Release 2 (11.1.2).

For QR Codes integration into Oracle Reports, the same concept comes into place:

How to Generate 2D Barcode / QR Code in Oracle Reports (Doc ID 1678110.1)

This brand new sample code comes with demo RDF, Java coding required and setup instructions. It is based on OpenSource QR code generators.

Give it a try and let us know your experience!

Comments:

Hi,

the link to Doc ID 1678110.1 is not working, can You pls. tell me where(how) I can find this note.

Thank You in advance.

Bye

Posted by guest on February 04, 2015 at 09:58 PM PST #

the link to Doc ID 1678110.1 is not working, can You pls. tell me where(how) I can find this note.

Thank You in advance.

Posted by Ahmed Ali on March 31, 2015 at 03:37 AM PDT #

Hello,

many thanks for your interest in Oracle Develoment products.

With respect to doc ID 1678110.1, I just checked the link and seeing it as valid working.
Note that it is a reference to the My Oracle Support knowledge base and only accessible with a valid MOS account.
Alternatively if you are inside MOS, just do a KM search for the note number 1678110.1 - this will lead you to the document.

Regards
Markus.

Posted by guest on March 31, 2015 at 04:32 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About


This is the official blog of the Proactive Support Team for Developer Tools: Oracle Forms, Oracle Reports, Apex, SQLDeveloper, ... . Find information about our activities, publications, product related information and more.

 

Follow @psdDevTools on Twitter

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today